2 检测数据库的python代码:
cur.execute('UPDATE zabbix SET SENDTOWECHAT1=1,SENDTOWECHAT2=1 WHERE RESOLVED= 1 and SENDTOWECHAT1 = 0 and SENDTOWECHAT2=0')
conn.commit()
cur.execute('SELECT URL FROM zabbix WHERE RESOLVED=0 and SENDTOWECHAT1 = 0 and SENDTOWECHAT2=0')
resault=cur.fetchall()
message=''
for i in set(resault):
i=i[0]
cur.execute('SELECT HOST FROM zabbix WHERE RESOLVED=0 and SENDTOWECHAT1 = 0 and SENDTOWECHAT2=0 and URL="{0}"'.format(i))
resault=(set(cur.fetchall()))
HOST=''
for j in resault:
HOST=HOST+str(j[0])+","
print(HOST)
message=message+ ("节点{0}访问{1}出现问题。".format(HOST,i))
代码仅仅是抛砖引玉,