Sequelize Setter对更新没有影响

const { Sequelize, DataTypes } = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql'
});

const User = sequelize.define('User', {
  name: {
    type: DataTypes.STRING,
    allowNull: false,
    set(value) {
      this.setDataValue('name', value.toUpperCase()); // 在Setter方法中将name属性值转换为大写
    }
  },
  age: {
    type: DataTypes.INTEGER,
    allowNull: false,
    set(value) {
      if (value < 0) {
        throw new Error('Age must be a positive number');
      }
      this.setDataValue('age', value); // 在Setter方法中对age属性值进行验证
    }
  }
});

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

  const user = await User.create({ name: 'John Doe', age: 25 });
  console.log(user.name); // 输出：JOHN DOE
  console.log(user.age); // 输出：25

  user.name = 'Jane Smith';
  user.age = -30; // 触发验证错误
  await user.save();

  console.log(user.name); // 输出：JANE SMITH
  console.log(user.age); // 输出：25
})();