method

sqlite.SQLTagStore.run

stringElements: TemplateStringsArray,
...boundParameters: SQLInputValue[]

Executes the given SQL query, which is expected to not return any rows (e.g., INSERT, UPDATE, DELETE).

This function is intended to be used as a template literal tag, not to be called directly.

@param stringElements

Template literal elements containing the SQL query.

@param boundParameters

Parameter values to be bound to placeholders in the template string.

@returns

An object containing information about the execution, including changes and lastInsertRowid.

Referenced types

type SQLInputValue =
| null
| number
| bigint
| string
| NodeJS.ArrayBufferView

interface StatementResultingChanges

  • changes: number | bigint

    The number of rows modified, inserted, or deleted by the most recently completed INSERT, UPDATE, or DELETE statement. This field is either a number or a BigInt depending on the prepared statement's configuration. This property is the result of sqlite3_changes64().

  • lastInsertRowid: number | bigint

    The most recently inserted rowid. This field is either a number or a BigInt depending on the prepared statement's configuration. This property is the result of sqlite3_last_insert_rowid().