What is the correct way to query MongoDB for _id using string by using Python?

mongodb pymongo
MFB picture MFB · Oct 21, 2011 · Viewed 22.6k times · Source

I am using pymongo driver. Supposedly, one can use a string to query the _id field of a document, like this:

thing = db.things.find_one({'_id':'4ea113d6b684853c8e000001'})

But it doesn't work. What am I doing wrong?

Answer

DhruvPathak picture DhruvPathak · Oct 21, 2011

It should be :

from pymongo.objectid import ObjectId   
thing = db.things.find_one({'_id': ObjectId('4ea113d6b684853c8e000001') })

EDIT: The current import is: from bson.objectid import ObjectId

Related questions

mongo - couldn't connect to server 127.0.0.1:27017

I am coming from riak and redis where I never had an issue with this services starting, or to interact. This is a pervasive problem with mongo and am rather clueless. Restarting does not help.I am new to mongo. …

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
How to update values using pymongo?

I've a mongodb collection in this form: {id=ObjectId(....),key={dictionary of values}} where dictionary of values is {'a':'1','b':'2'.....} Let dictionary of values be 'd'. I need to update the values of the key in …

Read More