oracle-helpers
    Preparing search index...

    Function mutateSqlPool

    • Uses a connection from a connection pool to execute SQL to mutate the database

      If you need to run multiple mutations in a single transaction use mutateSQL 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: ExecuteOptions

        The oracle options for the SQL execution. options.autoCommit is forced to true, as the connection is automatically closed afterwards

      Returns Promise<Result<ToOutBinds<T>>>

      The result object for the execution

    • Uses a connection from a connection pool to execute SQL to mutate the database

      If you need to run multiple mutations in a single transaction use mutateSQL 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

      • Optionalparams: BindParameters

        The Parameters to pass into the SQL execution

      • Optionaloptions: ExecuteOptions

        The oracle options for the SQL execution. options.autoCommit is forced to true, as the connection is automatically closed afterwards

      Returns Promise<Result<ToOutBinds<T>>>

      The result object for the execution