import smtplib
from email.mime.text import MIMEText
from email.mime.image import MIMEImage
from email.mime.multipart import MIMEMultipart
from email.mime.application import MIMEApplication
from sql_chi import *
import datetime

class Phpson:

    def __init__(self,msg_from,passwd,msg_to):
       
        self.sql_pool = My_mysql_connPool(max_connections=1, **info)

        self.msg_from = msg_from  # 發(fā)送方郵箱
        self.passwd = passwd  # 填入發(fā)送方郵箱的授權(quán)碼（就是剛剛你拿到的那個(gè)授權(quán)碼）
        self.msg_to = msg_to  # 收件人郵箱
        # # file_path = 'demo.xlsx' # 需要發(fā)送的附件目錄

        self.text_content = "這個(gè)參數(shù)是郵件內(nèi)容"#這個(gè)特別重要

    # 寫成了一個(gè)通用的函數(shù)接口，想直接用的話，把參數(shù)的注釋去掉就好
    def send_email(self, file_path=None):
        finishTime = datetime.datetime.now()
        msg = MIMEMultipart()
        subject =f"{finishTime}爬取新聞數(shù)據(jù)總數(shù)"  # 主題
        text = MIMEText(self.text_content)
        msg.attach(text)
        # docFile = 'C:/Users/main.py'  如果需要添加附件，就給定路徑
        if file_path:  # 最開始的函數(shù)參數(shù)我默認(rèn)設(shè)置了None ，想添加附件，自行更改一下就好
            docFile = file_path
            docApart = MIMEApplication(open(docFile, 'rb').read())
            docApart.add_header('Content-Disposition', 'attachment', filename=docFile)
            msg.attach(docApart)
            print('發(fā)送附件！')
        msg['Subject'] = subject
        msg['From'] = self.msg_from
        msg['To'] = self.msg_to
        try:
            s = smtplib.SMTP_SSL("smtp.qq.com", 465)
            s.login(self.msg_from, self.passwd)
            s.sendmail(self.msg_from, self.msg_to, msg.as_string())
            print("發(fā)送成功")
        except smtplib.SMTPException as e:
            print("發(fā)送失敗")
        finally:
            s.quit()


fs = ['97679',"wangqi"]  # 發(fā)送方郵箱
sq = ['widr',"wihxa"]  # 填入發(fā)送方郵箱的授權(quán)碼（就是剛剛你拿到的那個(gè)授權(quán)碼）
sj = ['97679',"wangq"]  # 收件人郵箱

for i in range(len(fs)):
    wqx = Phpson(fs[i],sq[i],sj[i])
    wqx.Dintes()
    wqx.send_email()