CODEWITHSUNDEEP
javascriptnode.jssequelize.js
Ela
Ela

Reputation: 57

How to work with associations in Sequelize

I am trying to understand Sequelize and I have small problem with associations. Please take a look at code below:

User model:

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;
};

Deadline model:

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;
};

and code which does not let me sleep well:

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);

in last line I got 

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)

According documentation when I inform User about User.hasMany(Deadline) then User prototype should automatically get setDeadlines, getDeadlines, add/removeDeadline methods. Could you help me?

BTW "sequelize": "~2.0.0-beta.0",

Upvotes: 4

Views: 2263

Answers (1)

sdepold
sdepold

Reputation: 6231

Try this:

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!')
                })
            })
        })
    })
})

Upvotes: 4

Related Questions