Function describeDeferrableTest

test/integration/sequelize/deferrable.test.js:14–82

(title, defineModels)

describe(Support.getTestDialectTeaser(class="st">'Sequelize'), () => {
  describe(class="st">'Deferrable', () => {
    const describeDeferrableTest = (title, defineModels) => {
      describe(title, () => {
        beforeEach(function() {
          this.run = async function(deferrable, options) {
            options = options || {};

            const taskTableName      = options.taskTableName || `tasks_${Support.rand()}`;
            const transactionOptions = { deferrable: Sequelize.Deferrable.SET_DEFERRED, ...options };
            const userTableName      = `users_${Support.rand()}`;

            const { Task, User } = await defineModels({ sequelize: this.sequelize, userTableName, deferrable, taskTableName });

            return this.sequelize.transaction(transactionOptions, async t => {
              const task0 = await Task
                .create({ title: class="st">'a task', user_id: -1 }, { transaction: t });

              const [task, user] = await Promise.all([task0, User.create({}, { transaction: t })]);
              task.user_id = user.id;
              return task.save({ transaction: t });
            });
          };
        });

        describe(class="st">'NOT', () => {
          it(class="st">'does not allow the violation of the foreign key constraint', async function() {
            await expect(this.run(Sequelize.Deferrable.NOT)).to.eventually.be.rejectedWith(Sequelize.ForeignKeyConstraintError);
          });
        });

        describe(class="st">'INITIALLY_IMMEDIATE', () => {
          it(class="st">'allows the violation of the foreign key constraint if the transaction is deferred', async function() {
            const task = await this
              .run(Sequelize.Deferrable.INITIALLY_IMMEDIATE);

            expect(task.title).to.equal(class="st">'a task');
            expect(task.user_id).to.equal(1);
          });

          it(class="st">'does not allow the violation of the foreign key constraint if the transaction is not deffered', async function() {
            await expect(this.run(Sequelize.Deferrable.INITIALLY_IMMEDIATE, {
              deferrable: undefined
            })).to.eventually.be.rejectedWith(Sequelize.ForeignKeyConstraintError);
          });

          it(class="st">'allows the violation of the foreign key constraint if the transaction deferres only the foreign key constraint', async function() {
            const taskTableName = `tasks_${Support.rand()}`;

            const task = await this
              .run(Sequelize.Deferrable.INITIALLY_IMMEDIATE, {
                deferrable: Sequelize.Deferrable.SET_DEFERRED([`${taskTableName}_user_id_fkey`]),
                taskTableName
              });

            expect(task.title).to.equal(class="st">'a task');
            expect(task.user_id).to.equal(1);
          });
        });