獲取一周內的告警日志(python|Oracle)
# -*- coding:UTF-8 -*-
#author: Rui Zhang
#date: 2017-08-09
#email: sharpzhang_2008@126.com
import datetime
def time_check():
yesterday=datetime.datetime.now() - datetime.timedelta(days=1)
#yesterday_wk=yesterday.strftime('%a')
#yesterday_mh=yesterday.strftime('%b')
#yesterday_dy=yesterday.strftime('%d')
yesterday_wmd=yesterday.strftime('%a %b %d')
today=datetime.datetime.now()
#today_wk=today.strftime('%a')
#today_mh=today.strftime('%b')
#today_dy=today.strftime('%d')
today_wmd=today.strftime('%a %b %d')
#argv1=yesterday_wmd
#argv2=today_wmd
return yesterday_wmd,today_wmd
def chk_db_log(time1,time2):
count_1=0
count_2=0
#with open("D:/alert_test1.log") as f:
f = open('D:/alert_test1.log','r')
a = f.readlines()
for line in a:
count_1=count_1+1
if time1 in line:
#print time
#print(count)
break
elif time2 in line:
break
for line in a:
count_2=count_2+1
if count_1<=count_2:
print(line.strip())
#else:
#print(line.strip())
f.close()
def main():
yday,tday=time_check()
#yday=time_check(argv1)
#tday=time_check(argv2)
#print yday,tday
#print yday
#print tday
print "------當前時間截止到昨天全天的所有數據庫告警日志--------"
print " 當前獲取日志時間:"+datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S');
print "------當前時間截止到昨天全天的所有數據庫告警日志--------"
chk_db_log(yday,tday)
if __name__ == "__main__":
main()