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
– erolkaya84, Commented Jun 8, 2016 at 15:44
Where did you define your Id? I would expect something like this; Id = str(post_id) — erolkaya84
– erolkaya84, Commented Jun 8, 2016 at 15:51
Possible duplicate of How do I use pymongo to connect to an existing document collection/db? — Amin Alaee
– Amin Alaee, Commented Jun 8, 2016 at 15:54

erolkaya84 · Accepted Answer · 2016-06-08 15:57:13Z

3

Try str();

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

answered Jun 8, 2016 at 15:57

erolkaya84

1,85922 silver badges29 bronze badges

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

Comments

ghanshyam dudhatra · Accepted Answer · 2016-06-27 12:08:11Z

2

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..

answered Jun 27, 2016 at 12:08

ghanshyam dudhatra

336 bronze badges

Collectives™ on Stack Overflow

Mongo query in python if I use variable as value

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related