监控报表是为业务保驾护航的有效工具,本文简单介绍一个通过读取接口获取数据,并发送邮件报表的功能
读取接口
import requests
url = ("https://xxx.com/api")
headers = {
'token': 'xxx'
}
response = requests.get(url, headers=headers)
data = response.json()
生成邮件内容
假设返回的数据如下:
data = [
{
'name': '首屏耗时',
'value': 1498
},
{
'name': '接口耗时',
'value': 456
}
]
拼接邮件模板
content = """
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style>
table {
border-collapse: collapse;
border-spacing: 0;
border: 1px solid #999;
text-align: left;
}
table th {
background-color: #def;
font-size: 10px;
border: 1px solid #999;
padding: 0 5px;
}
table td {
font-size: 10px;
border: 1px solid #999;
padding: 0 5px;
}
</style>
<body>
<div id="container">
<p>数据报表:</p>
<table width="400" border="0" cellspacing="0">
"""
for item in data:
content = content + """<tr><th>""" + str(item['name']) + """</th><td>""" + str(item['value']) + """</td></tr>"""
content = content + """
</table>
</div>
</body>
</html>
"""
发送邮件
import datetime
import smtplib
import email
from email.mime.text import MIMEText
from email.mime.image import MIMEImage
from email.mime.multipart import MIMEMultipart
from email.header import Header
# SMTP服务器,这里使用qq邮箱
mail_host = "smtp.qq.com"
# 发件人邮箱
mail_sender = "my@qq.com"
# 邮箱授权码,注意这里不是邮箱密码,如何获取邮箱授权码,如下url
# https://service.mail.qq.com/cgi-bin/help?subtype=1&&id=28&&no=1001256
mail_license = "xxxx"
# 收件人邮箱,可以为多个收件人
mail_receivers = ["x1@qq.com", "x2@qq.com"]
mm = MIMEMultipart('related')
# 邮件主题
subject_content = """测试邮件日报""" + datetime.datetime.now().strftime('%Y-%m-%d')
# 设置发送者,注意严格遵守格式,里面邮箱为发件人邮箱
mm["From"] = "my<my@qq.com>"
# 设置接受者,注意严格遵守格式,里面邮箱为接受者邮箱
mm["To"] = ','.join(mail_receivers)
# 设置邮件主题
mm["Subject"] = Header(subject_content,'utf-8')
# 邮件正文内容
body_content = content
# 构造文本,参数1:正文内容,参数2:文本格式,参数3:编码方式
message_text = MIMEText(body_content,"html","utf-8")
# 向MIMEMultipart对象中添加文本对象
mm.attach(message_text)
# 创建smtp
stp = smtplib.SMTP()
# 设置发件人邮箱的域名和端口,端口地址为25
stp.connect(mail_host, 25)
# set_debuglevel(1)可以打印出和SMTP服务器交互的所有信息
stp.set_debuglevel(1)
# 登录邮箱,传递参数1:邮箱地址,参数2:邮箱授权码
stp.login(mail_sender,mail_license)
# 发送邮件,传递参数1:发件人邮箱地址,参数2:收件人邮箱地址,参数3:把邮件内容格式改为str
stp.sendmail(mail_sender, mail_receivers, mm.as_string())
print("邮件发送成功")
# 关闭SMTP对象
stp.quit()
邮件效果
通过crontab定时发送
crontab -e
# 写入如下内容就可以了,比如每天11:11发送邮件
11 11 * * * /usr/bin/python /home/xxx/my.py