Nested Relations include in Sequelize with node js

Question

Models Price, Varient One ,Varient Two ,Item One Item have varient one and varient two , and many prices

They are my relations

db.tbl_itemPrice.belongsTo(db.tbl_varientOne,{foreignKey:'varientOne'})
db.tbl_itemPrice.belongsTo(db.tbl_varientTwo,{foreignKey:'varientTwo'})
db.tbl_item.hasMany(db.tbl_price,{foreignKey:'item'})

And then I want to join the table item , price, varient one and varient two . This is my controller-

exports.find = (req, res) => {
    Price.findAll ({
        include:[{
            model:VarientOne,VarientTwo

        }],

    }).then (item => {
        res.send(item)
    });
};

How can I join all above tables in sequelize

margherita pizza · Accepted Answer · 2018-11-16 12:01:55Z

1

It is same as what you did.

include:[
    {model:A},
    {model:B},
    {model:C,include:[{model:C.1}]},
    {model:D,include:[{model:D.1,include:[{model:D.1.2}]}]},
]

answered Nov 16, 2018 at 12:01

margherita pizza

7,29730 gold badges105 silver badges181 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Nested Relations include in Sequelize with node js

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related