oracle-helpers
    Preparing search index...

    Function mutateManySqlPool

    • 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

      • 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.

    • 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

      • 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.