import pymongo
import time
from concurrent.futures import ThreadPoolExecutor
def id2time(object_id):
timeStamp = int(object_id[:8], 16)
return time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(timeStamp)),timeStamp
myclient = pymongo.MongoClient('mongodb://用户名:密码@ip地址:端口/数据库名')
db = myclient['数据库名']
x = db.表名.find()
def Mongo(i):
createdata,timestamp = id2time(str(i['_id']))
db.表名.update({"_id":i['_id']}, {"$set": {'createdate': createdata,'timestamp': timestamp}})
with ThreadPoolExecutor(50) as executor:
for j in x:
executor.submit(Mongo, j)