MongoDB How to update multiple documents based on array of objects

Question

Given array of objects :

const array = [{_id: 1, name: 'one'}, {_id: 2, name: 'two'}]

How do you construct a query so that it will update name field for each document in DB where document's id equals _id in array object?

This must be done in a single query. Query must use mongoDB node driver syntax.

for example:

// in DB : [{_id: 1, name: null, _id: 2, name: null }]
db.collection('sprints').update(....).then(...)
// after operation:
// in DB: [{_id: 1, name: "one", _id: 2, name: "two" }]

Tobias Fuchs · Accepted Answer · 2018-03-27 13:44:36Z

1

have you tried a construct like this:

Promise.all(array.map(entry =>
    db.collection('sprints').findOneAndUpdate({ _id: entry._id }, { name: entry.name }).save()
)).then(...);

its not the direct way but worked for me (in a test case)

answered Mar 27, 2018 at 13:44

Tobias Fuchs

9385 silver badges8 bronze badges

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

5 Comments

Tomasz Szawara Over a year ago

Is this really the only way ? this will execute as many queries as elements in the array :(

Tobias Fuchs Over a year ago

In theory its the only way. Maybe there is a function for that directly but i couldnt find it in the docs. But in the end mongoose will do a single query for each entry so it doesn't matter anyway. But you re right its definitly not a clean construct

Tomasz Szawara Over a year ago

Your query might be ok for me for now ... However I have other keys on sprint objects ... and they get overwritten with object that has only _id & name ... could you modify your query, so that only name would be modified (preserving any other keys) ?

Tomasz Szawara Over a year ago

modified with db.collection('sprints').findOneAndUpdate({ _id: new ObjectID(sprint._id) }, { $set : { name: sprint.name} }) . to preserve other keys.

Tomasz Szawara Over a year ago

will wait to see if anybody can give a single query solution, if not I'll accept your answer

Collectives™ on Stack Overflow

MongoDB How to update multiple documents based on array of objects

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related