how to use for loop with update mongodb

Question

I am trying to update documents of collection sale_order if sale_order['orderId'] exists in temp_sale_order. If it does not exists in temp_sale_order then a new document will be created in sale_order. (upsert).

But it only creates only one document in it.
If i use find instead of findOne. it throws an error:

Error:

uncaught exception: can't save a DBQuery object

My query:

db.getCollection('sale_order').update(
        db.getCollection('sale_order').find({},{orderId:1}),
        db.getCollection('temp_sale_order').findOne({},{orderId:1}),{upsert:true});

what is the correct way? Also how to write and use a function in mongodb with above query?

codename44 · Accepted Answer · 2015-08-20 09:55:39Z

1

By default, update method updates only one document. You have to set the option "multi" : trueto update multiple documents at once.

http://docs.mongodb.org/manual/reference/method/db.collection.update/

db.getCollection('sale_order').update(
        db.getCollection('sale_order').find({},{orderId:1}),
        db.getCollection('temp_sale_order').findOne({},{orderId:1}),{upsert:true, multi:true});

answered Aug 20, 2015 at 9:55

codename44

92710 silver badges19 bronze badges

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

8 Comments

Manish Gupta Over a year ago

It says multi update only works with $ operators. I read about it but couldn't figure out how to use it with my query.

codename44 Over a year ago

You only have access to mongoshell to achieve this ?

Manish Gupta Over a year ago

i am using mongodb on local server and using robomongo for the ide. I am running this query from robomongo

codename44 Over a year ago

robomongo uses MongoShell wich is based on a Javascript engine, so you can use javascript loops in it. Following code will get all elements in temp_sale_order and will copy them in sale_order db.getCollection('temp_sale_order').find({}).forEach(function(element) { db.getCollection('sale_order').save(element); });

Manish Gupta Over a year ago

Can you tell me how to run this command from python. I am using pymongo and it is throwing me error

|

Collectives™ on Stack Overflow

how to use for loop with update mongodb

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related