Find by ObjectId

[rewiaca]

Could not find by ObjectId. Code:

from bson.objectid import ObjectId

x = collection.find()
i = list(x)[0]['_id']

y = collection.find({'_id': ObjectId(i)})
print(list(y))

I see that database in mdb format has "_id": {"$oid": "id"} and I tried to find id in string with: {"_id.$oid": "string id"} but anyway, it would not work. Any suggestions? Thanks!

[davidlatwe]

Hi @rewiaca ,

I see that database in mdb format has "_id": {"$oid": "id"} ..

That should be JSON serialized format which used for saving document in disk, not how the document looks in database.

Back to the main issue.

I think this is a bug. If you change to import ObjectId class from montydb.types.bson_, you should find the doc.

from montydb import MontyClient
from montydb.types.bson_ import ObjectId

client = MontyClient(":memory:")
collection = client["test"]["col"]

x = collection.find()
i = list(x)[0]['_id']

y = collection.find({'_id': ObjectId(i)})
print(list(y))

[rewiaca]

@davidlatwe, thanks!
from montydb.types.objectid import ObjectId
Worked for me.