Mongo query in python if I use variable as value

Question

Am trying to find documents from the mongo collection using the following query. db.collection_name.find({"id" : Id}) where Id is the variable am getting as input. But it doesn't work. If I hard code the value like this db.collection_name.find({"id" : "1a2b"}) it works. "id" is of string type and am using pymongo to access mongo DB.

code :

client = MongoClient("localhost:27017")                
db = client['sample_database']
Id = raw_input("enter id") 
cursor = db.collection_name.find({"id" : Id})

can you please share all of your code before calling find()? — erolkaya84, Jun 08 '16 at 15:44
Where did you define your Id? I would expect something like this; Id = str(post_id) — erolkaya84, Jun 08 '16 at 15:51
Possible duplicate of [How do I use pymongo to connect to an existing document collection/db?](http://stackoverflow.com/questions/14468992/how-do-i-use-pymongo-to-connect-to-an-existing-document-collection-db) — Amin Alaee, Jun 08 '16 at 15:54

score 3 · Answer 1 · answered Jun 08 '16 at 15:57

3

Try str();

Id = str(raw_input("enter id"))
cursor = db.collection_name.find({"id" : Id})

answered Jun 08 '16 at 15:57

erolkaya84

1,454
18
24

score 2 · Answer 2 · answered Jun 27 '16 at 12:08

This may help you..in python3 it is working..

Id = raw_input("enter id: ") 
cursor = db.collection_name.find({"id" : Id})
for i in cursor:
    print(i)

there is no require to convert raw_input() to string,Because raw_input() is already get input from user as string..

Mongo query in python if I use variable as value

2 Answers2

Linked