gpt4 book ai didi

javascript - Sequelize : Cannot set a new unique constraint message

转载 作者:搜寻专家 更新时间:2023-11-01 00:00:45 25 4
gpt4 key购买 nike

我正在尝试为字段 usernameemail 设置违反唯一约束的验证消息。但是,无论何时输入已使用的用户名,它都会显示为 email 属性定义的消息,但会显示 username 属性的输入,并且还表示此输入用于用户名 属性。我将如何解决这个问题?这是我的代码:

module.exports = function (sequelize, DataTypes) {
var users = sequelize.define('users', {
full_name: {
type: DataTypes.STRING,
allowNull: false,
validate: {
len: {
args: [5, 50],
msg: 'Your full name may be 5 to 50 characters only.'
}
}
},
email: {
type: DataTypes.STRING,
allowNull: false,
unique: {
msg: 'This email is already taken.'
},
validate: {
isEmail: {
msg: 'Email address must be valid.'
}
}
},
username: {
type: DataTypes.STRING,
allowNull: false,
unique: {
msg: 'This username is already taken.'
},
validate: {
len: {
args: [5, 50],
msg: 'Your username may be 5 to 50 characters only.'
}
}
},
password: {
type: DataTypes.STRING,
allowNull: false,
validate: {
len: {
args: [5, 72],
msg: 'Your password may be 5 to 72 characters only.'
}
}
},
rank: {
type: DataTypes.INTEGER,
allowNull: false,
validate: {
isInt: true
}
}
}, {
hooks: {
beforeValidate: function (user, options) {
if (typeof user.email === 'string') {
user.email = user.email.toLowerCase();
}

if (typeof user.username === 'string') {
user.username = user.username.toLowerCase();
}
}
}
});

return users;
};

这是我从输入中得到的输出:

{
"name": "SequelizeUniqueConstraintError",
"message": "Validation error",
"errors": [
{
"message": "This email is already taken.",
"type": "unique violation",
"path": "username",
"value": "hassan"
}
],
"fields": {
"username": "hassan"
}
}

如您所见,它表示用户名不是唯一的,而是使用为电子邮件属性定义的消息。

最佳答案

这是可能的尝试这样

unique: {
arg: true,
msg: 'This username is already taken.'
},

关于javascript - Sequelize : Cannot set a new unique constraint message,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/34263108/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com