Sequelize Include Model But Without Tablename

Question

I'm newbie for Sequelize

I have a problem with "Nested Eager Loading"

I have 2 Table with 1-to-many relationship

Comment Table
User Table

I use this code for the query

Comment.findAll({
   include: [User]
})

I got

{
    id: 1,
    comment: "test",
    user: {
       id: 3,
       name: "someone"
    }
}

But I expected result like this

{
    id: 1,
    comment: "test",
    user_id: 3,
    user_name: "someone"
}

I read several stackoverflow post it has a solution but work for version 3.3

Comment.findAll({
   attributes: ['id', 'name', ['user.id','user_id'], ['user.name','user_name']]
   include: [{ model: User, attributes:[], nested: false, required: true }]
})

Comment.findAll({
   attributes: ['id', 'name', [Sequelize.col('user.id'),'user_id'], [Sequelize.col('user.name'),'user_name']]
   include: [{ model: User, attributes:[], nested: false, required: true }]
})

but it's not work for me.

now I use sequelize 5.5.1 how can I implement it.

Can someone help me, please?

Did you find a solution for this problem? – Kiax Jun 25 '20 at 01:00 — Kiax, Jun 25 '20 at 01:00
@Kiax No, but the way which I use is change my frontend. – Sunny Aug 31 '20 at 13:21 — Sunny, Aug 31 '20 at 13:21

score 1 · Answer 1 · answered Dec 24 '19 at 15:40

You can use this code to get the desired output:

Since Sequelize is promised based , it is recommend to use then and catch.

Comment.findAll({
   include: [User]
}).then(result=>
{
  let obj=
{
    id: result.item,
    comment: result.comment,
    user_id: result.user.id,
    user_name: result.user.name
};
console.log(JSON.stringify(obj));

}).catch(err=>
{
console.log(err);
});

Sequelize Include Model But Without Tablename

1 Answers1