python读取mongodb并写入文件

 

#!/usr/bin/env python
#coding=utf-8

from pymongo import MongoClient
import time
from datetime import datetime
import ast


def chaxun_data():
    ##client = MongoClient("192.168.1.170:28001",maxPoolSize=None)
    url = "mongodb://%s:%s@%s" % ('ureadonly', 'ureadonly123', "192.168.1.170:28001/mgdb_message")
    conn = MongoClient(url)
    db = conn.mgdb_message
    collection = db["t_push_record"]
    ##x = collection.find_one()

    with open ('mytest.txt', 'w') as f:
#接下来可实现提取想要的字段内的数据
        for item in collection.find({"update_time": { "$gte" : datetime(2023,3,14), "$lt" : datetime(2023,3,15) } }).limit(10):
            f.write(str(item))

            ##f.write(str(item["update_time"]))

            f.write('\n')
    f.close()


if __name__ == '__main__':
    print("开始时间:"+time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())))
    l_flag = chaxun_data()
    print("结束时间:"+time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())))

 

运行输出文件内容

 

{'_id': ObjectId('6411072f0fa06a0001b776d8'), 'msg_id': 1635789365668007936, 'dev_token': '1a0018970a47facd6e1', 'push_msg_id': '18100656211008846', 'status': 1, 'biz': 1, 'pusher_type': 2, 'create_time': datetime.datetime(2023, 3, 14, 23, 45, 51, 528000), 'update_time': datetime.datetime(2023, 3, 14, 23, 45, 51, 528000)}
{'_id': ObjectId('6411059d0fa06a0001b776d7'), 'msg_id': 1635787678165291008, 'dev_token': '170976fa8a3464d6e9a', 'push_msg_id': '18100656202855130', 'status': 10, 'biz': 1, 'pusher_type': 2, 'create_time': datetime.datetime(2023, 3, 14, 23, 39, 9, 175000), 'update_time': datetime.datetime(2023, 3, 14, 23, 39, 22, 394000)}
{'_id': ObjectId('641103390fa06a0001b776d6'), 'msg_id': 1635785115089031168, 'dev_token': '121c83f760f09eeb5d7', 'push_msg_id': '18100656189891624', 'status': 10, 'biz': 1, 'pusher_type': 2, 'create_time': datetime.datetime(2023, 3, 14, 23, 28, 57, 704000), 'update_time': datetime.datetime(2023, 3, 14, 23, 29, 52, 840000)}
{'_id': ObjectId('641103390fa06a0001b776d4'), 'msg_id': 1635785115089031169, 'dev_token': '121c83f760f09eeb5d7', 'push_msg_id': '18100656190216187', 'status': 10, 'biz': 1, 'pusher_type': 2, 'create_time': datetime.datetime(2023, 3, 14, 23, 28, 57, 591000), 'update_time': datetime.datetime(2023, 3, 14, 23, 29, 37, 320000)}
{'_id': ObjectId('6411031e0fa06a0001b776c3'), 'msg_id': 1635785000416759808, 'dev_token': '121c83f760f09eeb5d7', 'push_msg_id': '18100656189284608', 'status': 10, 'biz': 1, 'pusher_type': 2, 'create_time': datetime.datetime(2023, 3, 14, 23, 28, 30, 360000), 'update_time': datetime.datetime(2023, 3, 14, 23, 29, 37, 28000)}
{'_id': ObjectId('641103210fa06a0001b776c5'), 'msg_id': 1635785013096140801, 'dev_token': '121c83f760f09eeb5d7', 'push_msg_id': '18100656189465422', 'status': 10, 'biz': 1, 'pusher_type': 2, 'create_time': datetime.datetime(2023, 3, 14, 23, 28, 33, 337000), 'update_time': datetime.datetime(2023, 3, 14, 23, 29, 34, 811000)}
{'_id': ObjectId('6411032d0fa06a0001b776cd'), 'msg_id': 1635785063851413504, 'dev_token': '121c83f760f09eeb5d7', 'push_msg_id': '18100656189443114', 'status': 10, 'biz': 1, 'pusher_type': 2, 'create_time': datetime.datetime(2023, 3, 14, 23, 28, 45, 501000), 'update_time': datetime.datetime(2023, 3, 14, 23, 29, 34, 803000)}
{'_id': ObjectId('641103360fa06a0001b776d2'), 'msg_id': 1635785102145409026, 'dev_token': '121c83f760f09eeb5d7', 'push_msg_id': '18100656189891014', 'status': 10, 'biz': 1, 'pusher_type': 2, 'create_time': datetime.datetime(2023, 3, 14, 23, 28, 54, 570000), 'update_time': datetime.datetime(2023, 3, 14, 23, 29, 30, 723000)}
{'_id': ObjectId('6411032d0fa06a0001b776cb'), 'msg_id': 1635785063851413505, 'dev_token': '121c83f760f09eeb5d7', 'push_msg_id': '18100656189385600', 'status': 10, 'biz': 1, 'pusher_type': 2, 'create_time': datetime.datetime(2023, 3, 14, 23, 28, 45, 386000), 'update_time': datetime.datetime(2023, 3, 14, 23, 29, 28, 460000)}
{'_id': ObjectId('641103300fa06a0001b776ce'), 'msg_id': 1635785076736315393, 'dev_token': '121c83f760f09eeb5d7', 'push_msg_id': '18100656190222642', 'status': 10, 'biz': 1, 'pusher_type': 2, 'create_time': datetime.datetime(2023, 3, 14, 23, 28, 48, 456000), 'update_time': datetime.datetime(2023, 3, 14, 23, 29, 24, 95000)}