Counting associated entries with Sequelize

by

Use findAll() with include() and sequelize.fn() for the COUNT:

Location.findAll({
    attributes: { 
        include: [[Sequelize.fn("COUNT", Sequelize.col("sensors.id")), "sensorCount"]] 
    },
    include: [{
        model: Sensor, attributes: []
    }]
});

Or, you may need to add a group as well:

Location.findAll({
    attributes: { 
        include: [[Sequelize.fn("COUNT", Sequelize.col("sensors.id")), "sensorCount"]] 
    },
    include: [{
        model: Sensor, attributes: []
    }],
    group: ['Location.id']
})

More Related Contents:

  1. How to auto generate migrations with Sequelize CLI from Sequelize models?
  2. How to make join queries using Sequelize on Node.js
  3. How can i write in NodeJS with MongoDB the following MySQL Select?
  4. MySQL 8.0 – Client does not support authentication protocol requested by server; consider upgrading MySQL client
  5. MySQL with Node.js
  6. node-mysql multiple statements in one query
  7. nodejs mysql Error: Connection lost The server closed the connection
  8. How do I do a bulk insert in mySQL using node.js
  9. Node.js can’t authenticate to MySQL 8.0
  10. node.js mysql error: ECONNREFUSED
  11. How to access a RowDataPacket object
  12. Retrieve last inserted id with Mysql
  13. How to pass parameters to mysql query callback in nodejs
  14. Making changes to multiple records based on change of single record with SQL
  15. node.js + mysql connection pooling
  16. connect ECONNREFUSED – node js , sql
  17. NodeJS MySQL Dump
  18. Node.js connect to MySQL Docker container ECONNREFUSED
  19. Use promise to process MySQL return value in node.js
  20. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  21. Error in MySQL library for Node.js
  22. Which ORM should I use for Node.js and MySQL? [closed]
  23. find number of rows in returned mysql result (nodejs)
  24. MySQL giving “read ECONNRESET” error after idle time on node.js server
  25. INSERT INTO fails with node-mysql
  26. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  27. MySQL Query GROUP BY day / month / year
  28. Insert data into table with result from another select query
  29. “Unknown column in ‘field list'”, but column does exist
  30. Insert and set value with max()+1 problems

Leave a Comment