Interface: IExtensionDatabase
Defined in: Extensions/ExtensionApiDtos.ts:1023
Per-extension SQLite database handle returned by IStorageApi.openDatabase.
Bind parameters must be string, number, boolean, null, or binary
(Uint8Array / ArrayBuffer) — the host rejects anything else rather than
let the driver coerce it. Binary binds as a real BLOB and reads back as a
Uint8Array; there is no need to base64 it yourself.
Methods
close()
close():
Promise<void>
Defined in: Extensions/ExtensionApiDtos.ts:1033
Returns
Promise<void>
exec()
exec(
sql):Promise<void>
Defined in: Extensions/ExtensionApiDtos.ts:1024
Parameters
sql
string
Returns
Promise<void>
query()
query<
T>(sql,params?):Promise<T[]>
Defined in: Extensions/ExtensionApiDtos.ts:1025
Type Parameters
T
T = unknown
Parameters
sql
string
params?
unknown[]
Returns
Promise<T[]>
queryOne()
queryOne<
T>(sql,params?):Promise<T|undefined>
Defined in: Extensions/ExtensionApiDtos.ts:1026
Type Parameters
T
T = unknown
Parameters
sql
string
params?
unknown[]
Returns
Promise<T | undefined>
run()
run(
sql,params?):Promise<{changes:number;lastInsertRowid:string|number; }>
Defined in: Extensions/ExtensionApiDtos.ts:1027
Parameters
sql
string
params?
unknown[]
Returns
Promise<{ changes: number; lastInsertRowid: string | number; }>
transaction()
transaction<
T>(work):Promise<T>
Defined in: Extensions/ExtensionApiDtos.ts:1032
Run multiple statements in a transaction. Auto-rollback on throw.
Type Parameters
T
T
Parameters
work
(tx) => Promise<T>
Returns
Promise<T>