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

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().