mongodb 时间戳转_id

#!/usr/bin/env python
# -*- coding:utf-8 -*-
import json
from pymongo import MongoClient
import time
def id2time(object_id):
    timeStamp = int(object_id[:8], 16)
    return time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(timeStamp))
import pymongo
import time
import datetime
from bson.objectid import ObjectId


def object_id_from_datetime(from_datetime=None):
    ''' According to the time manually generated an ObjectId '''
    if not from_datetime:
        from_datetime = datetime.datetime.now()
    return ObjectId.from_datetime(generation_time=from_datetime)


def range_search(start_timestamp, end_timestamp):
  connection = MongoClient("mongodb://20.5.101.31:27017/")
  with connection:
    db = connection['tlyy']
    table = db['checkf5']
    a = table.find({'_id':{'$lt' : end_timestamp, '$gte' : start_timestamp}})
    print  a
    print type(a)
    print a.limit(1000)
    b=a.limit(1000)
    print type(b)
    for x in b:
        print x
if __name__ == '__main__':
  ##时间要减去8
  ##5cdeacb6a50a0b6015ca592a
  ##5cdeacb60000000000000000
  ##<class 'bson.objectid.ObjectId'>
  ##2019-05-17 20:44:38
  #start time
  start_time = datetime.datetime(2019, 05, 17, 12, 44, 38)
  start_timestamp = object_id_from_datetime(start_time)
  print start_timestamp