得到 .findOrCreate() 错误

2022-01-19 00:00:00 node.js orm mysql sequelize.js

我使用 Sequelize 作为 ORM.这是我的用户模型:

I'm using Sequelize as ORM. Here's my user model:

###
    User model
###
User = exports.User =  globals.sequelize.define "User",
    username: globals.Sequelize.STRING
    email:
        type: globals.Sequelize.STRING
        validate:
            isEmail: true
    hash:     globals.Sequelize.STRING
    salt:     globals.Sequelize.STRING(512)
    fname:    globals.Sequelize.STRING
    lname:    globals.Sequelize.STRING
    country:  globals.Sequelize.STRING

我正在保存用户:

globals.models.User.findOrCreate
    username: "johny"
    password: "pass"
    email: "johny93[###]example.com"
.success (user, created)->
    console.log user.values
    res.send 200
.error ->
    console.log err # how to catch this?
    res.send 502

如果电子邮件有效(电子邮件:johny93@example.com")，一切正常.但是如果电子邮件验证失败(如上面的示例)，我会收到插入错误.如何捕捉错误类型?.error 方法无法获取任何错误参数.

If email is valid (email: "johny93@example.com"), everything works great. But if email fails validation (as in the example above), I get an insertion error. How to catch error type? .error method can't get any error parameters.

推荐答案

sequelize 会将错误作为参数传递给错误函数.

sequelize will pass the error as the paramater to the error function.

JavaScript:

User.findOrCreate({username: "johny",password: "pass",email: "johny93[###]example.com"})
.success(function(user, created){
    console.log(user.values);
    res.send(200);
})
.error(function(err){
   console.log('Error occured' + err);
})

CoffeScript:

globals.models.User.findOrCreate
    username: "johny"
    password: "pass"
    email: "johny93[###]example.com"
.success (user, created)->
    console.log user.values
    res.send 200
.error (error)->
    console.log error # how to catch this?
    res.send 502

相关文章