python + pymongo: how to insert a new field on an existing document in mongo from a for loop

python mongodb insert pymongo
otmezger picture otmezger · Mar 27, 2013 · Viewed 26.1k times · Source

I'm using a for loop in python to loop over the result of a query with pymongo. Here is the code:

from pymongo import MongoClient
connection = MongoClient()
db = connection.Test

myDocs = db.Docs.find( { "geolocCountry" : { "$exists" : False } } )

for b in myDrives:
    my_lat = b['TheGpsLog'][0]['latitude']
    my_long = b['TheGpsLog'][0]['longitude']

    myGeolocCountry = DoReverseGeocode(lat_start,long_start) 
    #    Here I perform a reverse geocoding, it does not matter for this example. 
    #    The important thing is: it returns a string, like 'US', 'UK', etc...

The question I have is, how can I insert the variable myGeolocCountry into the non existing field geolocCountry on the existing document (b)?

I tried with 

b['geolocCountry'] = myGeolocCountry

but it didn't work at all, it does not even produce an error.

Thanks

Answer

MostafaR picture MostafaR · Mar 27, 2013

You should execute an update query like this:

db.Doc.update({"_id": b["_id"]}, {"$set": {"geolocCountry": myGeolocCountry}})

Related questions

"Large data" work flows using pandas

I have tried to puzzle out an answer to this question for many months while learning pandas. I use SAS for my day-to-day work and it is great for it's out-of-core support. However, SAS is horrible as a piece of …

Read More
mongodb: insert if not exists

Every day, I receive a stock of documents (an update). What I want to do is insert each item that does not already exist. I also want to keep track of the first time I inserted them, and the last …

Read More
How to sort mongodb with pymongo

I'm trying to use the sort feature when querying my mongoDB, but it is failing. The same query works in the MongoDB console but not here. Code is as follows: import pymongo from pymongo import Connection connection = Connection() db = connection.…

Read More