Interface TransactionOptions

Options provided when the transaction is created

interface TransactionOptions {
    benchmark?: boolean;
    constraintChecking?: ConstraintChecking | Class<ConstraintChecking>;
    isolationLevel?: null | IsolationLevel;
    logging?: false | ((sql, timing?) => void);
    readOnly?: boolean;
    transaction?: null | Transaction;
    type?: TransactionType;
}

Hierarchy (view full)

Properties

benchmark? constraintChecking? isolationLevel? logging? readOnly? transaction? type?

Properties

Optional benchmark

benchmark?: boolean

Pass query execution time in milliseconds as second argument to logging function (options.logging).

Optional constraintChecking

constraintChecking?: ConstraintChecking | Class<ConstraintChecking>

Sets the constraints to be deferred or immediately checked. PostgreSQL only

Optional isolationLevel

isolationLevel?: null | IsolationLevel

Sets the isolation level of the transaction.

Optional logging

logging?: false | ((sql, timing?) => void)

A function that gets executed while running the query to log the sql.

Type declaration

    • (sql, timing?): void

    • Parameters

      • sql: string
      • Optional timing: number

      Returns void

Optional readOnly

readOnly?: boolean

Whether this transaction will only be used to read data. Used to determine whether sequelize is allowed to use a read replication server.

Optional transaction

transaction?: null | Transaction

Parent transaction. Will be retrieved from CLS automatically if not provided or if null.

Optional type

type?: TransactionType

Sets the type of the transaction. Sqlite only

Settings

Member Visibility

Theme

On This Page

benchmarkconstraintCheckingisolationLevelloggingreadOnlytransactiontype