Function mutateManySql

mutateManySql<T>(configOrConnection, sql, options?): 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
- Optional options: 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 lib/sqlHelpers.ts:538
mutateManySql<T>(configOrConnection, sql, params, options?): 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
- Optional options: 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 lib/sqlHelpers.ts:554

Generated using TypeDoc