Deferrable() -> object

View code

A collection of properties related to deferrable constraints. It can be used tomake foreign key constraints deferrable and to set the constraints within atransaction. This is only supported in PostgreSQL.

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

sequelize.define('Model', {
  foreign_id: {
    type: Sequelize.INTEGER,
    references: {
      model: OtherModel,
      key: 'id',
      deferrable: Sequelize.Deferrable.INITIALLY_IMMEDIATE
    }
  }
});

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

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

INITIALLY_DEFERRED()

View code

A property that will defer constraints checks to the end of transactions.

INITIALLY_IMMEDIATE()

View code

A property that will trigger the constraint checks immediately

NOT()

View code

A property that will set the constraints to not deferred. This isthe default in PostgreSQL and it make it impossible to dynamicallydefer the constraints within a transaction.

SET_DEFERRED(constraints)

View code

A property that will trigger an additional query at the beginning of atransaction which sets the constraints to deferred.

Params:

SET_IMMEDIATE(constraints)

View code

A property that will trigger an additional query at the beginning of atransaction which sets the constraints to immediately.

Params:

This document is automatically generated based on source code comments. Please do not edit it directly, as your changes will be ignored. Please write on IRC, open an issue or a create a pull request if you feel something can be improved. For help on how to write source code documentation see JSDoc and dox