count query sequelize code example
Example 1: sequelize count all
Project.count().then(c => {
console.log("There are " + c + " projects!")
})
Project.count({ where: {'id': {[Op.gt]: 25}} }).then(c => {
console.log("There are " + c + " projects with an id greater than 25.")
})
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') });