Function mutateManySql

mutateManySql<T>(
    configOrConnection: ConfigOrConnection,
    sql: Sql,
    options?: ExecuteManyOptions,
): Promise<Results<ToOutBinds<T>>>
Executes SQL mutate the database via the executeMany command.

This takes an array of bindParameters and loops over them.
Type Parameters
- T
Parameters
- configOrConnection: ConfigOrConnection
  Either a dbConfig object or the connection to execute with
- sql: Sql
  The SQL to execute - the result of the sql template tag - Should be some sort of mutation
- Optionaloptions: ExecuteManyOptions
  The oracle options for the SQL execution. options.autoCommit is set by default based on if configOrConnection is config.
Returns Promise<Results<ToOutBinds<T>>>
The result object for the execution. There are many results as there are many executions.
- Defined in sqlHelpers.ts:539
mutateManySql<T>(
    configOrConnection: ConfigOrConnection,
    sql: string,
    params: BindParameters[],
    options?: ExecuteManyOptions,
): Promise<Results<ToOutBinds<T>>>
Executes SQL mutate the database via the executeMany command.

This takes an array of bindParameters and loops over them.
Type Parameters
- T
Parameters
- configOrConnection: ConfigOrConnection
  Either a dbConfig object or the connection to execute with
- sql: string
  The SQL to execute - Should be some sort of mutation
- params: BindParameters[]
  An array of the Parameters to pass into the SQL execution. executeMany loops over them in a single transaction
- Optionaloptions: ExecuteManyOptions
  The oracle options for the SQL execution. options.autoCommit is set by default based on if configOrConnection is config.
Returns Promise<Results<ToOutBinds<T>>>
The result object for the execution. There are many results as there are many executions.
- Defined in sqlHelpers.ts:555

Function mutateManySql

Type Parameters

Parameters

Returns Promise<Results<ToOutBinds<T>>>

Type Parameters

Parameters

Returns Promise<Results<ToOutBinds<T>>>

Settings