sscce.js

'use strict';

// Require the necessary things from Sequelize
const { Sequelize, Op, Model, DataTypes } = require('sequelize');

// This function should be used instead of `new Sequelize()`.
// It applies the config for your SSCCE to work on CI.
const createSequelizeInstance = require('./utils/create-sequelize-instance');

// This is an utility logger that should be preferred over `console.log()`.
const log = require('./utils/log');

// You can use sinon and chai assertions directly in your SSCCE if you want.
const sinon = require('sinon');
const { expect } = require('chai');

// Your SSCCE goes inside this function.
module.exports = async function() {
  const sequelize = createSequelizeInstance({
    logQueryParameters: true,
    benchmark: true,
    define: {
      timestamps: false // For less clutter in the SSCCE
    }
  });

  const Foo = sequelize.define('Foo', { uuid: DataTypes.UUID });

  const spy = sinon.spy();
  sequelize.afterBulkSync(() => spy());
  await sequelize.sync();
  expect(spy).to.have.been.called;

  log(await Foo.create({ uuid: '573b77ae-51ab-4271-aa94-81190b734257' }));
  expect(await Foo.count({where: { uuid: { [Op.like]: "573b77ae%" } }})).to.equal(1);
  expect(await Foo.count({where: { uuid: { [Op.startsWith]: "573b77ae" } }})).to.equal(1);
  expect(await Foo.count({where: { uuid: { [Op.endsWith]: "81190b734257" } }})).to.equal(1);
  expect(await Foo.count({where: { uuid: { [Op.substring]: "573b77ae" } }})).to.equal(1);
};