FeathersJS Sequelize - Associations not working

Question

I'm currently using Sequelize =>4.0 and finding having 2 models link together doesn't work how i assumed it would.

Basically, i have 2 models: user & punch.

user: id name email

punch: id userId <- user id time status

I would like to show the list of users and their linked punches.

Here is my .associate function under each model:

users.associate = function (models) { // eslint-disable-line no-unused-vars
// Define associations here
// See http://docs.sequelizejs.com/en/latest/docs/associations/

    users.hasMany( models.punch, {foreignKey: 'id'} );
};


punch.associate = function (models) { // eslint-disable-line no-unused-vars
// Define associations here
// See http://docs.sequelizejs.com/en/latest/docs/associations/

    punch.belongsTo(models.users, {foreignKey: 'userId', targetKey: 'id'});
};

Is this the correct way? Is there anything else i need to do. When i view the user GET request, i'm not seeing anything other than the user data.

Any help would be greatly appreciated :)

Answer 1

You'll need to update your before hooks, as per feathers-sequelize docs:

// users.hooks.js

associationHook(context){
    const PunchModel = context.app.services.punch.Model;

    context.params.sequelize = {
        include: [{ model: PunchModel }]
    }
}

module.exports = {
    before: {
        (...)
        find: [associationHook],
        (...)
    }
    (...)
};

You'll want to do this for find/get and any other ones you want the association data to be returned.

There's also fastJoin and populate in feathers-hooks-common.