const { createSequelizeInstance } = require('./dev/sscce-helpers');
const { Model, DataTypes } = require('.');

const sequelize = createSequelizeInstance({ benchmark: true });

class User extends Model {}
User.init({
  scopeId: DataTypes.INTEGER
}, { sequelize, modelName: 'User' });

class Company extends Model {}
Company.init({
  name: DataTypes.STRING,
  public: DataTypes.BOOLEAN,
  scopeId: DataTypes.INTEGER
}, { sequelize, modelName: 'Company' });

class Profession extends Model {}
Profession.init({
  name: DataTypes.STRING,
  scopeId: DataTypes.INTEGER
}, { sequelize, modelName: 'Profession' });

User.belongsTo(Company, { foreignKey: 'companyId' });
User.belongsTo(Profession, { foreignKey: 'professionId' });
Company.hasMany(User, { foreignKey: 'companyId' });
Profession.hasMany(User, { foreignKey: 'professionId' });

(async () => {
  await sequelize.sync({ force: true });

  const companies = await Company.findAll({
    where: { '$Users.Profession.name$': 'test' },
    include: [
      {
        model: User,
        attributes: [],
        include: [
          {
            model: Profession,
            attributes: [],
            required: true
          }
        ],
        required: true,
        subQuery: true
      }
    ],
    limit: 5,
    offset: 0,
    subQuery: true
  });

  await sequelize.close();
})();

which generate an invalid SQL query