include in sequelize code example
Example 1: sequelize include only
Payment.findAll({
where: {
DairyId: req.query.dairyid
},
attributes: {
exclude: ['createdAt', 'updatedAt']
},
include: {
model: Customer,
attributes:['customerName', 'phoneNumber']
}
})
Example 2: nested include sequelize
models.products.findAll({
include: [
{model: models.comments, include: [models.comments.users] }
]
})
Example 3: include with where clause in sequelize
Document.findAll({
where: {'$employee.manager.id$': id},
include: [{
model: models.Employee,
required: true,
as: 'employee',
include: [{
model: models.Manager,
required: true,
as: 'manager',
where: { id: managerId },
}],
}],
Example 4: in in sequelize
await Tag.findAll({
where: {
id: {
[Sequelize.Op.in]: [1, 2, 3, 4]
}
}
});
Example 5: sequelize include twice
Test.findAll({
include: [
{ model: Model1 },
{ model: Model2 }
]
});