ORM: Sequelize:为两列添加不相等约束

const { Sequelize, DataTypes } = require('sequelize');

// 创建Sequelize实例
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql',
});

// 定义模型
const MyModel = sequelize.define('MyModel', {
  column1: {
    type: DataTypes.INTEGER,
    allowNull: false,
    validate: {
      not: {
        args: Sequelize.col('column2'),
        msg: 'column1 and column2 must be different',
      },
    },
  },
  column2: {
    type: DataTypes.INTEGER,
    allowNull: false,
  },
});

// 同步模型到数据库
sequelize.sync()
  .then(() => {
    console.log('Model synchronized');
  })
  .catch((error) => {
    console.error('Error synchronizing model:', error);
  });