python - 使用 Pymongo 在 MongoDB 中提取最新文档的时间戳

Question

我有 mongoDB collection带列filename和 text
我想提取最新 document 的时间戳使用 pymongo
我试过的:

from pymongo import MongoClient
host = "127.0.0.1:27017"
client = MongoClient(host)

# print(client)

# Getting a database
db = client['ResumeParsing']
# Getting a collection
coll = db.Resume

print(coll.find({"_id": {"$gt": 1}}).sort([("_id", 1), ("date", -1)]))

这给了我输出:

<pymongo.cursor.Cursor object at 0x00000187738CD860>

虽然我想要日期时间作为结果。

Answer 1

我找到了解决办法。

from pymongo import MongoClient
import pymongo

host = "127.0.0.1:27017"
client = MongoClient(host)

db = client['ResumeParsing']

coll = db.Resume

# Convert the output of query into list 
latest_doc = list(db.Resume.find().sort("_id", pymongo.DESCENDING).limit(1))

# use generation_time attribute to get datetime from _id
print(latest_doc[0]['_id'].generation_time)

这给了我输出:

2018-08-27 09:16:56+00:00