Function mutateManySqlPool

mutateManySqlPool<T>(config, sql, options?): Promise<Results<ToOutBinds<T>>>
Uses a connection from a connection pool to execute SQL to mutate the database via the executeMany command.

This takes an array of bindParameters and loops over them.

If you need to run multiple different SQL mutations in a single transaction use mutateManySQL with a connection from the pool instead.
Type Parameters
- T
Parameters
- config: ConnectionAttributes
  
  The DBConfig object to get the connection from
- 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:586
mutateManySqlPool<T>(config, sql, params, options?): Promise<Results<ToOutBinds<T>>>
Uses a connection from a connection pool to execute SQL to mutate the database via the executeMany command.

This takes an array of bindParameters and loops over them.

If you need to run multiple different SQL mutations in a single transaction use mutateManySQL with a connection from the pool instead.
Type Parameters
- T
Parameters
- config: ConnectionAttributes
  
  The DBConfig object to get the connection from
- 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:604

Generated using TypeDoc