model - 如何使用 or (Op.or/$or) 运算符指定该阶段应等于 null OR Junior 或 Senior 进行 Sequelize ？

Question

如何使用 or (Op.or/$or) 运算符指定该阶段应等于 null OR Junior 或 Senior 进行 Sequelize ？

const Sequelize = require('sequelize');
const db = require('./_db');

const Student = db.define('student', {
  name: {
    type: Sequelize.STRING,
    allowNull: false,
    validate: {
      notEmpty: true,
    },
    phase: {
      type: Sequelize.STRING,
      defaultValue: null,
      $or: [{ phase: null }, { phase: 'junior' }, { phase: 'senior' }],
    },
  },
});

Answer 1

我认为您可以通过两种方式实现这一目标:

将字段类型更改为 ENUM :

phase: {
    type: Sequelize.ENUM('junior', 'senior') ,
    defaultValue: null,
}

// ------------ OR -------------

phase: {
    type:   Sequelize.ENUM ,
    values: ['junior', 'senior'] ,
    defaultValue: null
}

更多细节: DO READ

OR

设置验证:

const Student = db.define('student', {
    ...
    phase: {
        type: Sequelize.STRING,
        defaultValue: null,
    }
    ...
  } , {
    validate: {
        checkPhase() {
            if (!(this.phase === null || this.phase === 'junior' || this.longitude === 'senior')) {
                throw new Error('Phase value should be junior or senior')
            }
        }
    }
});