# -*- 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()
名称栏目:获取一周内的告警日志(python|Oracle)
本文网址:https://www.cdcxhl.com/article28/pshjcp.html
成都网站建设公司_创新互联,为您提供网站内链、ChatGPT、微信公众号、企业建站、自适应网站、服务器托管
广告
声明:本网站发布的内容(图片、视频和文字)以用户投稿、用户转载内容为主,如果涉及侵权请尽快告知,我们将会在第一时间删除。文章观点不代表本网站立场,如需处理请联系客服。电话:028-86922220;邮箱:631063699@qq.com。内容未经允许不得转载,或转载时需注明来源:
创新互联