如何在Sequelize中使用关联

Ela 发表于 Dev

她

我正在尝试了解Sequelize，并且在关联方面存在小问题。请看下面的代码：

用户模型：

var Sequelize = require("sequelize");

module.exports = function (sequelize) {
    var User = sequelize.define('user', {
        id:{ type:Sequelize.INTEGER.UNSIGNED, autoIncrement:true, allowNull:false, primaryKey:true},
        name:{ type:Sequelize.STRING(50), defaultValue:''},
        email:Sequelize.STRING(50),
        password:Sequelize.STRING(256)
    });

    return User;
};

截止日期模型：

var Sequelize = require("sequelize");

module.exports = function (sequelize) {
    var User = require("./user")(sequelize),
        Deadline = sequelize.define('deadline', {
            id:{ type:Sequelize.INTEGER.UNSIGNED, autoIncrement:true, allowNull:false, primaryKey:true},
            name:{ type:Sequelize.STRING(255)}
        });

    User.hasMany(Deadline);

    return Deadline;
};

和让我难以入睡的代码：

var sequelize = require('./app/mysqlConnection'),
    User = require("./app/models/user")(sequelize),
    Deadline = require("./app/models/deadline")(sequelize);

sequelize.drop().success(function () {
    sequelize.sync().success(function () {

        var user = User.build({password:'bar', email:'ser'}),
            dead = Deadline.build({name:'learn js'});

        user.addDeadline(dead);

在最后一行中

TypeError: Object [object Object] has no method 'addDeadline'
    at null.<anonymous> (C:\projects\deadline\dbsynch.js:11:14)
    at EventEmitter.emit (events.js:106:17)
    at module.exports.finish (C:\projects\deadline\node_modules\sequelize\lib\query-chainer.js:138:30)
    at exec (C:\projects\deadline\node_modules\sequelize\lib\query-chainer.js:92:16)
    at onSuccess (C:\projects\deadline\node_modules\sequelize\lib\query-chainer.js:65:11)
    at null.<anonymous> (C:\projects\deadline\node_modules\sequelize\lib\query-chainer.js:86:15)
    at EventEmitter.emit (events.js:95:17)
    at null.<anonymous> (C:\projects\deadline\node_modules\sequelize\lib\dao-factory.js:195:41)
    at EventEmitter.emit (events.js:95:17)
    at null.<anonymous> (C:\projects\deadline\node_modules\sequelize\lib\query-interface.js:162:19)

根据文档，当我向User通知User.hasMany（Deadline）时，User原型应自动获取setDeadlines，getDeadlines，add / removeDeadline方法。你可以帮帮我吗？

BTW“ sequelize”：“〜2.0.0-beta.0”，

斯波尔德

尝试这个：

sequelize.drop().success(function () {
    sequelize.sync().success(function () {

        User.create({password:'bar', email:'ser'}).success(function(user) {
            Deadline.create({name:'learn js'}).success(function(deadline) {
                user.addDeadline(deadline).success(function() {
                    console.log('coolio!')
                })
            })
        })
    })
})

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。