Counting the size of multiple collection in Mongodb with Mongoose

Question

I need to count the number of documents inside two collections (Devices, Rooms). I saved details inside Devices schema and Rooms Schema as separate collections. How to query both the collections and return the count of documents?.

Dario · Accepted Answer · 2017-02-09 09:50:44Z

4

You can try using count():

var devicesCountQuery = DevicesModel.count();
var roomsCountQuery   = RoomsModel.count();

With mongo you have to do two single queries.

You can wrap it in a single call using Promise.all() (Mongoose supports promises):

Promise.all([
  DevicesModel.count().exec(),
  RoomsModel.count().exec()
]).then(function(counts) {
  console.log('Devices count %d', counts[0]);
  console.log('Rooms count %d', counts[1]);
});

edited Feb 9, 2017 at 9:50

answered Feb 9, 2017 at 9:33

Dario

4,0752 gold badges15 silver badges27 bronze badges

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

1 Comment

Karthikeyan Prakash Over a year ago

Is it possible to do it inside single function?

Collectives™ on Stack Overflow

Counting the size of multiple collection in Mongodb with Mongoose

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related