Sequelize模型中的自动填充字段?
我正在为MySQL中的'用户'表创建模型。理想情况下,我希望有一个“ firstName”和“ lastName”字段以及一个“ fullName”,这是其他2的添加。是否可以通过编程将其包含在模型中,或者我必须在插入时进行处理?
const User = sequelize.define("users", {
id: {
type: Sequelize.INTEGER,
autoIncrement: true,
allowNull: false,
primaryKey: true,
},
firstName: {
type: Sequelize.STRING(50),
allowNull: false,
},
lastName: {
type: Sequelize.STRING(50),
allowNull: false,
},
fullName: {
type: Sequelize.STRING(50),
allowNull: false,
// something that makes 'firstName' + ' ' + 'lastName' ❤️
},
email: {
type: Sequelize.INTEGER(30),
allowNull: false,
},
});
回答如下:Virtual Colums