Help with association methods

[Joshua Chan]

I have the following models defined.

var User = sequelize.define('user', {
    name: Sequelize.STRING,
    dateOfBirth: Sequelize.DATEONLY,
    email: Sequelize.STRING,
    phone: Sequelize.CHAR(10)
}, {
    timestamps: false,
    freezeTableName: true // Model tableName will be the same as the model name
});


var Group = sequelize.define('group', {
    name: Sequelize.STRING
},{
    timestamps: false,
    freezeTableName: true
})




var Role = sequelize.define('role', {
    name: Sequelize.STRING
},{
    timestamps: false,
    freezeTableName: true
})


var UserXGroupXRole = sequelize.define('userXgroupXrole', {
    userId: {
        type: Sequelize.INTEGER,
        references: "user",
        referencesKey: "id",
        allowNull: false
    },
    groupId: {
        type: Sequelize.INTEGER,
        references: "group",
        referencesKey: "id",
        allowNull: false
    },
    roleId: {
        type: Sequelize.INTEGER,
        references: "role",
        referencesKey: "id",
        allowNull: false
    }
},{
    timestamps: false,
    freezeTableName: true
})


User.hasMany(UserXGroupXRole)
Group.hasMany(UserXGroupXRole)
Role.hasMany(UserXGroupXRole)
UserXGroupXRole.hasOne(User, { foreignKey: 'id' })
UserXGroupXRole.hasOne(Group, { foreignKey: 'id' })
UserXGroupXRole.hasOne(Role, { foreignKey: 'id' })

Now, I'm trying to create a new user with some records in the userXgroupXrole table like so

function bootstrapUser(profile){
    var user = User.build();
    user.name = profile.name;
    user.email = profile.email;


    return DefaultMembership.findAll({where: {email: profile.email}})
        .then(function(memberships){


            memberships.forEach(function(membership){
                var ugr = UserXGroupXRole.build();
                ugr.group = membership.getGroup();
                ugr.role = membership.getRole();
                user.addUserXGroupXRole(ugr);
            })


            return;
        })
        .then(function(){
            return user.save()
        })
}

But I'm getting an exception at user.addUserXGroupXRole. Do I have to use an alias to get the methods for adding associated records?

[Mick Hansen]

Whats the exception? That the method does not exist?
Try logging Object.keys(ser.Instance.prototype) to see what methods it has.

--

Mick Hansen

@mhansendev
mhansen.io

[Joshua Chan]

The exception is

Unhandled rejection TypeError: user.addUserXGroupXRole is not a function

    

When I try to log Object.keys(user.Instance.prototype), I get an error 

Unhandled rejection TypeError: Cannot read property 'prototype' of undefined

[Mick Hansen]

It has to be Model.Instance.prototype, not instance.Instance.prototype

[Joshua Chan]

Ah! The method is addUserXgroupXroles. Can I change the casing?

[Joshua Chan]

Actually, I'd really like this to read addGroupRole(). Is tha possible?

[Mick Hansen]

Try {as: 'groupRole'} on the association.

On Mon, May 11, 2015 at 8:17 PM, Joshua Chan <joshua.be...@gmail.com> wrote:

Actually, I'd really like this to read addGroupRole(). Is tha possible?

[Joshua Chan]

Ok, I had some problems getting aliases to work. I think I read something about needing to include the alias when eager loading. Is that right?

[Mick Hansen]

Correct, if the association has an alias you'll need to use include: [{model: Model, as: 'as'}].
However you can also simply save the reference to the association like User.GroupRoles = User.hasMany(Role, {as: 'asdsa'}) and then use include: [User.GroupRoles)

On Mon, May 11, 2015 at 8:57 PM, Joshua Chan <joshua.be...@gmail.com> wrote:

Ok, I had some problems getting aliases to work. I think I read something about needing to include the alias when eager loading. Is that right?