Sequelize中虚拟字段的Getter和Setter

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

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

const User = sequelize.define('User', {
  firstName: {
    type: DataTypes.STRING,
    allowNull: false,
  },
  lastName: {
    type: DataTypes.STRING,
    allowNull: false,
  },
  fullName: {
    type: DataTypes.VIRTUAL,
    get() {
      return `${this.firstName} ${this.lastName}`;
    },
    set(value) {
      const names = value.split(' ');
      this.setDataValue('firstName', names[0]);
      this.setDataValue('lastName', names[1]);
    },
  },
});

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

  const user = await User.create({ firstName: 'John', lastName: 'Doe' });
  console.log(user.fullName); // Output: John Doe

  user.fullName = 'Jane Smith';
  console.log(user.firstName); // Output: Jane
  console.log(user.lastName); // Output: Smith
})();