Querying mongoDb using pymongo with variable values

Question

Consider the have the following collection:

db.collection.insert({id:1, value:1})
db.collection.insert({id:2, value:2})
db.collection.insert({id:3, value:3})

Now, I have a file which has a list of ids. I can read the file and store the id in a variable. How do I now query the collection to get the details of that particular id:

f=open("file.txt")
for line in f:
  idTemp=line.strip()
  db.collection.find_one({"id":idTemp}) #This does not work

Daniel Roseman · Accepted Answer · 2015-09-22 07:28:16Z

4

id is an int, but anything read directly from a file is a string. Convert it to int first:

idTemp = int(line.strip())

answered Sep 22, 2015 at 7:28

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

1 Comment

Sathyanarayanan Ganesan Over a year ago

Can you help me with this, stackoverflow.com/questions/37707033/…

Collectives™ on Stack Overflow

Querying mongoDb using pymongo with variable values

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related