sequelize how to count in a single query code example
Example 1: sequelize count in include
Location.findAll({
attributes: {
include: [[Sequelize.fn("COUNT", Sequelize.col("sensors.id")), "sensorCount"]]
},
include: [{
model: Sensor, attributes: []
}]
});
Example 2: count in sequelize example
exports.getItemSaleCount = () => SaleItem.findAll({ attributes: ['itemId', [sequelize.fn('count', sequelize.col('itemId')), 'count']], group : ['SaleItem.itemId'], raw: true, order: sequelize.literal('count DESC') });
Example 3: count using sequelize.fn
exports.getMinPrice = () => Item.findAll({ attributes: [[sequelize.fn('min', sequelize.col('price')), 'minPrice']], });