Querying by "_id" doesn't return file in MongoDB in Python, using PyMongo

Question

I'm using Python + MongoDB + PyMongo in Openshift

import os
import gridfs
from django.http import HttpResponse
from pymongo.connection import Connection
from django.shortcuts import get_object_or_404, render_to_response
from django.http import HttpResponseRedirect, HttpResponse
from django.template import Context, RequestContext,loader

connection = Connection('mongodb://sbose78:[email protected]:10068/BOSE')
db=connection['BOSE']
fs=gridfs.GridFS(db)

When I query a file by _id, this is what I get.

>>> fs.exists({"_id":'504a36d93324f20944247af2'})
False

When I query with the corresponding filename:

>>> fs.exists({"filename":'foo.txt'})

True

What could be possibly be going wrong?

Thanks.

Thomas · Accepted Answer · 2012-09-10 01:30:07Z

16

For pymongo versions < 2.2, you need to import ObjectId with

from pymongo.objectid import ObjectId

For versions 2.2 and above, the import is instead

from bson.objectid import ObjectId

Then you can query gridfs like so:

fs.exists(ObjectId('504a36d93324f20944247af2'))

answered Sep 10, 2012 at 1:30

Thomas

2,6381 gold badge15 silver badges10 bronze badges

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

Comments

vivek · Accepted Answer · 2012-09-09 13:49:35Z

0

fs.exists({"_id":ObjectId('504a36d93324f20944247af2')})

You need to use ObjectId

answered Sep 9, 2012 at 13:49

vivek

5,2496 gold badges27 silver badges34 bronze badges

5 Comments

sbose Over a year ago

I'm getting this NameError: name 'ObjectID' is not defined.

vivek Over a year ago

Its working for me here. Can you show all of your code here please.

sbose Over a year ago

Edited the question description with the imports Vivek.

vivek Over a year ago

I wanted to see if you are getting the object id correct. Can you show the code to get the object id?

vivek Over a year ago

No no. Let mongo generate ObjectIds. When you put/write object into the mongo db through gridfs, you'll get an object id. Use that.

Collectives™ on Stack Overflow

Querying by "_id" doesn't return file in MongoDB in Python, using PyMongo

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related