msg = MIMEMultipart('related')
emailfrom = "*****@*****.**"
msg['From'] = emailfrom
msg['To'] = self.mailto
msg['Subject'] = Header(self.subject, 'utf-8')
days = return_yesterday()
sql = "select day,host,sid,title,round(total_bytes/(1024*1024*1024),2),round(ratio*100,2),rank from cdn_sendbytes_statistics where rank<=10 and day='%s';" % days
data = get_data_mysql(sql)
mail_host = "smtp.exmail.qq.com" # 设置服务器
mail_user = "******" # 用户名
mail_pass = "******" # 口令
body = render_template('2.html', data=data, days=days)
msgText = MIMEText(body, 'html', 'utf-8')
msg.attach(msgText)
try:
smtpObj = smtplib.SMTP()
smtpObj.connect(mail_host, 25) # 25 为 SMTP 端口号
smtpObj.login(mail_user, mail_pass)
smtpObj.sendmail(emailfrom, self.mailto.split(","),
msg.as_string())
print "邮件发送成功"
except smtplib.SMTPException:
print "Error: 无法发送邮件"
raise ("Get values error")
if __name__ == '__main__':
mail = SendMail()
mail.send_mail()
