mongodb 的date 用的是0时区的, UTC 和 GMT, 所以我们要把自己的时间转换为UTC 的, 网上找了都不好用, 自己最后搞出来了
datetime.datetime.utcfromtimestamp(
time.mktime(
datetime.datetime.strptime('1/24/2019 12:19:56 AM', '%m/%d/%Y %I:%M:%S %p').utctimetuple()
)
)
#把字符串转为datetime
datetime.datetime.strptime('1/24/2019 12:19:56 AM', '%m/%d/%Y %I:%M:%S %p')
#把datetime 转为元组结构, 这样time 才能用到
datetime.utctimetuple()
#获取时间戳, 时间戳是一个Long型的数字,不受时区影响的
time.mktime(time元组)
#通过时间戳, 获取UTC 的datetime
datetime.datetime.utcfromtimestamp(时间戳)
在联网的环境下, 命令窗口直接输入pip install pymongo
C:\Users\lin>pip install pymongo
Collecting pymongo
Downloading https://files.pythonhosted.org/packages/10/35/f081e8f16cb357cc1e082743fed98fb699f3b9f215addc1b4b8bd1b58472/pymongo-3.7.2-cp37-cp37m-win_amd64.whl (311kB)
100% |████████████████████████████████| 317kB 68kB/s
Installing collected packages: pymongo
Successfully installed pymongo-3.7.2
python -c "import sys; print(sys.version)"
python -c "import pymongo; print(pymongo.version); print(pymongo.has_c())"
python -m pip install pymongo[snappy,gssapi,srv,tls]
Examples
Here’s a basic example (for more see the examples section of the docs):
>>> import pymongo
>>> client = pymongo.MongoClient("localhost", 27017)
>>> db = client.test
>>> db.name
u'test'
>>> db.my_collection
Collection(Database(MongoClient('localhost', 27017), u'test'), u'my_collection')
>>> db.my_collection.insert_one({"x": 10}).inserted_id
ObjectId('4aba15ebe23f6b53b0000000')
>>> db.my_collection.insert_one({"x": 8}).inserted_id
ObjectId('4aba160ee23f6b543e000000')
>>> db.my_collection.insert_one({"x": 11}).inserted_id
ObjectId('4aba160ee23f6b543e000002')
>>> db.my_collection.find_one()
{u'x': 10, u'_id': ObjectId('4aba15ebe23f6b53b0000000')}
>>> for item in db.my_collection.find():
... print(item["x"])
...
10
8
11
>>> db.my_collection.create_index("x")
u'x_1'
>>> for item in db.my_collection.find().sort("x", pymongo.ASCENDING):
... print(item["x"])
...
8
10
11
>>> [item["x"] for item in db.my_collection.find().limit(2).skip(1)]
[8, 11]
在PyCharm 里面的话, 要使用pymongo