How to find data of source table from target table in sequelize?

Question

I have two tables, traders, and messages

Traders is associated to messages as following

traders.hasMany(models.messages, {as: 'sender',foreignKey : 'senderId'});
traders.hasMany(models.messages, {as: 'reciever',foreignKey : 'recieverId'});

now when I try to find trader name along with all messages using following code

   ctx.body = await ctx.db.messages.findAll({
        include:[{
            model: ctx.db.traders,
            as:'sender'
        }],
        attributes:['type',['data','message'],'createdAt','senderId','name'],
        where:{
            conversationId:ctx.request.body.conversationId
        }
    })

I get the following error

SequelizeEagerLoadingError: traders is not associated to messages!

I want to find name of trader who sent message. – Faizan Ul Haq Sep 16 '18 at 16:46 — Faizan Ul Haq, Sep 16 '18 at 16:46

Praveenkumar Kalidass · Answer 1 · 2018-09-17T11:41:23.013

0

Try association from both models like,

traders.hasMany(models.messages, {
    as: 'sender',
    foreignKey: 'senderId'
});

messages.belongsTo(models.traders, {
    as: 'sender',
    foreignKey: 'senderId'
});

edited Sep 17 '18 at 11:41

answered Sep 17 '18 at 11:17

Praveenkumar Kalidass

429
4
12

this causes cyclic dependency , i have other tables too – Faizan Ul Haq Sep 17 '18 at 12:18
this wont cause cyclic dependency. Try with 'sourceKey' and 'targetKey' http://docs.sequelizejs.com/manual/tutorial/associations.html#one-to-many-associations-hasmany- – Praveenkumar Kalidass Sep 17 '18 at 12:22

How to find data of source table from target table in sequelize?

1 Answers1