使用python从mongoDB获取3天数据 [英] Fetch 3 days data from mongoDB using python

问题描述

我正尝试使用python(pymongo)从mongoDB提取3天的旧数据.

I am trying to fetch 3 days old data from mongoDB using python (pymongo).

我对mongodb相当陌生.怎么做?.在此先感谢.

I am quite new to mongodb. How to do this ?.Thanks in advance.

我的数据库条目如下:

{
        "_id" : ObjectId("5d720d1d9c338906de2dbc812"),
        "timestamp" : ISODate("2019-11-12T08:00:00Z"),
        "city" : 'abc'
}
{
        "_id" : ObjectId("5d720d1d9c338906de2dbc813"),
        "timestamp" : ISODate("2019-11-11T09:00:00Z"),
        "city" : 'xyz'

}
{
        "_id" : ObjectId("5d720d1d9c338906de2dbc84"),
        "timestamp" : ISODate("2019-07-18T06:00:00Z"),
        "city": 'pqr'

}
{
        "_id" : ObjectId("5d720cb29c338906dd2d4ea1"),
        "timestamp" : ISODate("2019-11-11T07:00:00Z"),
        "city" : 'pqr'

}

推荐答案

只需使用gt(e)&带有日期时间对象的lt(e)运算符，pymongo会自行处理其余部分:

Just use gt(e) & lt(e) operators with datetime objects, pymongo will handle the rest itself:

#import pymongo
# ...
import datetime
end = datetime.datetime.utcnow()
start = end - datetime.timedelta(days=3)
cursor = db.collection.find({
'timestamp' : {'$gte': start, '$lte': end}
})
for item in cursor:
    print(item)

这篇关于使用python从mongoDB获取3天数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！