#! /usr/bin/env python
# --*-- coding:utf-8 --*--
import pymongo
import re
host="**.**.**.**"
port=27017
conn = pymongo.MongoClient(host=host,port=port,tz_aware=False)
db_name = "test"
log_name = "col"
db_test = conn.get_database(db_name)
col_col = db_test.get_collection(log_name)
#print "db names:", conn.database_names()
#print "col names:", db_test.collection_names()
#print "one_line:", col_col.find_one()
#print "one_line_keys:", col_col.find_one().keys()
#col_col.insert({"message2":"hihihi", "msg":"123"})
#col_col.update({"message":"hello*3"}, {"$set":{"message":"hello*3*9"}})
import datetime
y,M,d,h,m,s = 2016,2,13,18,30,0
d = datetime.datetime(y,M,d,h,m,s)
delta = datetime.timedelta(hours=8)
d = d-delta
#logs = col_col.find( {"data":{"$gt":d} } )
#logs = col_col.find( {"message":re.compile("hi")} )
logs = col_col.find( {"$and": [{"message":re.compile("hi")}, {"data":{"$gt":d} }]} )
c = logs.count()
for l in logs:
print l
print "count:", c
print "END!"