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

    • Optional options: 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

    • Optional params: BindParameters

      The Parameters to pass into the SQL execution

    • Optional options: 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

Generated using TypeDoc