How to construct a dynamic update query in Nodejs for Mongodb?

Question

I want to create a dynamic query that updates a document in a Mongodb collection based on the user input. The user may update some or all the fields in the document. The document also contains an array to which the user is allowed to add elements. I know how to construct simple dynamic queries for 'find' queries but struggling with an update query which might have $set, $addToSet, $pull etc elements.

My final query will look like this:

Col.update({'_id' : bookId}, {$inc : {'total_count' : 1}, $set: {'name': name}, $addToSet : {'reviewed_by' : user}})

All the elements in the update part of the query will be added conditionally.

I have searched on SO and elsewhere and I don't see any example that shows how to accomplish this. Hopefully many others will also find this useful.

Zane Claes · Accepted Answer · 2013-03-16 19:38:32Z

2

Not sure I'm understanding you correctly, but it sounds like what you're looking for is really just javascript...

var update = {};
if( ... ) // do increment?
    update['$inc'] = {'total_count': 1};

// and so on...

if(Object.keys(update).length)
    Col.update({'_id': bookId}, update);

answered Mar 16, 2013 at 19:38

Zane Claes

15k15 gold badges81 silver badges137 bronze badges

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

2 Comments

Silent User Over a year ago

That makes sense! I was thinking it was going to be much complicated. Many thanks!

Silent User Over a year ago

One more question Zane. If it was $set instead of $inc in your sample code above, and I wanted to update multiple fields using the same $set, how would I do that?

Collectives™ on Stack Overflow

How to construct a dynamic update query in Nodejs for Mongodb?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related