Writing MongoDB result to file using native Node.js driver

Question

I am trying to write the results of a MongoDB query to a file using the native Node.js driver. My code is the following (based on this post: Writing files in Node.js):

var query = require('./queries.js');
var fs = require('fs');

var MongoClient = require('mongodb').MongoClient;

MongoClient.connect("mongodb://localhost:27017/test", function(err, db) {
    if(err) { return console.dir(err); }

    var buildsColl = db.collection('blah');

    collection.aggregate(query.test, function(err, result) {
        var JSONResult = JSON.stringify(result);
        //console.log(JSONResult);

        fs.writeFile("test.json", JSONResult, function(err) {
            if(err) {
                console.log(err);
            } else {
                console.log("The file was saved!");
            }
        });
    });

    collection.aggregate(query.next, function(err, result) {
        var JSONResult = JSON.stringify(result);
        //console.log(JSONResult);
        db.close();
    });

});

The file is written, but the contents are 'undefined.' Printing the result to the console works though.

Soren · Accepted Answer · 2014-05-29 18:41:55Z

2

Your code is not checking the err on the aggregate callback.

You are likely getting an Mongo error and the result is undefined in that case...

Other thing I could suspect is that you are getting multiple callbacks -- each one of them creates a new files, erasing the content.

Try using fs.appendFile instead of fs.writeFile and see if you are getting the expected data (plus the unwanted undefined)

edited May 29, 2014 at 18:41

answered May 29, 2014 at 18:34

Soren

14.8k4 gold badges43 silver badges69 bronze badges

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

3 Comments

JamesE Over a year ago

Thanks for the suggestion, but I'm still getting an 'undefined' in the file.

Soren Over a year ago

I just noticed that you are not checking for errors on the aggregate callback -- just updated the answer to reflect that

JamesE Over a year ago

That was it. I was prematurely closing the connection to the database in a second collection.aggregate block. Now I just need to figure out where to put the close statement. Posted updated code above.

JamesE · Accepted Answer · 2014-05-29 20:43:50Z

2

For anyone stumbling across this the solution on where to put the db.close() is below:

collection.aggregate(query.test, function(err, result) {
    var JSONResult = JSON.stringify(result);
    //console.log(JSONResult);

    fs.writeFile("test.json", JSONResult, function(err) {
        if(err) {
            console.log(err);
        } else {
            console.log("The file was saved!");
        }
    });

    collection.aggregate(query.next, function(err, result) {
        var JSONResult = JSON.stringify(result);
        //console.log(JSONResult);
        db.close();
    });
});

answered May 29, 2014 at 20:43

JamesE

3,9539 gold badges48 silver badges85 bronze badges

Collectives™ on Stack Overflow

Writing MongoDB result to file using native Node.js driver

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related