Updating an array item using NodeJS, MongoDB & Monk

Question

I have a data set like this:

{ 
  name : 'Doc Name',
  photos: [
      {
        name: 'photo1',
        url: 'http://.....'
      },
      {
        name: 'photo2',
        url: 'http://......'
      }
   ],
   etc ...

Using Monk https://github.com/LearnBoost/monk how do I update photo2? I can use an index as I am iterating over the fields at the moment.

My current attempt below gives me an error, and I can't use a variable for the JSON selector (as in the index).

collection.update({_id: data._id}, {photos[i].data: filename}, function(err, updatedata) {

            });

Neil Lunn · Accepted Answer · 2017-07-20 22:00:35Z

8

Updating items at a position in an array can be done using the positional $ operator

collection.update( 
    { _id: data.id, "photos.name": "photo2" }, 
    { $set: { "photos.$.data": "yourdata" } }
)

edited Jul 20, 2017 at 22:00

answered Feb 3, 2014 at 2:06

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

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

2 Comments

jnovack Over a year ago

Of note, this only works when ONE (1) sub-document is found. If you want to update more than 1 sub-document, go vote for the bug. jira.mongodb.org/browse/SERVER-1243

Neil Lunn Over a year ago

@jnovack Technically that was a "feature request" and it's actually been fulfilled. There is of course a different question about that particular request How to Update Multiple Array Elements in mongodb, of which that link there is my answer on how you actually do that with the new MongoDB feature.

Ryan Knell · Accepted Answer · 2014-02-03 04:54:28Z

0

So I found a solution to my problem but there may be some better options and I will leave it unanswered. But for anyone else with the same issue this is what I did:

I extracted the MongoDB document as an object in Node.js, manipulated the document, and then replaced the entire array in a single update statement. For example here is some pseudo code:

collection.find({id: 1}, function(err, doc){
    for(i=0; i< doc.array.length; i++) {
          //do what you gotta do
          doc.array[i].property = 'new value';
    }
    collection.update({id: 1}, {$set : {"doc.array": doc.array}}, function(err,doc){
          console.log(err);
    }
})

edited Feb 3, 2014 at 4:54

answered Feb 3, 2014 at 2:11

Ryan Knell

6,3603 gold badges42 silver badges32 bronze badges

Collectives™ on Stack Overflow

Updating an array item using NodeJS, MongoDB & Monk

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related