Function expectsql

test/support.js:225–275

(query, assertions)

  },

  expectsql(query, assertions) {
    const rawExpectationMap =
      'query' in assertions ? assertions.query : assertions;
    const expectations = Object.create(null);

    for (const [key, value] of Object.entries(rawExpectationMap)) {
      const acceptedDialects = key.split(' ');

      for (const dialect of acceptedDialects) {
        if (dialect === 'default' && acceptedDialects.length > 1) {
          throw new Error(
            'The \'default\' expectation cannot be combined with other dialects.'
          );
        }

        if (expectations[dialect] !== undefined) {
          throw new Error(
            `The expectation for ${dialect} was already defined.`
          );
        }

        expectations[dialect] = value;
      }
    }
    let expectation = expectations[Support.sequelize.dialect.name];
    const dialect = Support.sequelize.dialect;

    if (!expectation) {
      if (expectations['default'] !== undefined) {
        expectation = expectations['default'];
        if (typeof expectation === 'string') {
          // replace [...] with the proper quote character for the dialect
          // except for ARRAY[...]
          expectation = expectation.replace(/(?<!ARRAY)\[([^\]]+)]/g, `${dialect.TICK_CHAR_LEFT}$1${dialect.TICK_CHAR_RIGHT}`);
        }
      } else {
        throw new Error(`Undefined expectation for "${Support.sequelize.dialect.name}"!`);
      }
    }

    if (query instanceof Error) {
      expect(query.message).to.equal(expectation.message);
    } else {
      expect(Support.minifySql(query.query || query)).to.equal(Support.minifySql(expectation));
    }

    if (assertions.bind) {
      const bind = assertions.bind[Support.sequelize.dialect.name] || assertions.bind['default'] || assertions.bind;
      expect(query.bind).to.deep.equal(bind);
    }
  },

  rand() {
    return Math.floor(Math.random() * 10e5);