学习python笔记
先上代码
import smtplib
import pymysql
from email.mime.text import MIMEText
from email.header import Header
l = ()
#mysql数据库连接
mydb = pymysql.connect("47.180.201.35","zhxxx","Zhxxx@123","zhxxx")
#创建游标
cursor = mydb.cursor()
#执行sql
cursor.execute("select * from t_bat_cutctl")
#接收一行数据
data = cursor.fetchone()
l = data
flag1 = l[5]
flag2 = l[6]
flag3 = l[7]
print(flag1,flag2,flag3)
if((int(flag1) != 1) or (int(flag2) != 0) or (int(flag3) != 0)):
sender = '1122574369@qq.com'
receivers = ['xsnjnxs@ijuxsjsoft.com']
#设置邮件基本信息
message = MIMEText('服务器重要通知 : 172.17.145.30 批处理失败,请及时查看处理,以免影响正常交易!','plain','utf-8')
#message = MIMEText("abc")
message['From'] = Header("服务器",'utf-8')
message['To'] = Header("交运",'utf-8')
subject = '服务器告警'
message['subject'] = Header(subject,'utf-8')
try:
smtpObj = smtplib.SMTP()
smtpObj.connect('smtp.qq.com',25)
smtpObj.set_debuglevel(1)
smtpObj.login(sender, 'nrajdxedingjxxxx')
smtpObj.sendmail(sender,receivers,message.as_string())
print("Succuss,发送成功")
except smtplib.SMTPException:
print("Error,邮件发送失败")
else:
print("批处理正常")
mydb.close()
最近自己自学python,感觉还挺好玩的,正好遇到公司的一些监控缺失,所以就写了一个小工具,来监控系统运行的情况。