How to update multiple items in array with multiple values

Question

I have the following document schema:

let document = {
    _id: 'a1',
    name: 'some_name',
    items: [{
            _id: 1,
            name: 'item1',
        },
        {
            _id: 2,
            name: 'item2',
        },
        {
            _id: 3,
            name: 'item3',
        },
        {
            _id: 4,
            name: 'item4',
        },
    ]
}

and the following update payload is a list of documents

let updates = [{
        _id: 1,
        name: 'item11',
    },
    {
        _id: 2,
        name: 'item22',
    },
    {
        _id: 3,
        name: 'item33',
    },
    {
        _id: 4,
        name: 'item44',
    },
]

I want to update each item in the collection with the item in the update payload that has the same _id

How can I do this?

Ezra Siton · Accepted Answer · 2020-12-10 07:41:29Z

1

This is a too specific update related to each unique _id (So updateMany will not work - this is not "many" each _id is unique). Maybe related: MongoDB: update every document on one field

In your case, it is like running 4 times updateOne (And each time change the name to some value).

One option is to use bulkWrite:

https://docs.mongodb.com/manual/reference/method/db.collection.bulkWrite/

db.myCollection.bulkWrite([
      { updateOne : {
         "filter" : { "_id" : "1" },
         "update" : { $set : { "name" : "item11" } }
      },
      { updateOne : {
         "filter" : { "_id" : "2" },
         "update" : { $set : { "name" : "item22" } }
      }
]);

The other option is to use plain Javascript (And map or for) and for each item in the array updateOne.

Outline only (You should test this concept under MongoDB playground).

updates.map(function(item) {
  console.log(item._id); // 1 2 3 4
  console.log(item.name); // item11 item22 item33 item44
  db.myCollection.updateOne(
    { "_id" : item._id  }, /* filter */
    { $set: { "_id" : item.name } } /* update */
  );
})

answered Dec 10, 2020 at 7:41

Ezra Siton

7,9672 gold badges30 silver badges44 bronze badges

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

1 Comment

juztcode Over a year ago

I suppose one could use javascript to build the payload for bulkWrite then use it

Collectives™ on Stack Overflow

How to update multiple items in array with multiple values

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related