非null冲突:model.field不能为null

Question

我有序列化模型，一切都与db:同步

供应商：

class Suppliers extends Model {}
Suppliers.init({
id: {
type: DataTypes.UUID,
defaultValue: DataTypes.UUIDV4,
primaryKey: true
},
name: {
type: DataTypes.STRING,
allowNull: false
},
firstName: {
type: DataTypes.STRING,
allowNull: false
},
email: {
type: DataTypes.STRING,
allowNull: false
},
password: {
type: DataTypes.STRING,
allowNull: false
},
phone: {
type: DataTypes.STRING,
allowNull: false
},
lastName: {
type: DataTypes.STRING
// allowNull defaults to true
}
}, {
sequelize, 
modelName: 'supplier'
});

console.log({suppliers:Suppliers === sequelize.models.Suppliers}); 
export{Suppliers}

我进行这个查询是为了将记录添加到供应商表中：

async function create(user) {
init()
user.dateCreated = new Date().toISOString();
user.dateUpdated = new Date().toISOString();
let nwUser;
try {

console.log({values: {name:user.name, password:user.hash, email:user.email, phone: user.phone, firstName: user.firstName, lastName: user.lastName}})
nwUser = await Suppliers.create({values: {name:user.name, password:user.hash, email:user.email, phone: user.phone, firstName: user.firstName, lastName: user.lastName}}).then(rs=>{
console.log({rscreate:rs})     
return   rs
})
.catch(err=>console.log(err));
return nwUser
} catch (error) {
console.log(error);
}

但是对于我传递给查询的所有值，我都会得到上面提到的错误。但正如你所看到的，当我安慰他们时，他们就在那里。

Answer 1

不应该将所有字段包装到values道具中。直接通过：

nwUser = await Suppliers.create({name:user.name, password:user.hash, email:user.email, phone: user.phone, firstName: user.firstName, lastName: user.lastName})