Symbol

Database.run

run<ParamsType extends SQLQueryBindings[]>(sql: string, ...bindings: ParamsType[]): Changes

Execute a SQL query without returning any results.

This does not cache the query, so if you want to run a query multiple times, you should use prepare instead.

Under the hood, this calls sqlite3_prepare_v3 followed by sqlite3_step and sqlite3_finalize.

The following types can be used when binding parameters:

@param sql

The SQL query to run

@param bindings

Optional bindings for the query

@returns

Database instance

db.run("CREATE TABLE foo (bar TEXT)");
db.run("INSERT INTO foo VALUES (?)", ["baz"]);

Useful for queries like:

Referenced types

An object representing the changes made to the database since the last run or exec call.

changes: number
The number of rows changed by the last run or exec call.
lastInsertRowid: number | bigint
If safeIntegers is true, this is a bigint. Otherwise, it is a number.