MongoDB - How can I get the size of a collection using Node.js?

Question

I'm writing a server side code using node.js, I'm trying to get the MongoDB collection size using count method which is not working.

This is my code

var mongo = require('mongodb');
var host =  "127.0.0.1";
var port = mongo.Connection.DEFAULT_PORT;

function getStock(name, callback) {

    var db = new mongo.Db("testDB", new mongo.Server(host, port, {}));
    db.open (function(error){
        console.log("We are connected! " + host + ":" +port);

        db.collection("stocks", function(error, collection){
            console.log("We have a collection");
            **var numOfDocs = db.collection('stocks').count()**
            **console.log("The num of  Docs in our collection is: ",numOfDocs)**
            collection.find({"name":name.toString()}, function(error, cursor) {
                cursor.toArray(function(error, stocks) {
                    if (stocks.length==0) {
                        //console.log("No Stocks found!");
                        callback(false);
                    }
                    else {
                        callback(stocks[0]);
                        //console.log("Found a stock -> ",stocks[0]);
                    }
                });
            });


        });
    });
}

Leonid Beschastny · Accepted Answer · 2014-08-18 21:38:32Z

7

.count() is an asynchronous function, just like .find() is.

Try the following code:

collection.count({}, function(error, numOfDocs) {
    console.log('I have '+numOfDocs+' documents in my collection');
    // ..
});

The first argument to .count() should be a search query. Since you want to count all documents, I'm passing an empty object {} as a search query.

answered Aug 18, 2014 at 21:38

Leonid Beschastny

51.6k10 gold badges121 silver badges126 bronze badges

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

8 Comments

Alex Brodov Over a year ago

What about the size() method?

Leonid Beschastny Over a year ago

@user3502786 there is no size() method in MongoDB. You can use .stats() methods, but it's asynchronous too.

Leonid Beschastny Over a year ago

@user3502786 the thing is, all io-related methods in node.js are asynchronous.

Alex Brodov Over a year ago

Is it going to give me the same number?

Leonid Beschastny Over a year ago

Yes. But it'll give you a lot of other information.

|

OhadR · Accepted Answer · 2020-04-18 14:41:38Z

1

Since mongo 4, count() is deprecated. You should use countDocuments() instead:

MongoDB drivers compatible with the 4.0 features deprecate their respective cursor and collection count() APIs in favor of new APIs for countDocuments() and estimatedDocumentCount(). For the specific API names for a given driver, see the driver documentation.

db.orders.countDocuments({})

answered Apr 18, 2020 at 14:41

OhadR

8,9593 gold badges49 silver badges57 bronze badges

Collectives™ on Stack Overflow

MongoDB - How can I get the size of a collection using Node.js?

2 Answers 2

8 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related