| 1234567891011121314151617181920212223242526272829303132333435363738 |
- from pymongo import MongoClient
- import pymongo
- import datetime
- #CONNECTION_STRING = "mongodb+srv://<username>:<password>@<cluster-name>.mongodb.net/test"
- CONNECTION_STRING = "mongodb://mongoAdmin:chan9eM3@hhh.ptt.cx"
- #CONNECTION_STRING = "mongodb://mongoAdmin:chan9eM3@hhh.ptt.cx/logs"
- client = MongoClient(CONNECTION_STRING)
- print(client)
- cols=client['logs']
- #print(cols)
- col=cols['syslog']
- #cursor=col.find({}).sort('time_rcvd',pymongo.DESCENDING)
- cursor=col.find({})
- #cursor=col.find({}).sort('time_rcvd',pymongo.DESCENDING)
- cnt=0
- for c in cursor:
- # print(c)
- # if 'clickbot_100' in c['msg']:
- if 'poibot' in c['msg']:
- dt=c['time_rcvd']
- dt=dt.replace(tzinfo=datetime.timezone.utc) #Convert it to an aware datetime object in UTC time.
- dt=dt.astimezone() #Convert it to your local timezone (still aware)
- print(dt.strftime('%Y-%m-%d %H:%M:%S'))
- # print(dt.strftime("%d %b %Y %I:%M:%S:%f %p"))
- # print(c['time_rcvd'])
- print(c['msg'])
- cnt+=1
- # if cnt>=100000:
- # break
- #print(col)
- #col.insert_one({"item_name" : "Bread",'id':1234,'name':'中文測試'})
|
