如何使用pymongo按oid范围计算文档

Question

我想计算它的oid在625d8b000000000000000000和625edc800000000000000000000之间的文档pymongo = = 3.12.3Mongodb 3.2和4.4

我把它写成blow:counter = coll.count_documents({"_id" : {"$in" : { "$oid" : "625d8b000000000000000000" }, { "$oid" : "625edc800000000000000000" }}})

我猜我们不能直接比较oid和string。它不工作，我不知道什么是正确的语法，请帮助!

Answer 1

import datetime
from bson.objectid import ObjectId
from pymongo import MongoClient
gen_time = datetime.datetime(2022, 1, 1)
dummy_id = ObjectId.from_datetime(gen_time)
result = collection.find({"_id": {"$lt": dummy_id}})

参考:https://pymongo.readthedocs.io/en/stable/api/bson/objectid.html