How to get results array data after update on mongodb in node?

Question

Below is my code

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

MongodbClient.connect('mongodb://localhost/test', function(err, db) {
    if(!err){
        console.log("We are connected!!");
    }

    var contact = db.collection('contact');

    contact.update({name: "Fred"}, {$set: {tel:'09088oooxxaa'}}, function(err,r) {
       if(err){
           console.log("Update err");
       }
       else{
           console.log('Update success');
           console.log(r.name);
       }
   });

   contact.find({name: "Fred"}).toArray(function(err, results) {
       console.log(results[0]);
   });
});

I can get the result array by using find() method in the end of this code.

However, I would like to know is any way I can get same results array in update function code by callback?

I tried to worte "console.log(r.name) in update code but show undefined

michelem · Accepted Answer · 2015-09-27 10:33:21Z

1

You could also do a findAndModify so you don't need to do the find after the update because it returns the updated item too:

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

MongodbClient.connect('mongodb://localhost/test', function(err, db) {
    if(!err){
        console.log("We are connected!!");
    }

    var contact = db.collection('contact');

    contact.findAndModify({name: "Fred"}, {$set: {tel:'09088oooxxaa'}}, function(err,r) {
       // r now contains the entire item updated
       if(err){
           console.log("Update err");
       }
       else{
           console.log('Update success');
           console.log(r.name);
       }
   });
});

answered Sep 27, 2015 at 10:33

michelem

14.6k5 gold badges55 silver badges67 bronze badges

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

3 Comments

Dreams Over a year ago

Thanks.So I can not use "r" in update callback when use update not findAndModify?

michelem Over a year ago

Yes you can't use it with an update command because it returns only the number of row updated not the items.

Dreams Over a year ago

THanks. I though It will return the updated items also.Did you know where I can find these information which is what data it will return?

Vsevolod Goloviznin · Accepted Answer · 2015-09-27 10:24:15Z

1

You need to do the find oepration inside the callback to update. The way you do it, your find operation fires prior to update.

var contact = db.collection('contact');

contact.update({name: "Fred"}, {$set: {tel:'09088oooxxaa'}}, function(err,r) {
   if(err) {
       console.log("Update err");
   }
   else {
       console.log('Update success');
       contact.find({name: "Fred"}).toArray(function(err, results) {
           console.log(results[0]);
       });
   }
});

answered Sep 27, 2015 at 10:24

Vsevolod Goloviznin

12.4k1 gold badge53 silver badges50 bronze badges

1 Comment

Vsevolod Goloviznin Over a year ago

Yes, it's in the scope of the callback

Collectives™ on Stack Overflow

How to get results array data after update on mongodb in node?

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related