Skip to main content

Interface: IStatement

Extends​

  • Disposable

Methods​

all()​

all(...args): any[]

Runs the SQL statement, returning an array of objects with the name of the columns and matching values.

Parameters​

args​

...any[]

The bound parameters for the statement.

Returns​

any[]

finalize()​

finalize(): void

Free all resources associated with this statement. No other function can be called on it afterwards. Idempotent.

Aliased as Symbol.dispose, so using stmt = db.prepare(...) finalizes the statement at scope exit.

Returns​

void

run()​

run(...args): void

Runs the SQL statement, ignoring the result. This is commonly used for CREATE, INSERT and statement of that sort.

Parameters​

args​

...any[]

The bound parameters for the statement.

Returns​

void

toString()​

toString(): string

Stringify the statement by expanding the SQL query.

Returns​

string