Execute a delete query.
The SQL to execute.
An object containing query parameters for the query. Each parameter will be preceded with a colon in query.
An object that has an affectedRows property indicating the number of rows affected (changed) by the query.
Execute an insert query.
The SQL to execute.
An object containing query parameters for the query. Each parameter will be preceded with a colon in query.
A promise that will be resolved with an object describing the result of the insert. An insertId should be present on the object if available (e.g. if the insert inolved a generated column).
Execute a raw query.
The SQL to execute.
An object containing query parameters for the query. Each parameter will be preceded with a colon in query.
A promise that shall be resolved if the query succeeds, or rejected otherwise.
Execute a select query.
The SQL to execute.
An object containing query parameters for the query. Each parameter will be preceded with a colon in query.
A promise that is resolved with an array of query rows. Each row should have key-value pairs, where the keys are the selected columns.
Execute an update query.
The SQL to execute.
An object containing query parameters for the query. Each parameter will be preceded with a colon in query.
An object that has an affectedRows property indicating the number of rows affected (changed) by the query.
Generated using TypeDoc
An Executer executes database queries.