Options
All
  • Public
  • Public/Protected
  • All
Menu

Class Deferrable

Can be used to make foreign key constraints deferrable and to set the constaints within a transaction. This is only supported in PostgreSQL.

The foreign keys can be configured like this. It will create a foreign key that will check the constraints immediately when the data was inserted.

class MyModel extends Model {}
MyModel.init({
  foreign_id: {
    type: DataTypes.INTEGER,
    references: {
      model: OtherModel,
      key: 'id',
      deferrable: Sequelize.Deferrable.INITIALLY_IMMEDIATE
    }
  }
}, { sequelize });

The constraints can be configured in a transaction like this. It will trigger a query once the transaction has been started and set the constraints to be checked at the very end of the transaction.

sequelize.transaction({
  deferrable: Sequelize.Deferrable.SET_DEFERRED
});

Hierarchy

  • Deferrable

Index

Constructors

Properties

Methods

Constructors

constructor

Properties

Static Readonly INITIALLY_DEFERRED

INITIALLY_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); NOT: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any })

Static Readonly INITIALLY_IMMEDIATE

INITIALLY_IMMEDIATE: { INITIALLY_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); INITIALLY_IMMEDIATE: any; NOT: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any })

Static Readonly NOT

NOT: { INITIALLY_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); INITIALLY_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); NOT: any; SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any })

Will set the constraints to not deferred. This is the default in PostgreSQL and it make it impossible to dynamically defer the constraints within a transaction.

Static Readonly SET_DEFERRED

SET_DEFERRED: { INITIALLY_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); INITIALLY_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); NOT: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any })

Will trigger an additional query at the beginning of a transaction which sets the constraints to deferred.

Static Readonly SET_IMMEDIATE

SET_IMMEDIATE: { INITIALLY_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); INITIALLY_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); NOT: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & (() => { toSql: any; toString: any }); SET_DEFERRED: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: { INITIALLY_DEFERRED: any; INITIALLY_IMMEDIATE: any; NOT: any; SET_DEFERRED: any; SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any }); SET_IMMEDIATE: any; toString: any } & ((constraints: string[]) => { __#[email protected]#constraints: string[]; toSql: any; toString: any })

Will trigger an additional query at the beginning of a transaction which sets the constraints to immediately.

Methods

toSql

  • toSql(_queryGenerator: AbstractQueryGenerator): void

  • Parameters

    • _queryGenerator: AbstractQueryGenerator

    Returns void

toString

  • toString(queryGenerator: AbstractQueryGenerator): void

  • Parameters

    • queryGenerator: AbstractQueryGenerator

    Returns void

Static toString

  • toString(queryGenerator: AbstractQueryGenerator): void

  • Parameters

    • queryGenerator: AbstractQueryGenerator

    Returns void

Generated using TypeDoc