db/insert

Documentation

• source: db/insert.ts

Overview

Classes

Insert

execute()

Executes a single parameterized INSERT statement. *

static execute(sql: string, parameters: any, datasourceName: string): void;

Parameter	Type	Description
sql	string	The SQL query to execute, with '?' placeholders for parameters.
parameters	any	An optional array of values to replace the '?' placeholders.
datasourceName	string	The name of the database connection to use (optional).

Returns

• Type: void
• Description: An array of records representing the result of the insertion (e.g., generated keys).

executeMany()

Executes multiple parameterized INSERT statements as a batch operation. *

static executeMany(sql: string, parameters: any, datasourceName: string): void;

Parameter	Type	Description
sql	string	The SQL query to execute, with '?' placeholders for parameters.
parameters	any	An optional array of parameter arrays, where each inner array corresponds to one execution of the SQL statement.
datasourceName	string	The name of the database connection to use (optional).

Returns

• Type: void
• Description: An array of records representing the results of the batched insertions.