# This is a sample Python script.
from smtplib import SMTP_SSL
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from email.mime.application import MIMEApplication
import os
import pymysql
import openpyxl
import pandas as pd
import email.utils
sql = '''select id,name from t'''
//將本地文件以附件的方式發(fā)送
def send_mail(message, subject, sender_show, recipient_show, to_addrs, cc_show=''):
    '''
    :param message: str 郵件內(nèi)容
    :param subject: str 郵件主題描述
    :param sender_show: str 發(fā)件人顯示，不起實(shí)際作用如："xxx"
    :param recipient_show: str 收件人顯示，不起實(shí)際作用 多個(gè)收件人用','隔開(kāi)如："xxx,xxxx"
    :param to_addrs: str 實(shí)際收件人
    :param cc_show: str 抄送人顯示，不起實(shí)際作用，多個(gè)抄送人用','隔開(kāi)如："xxx,xxxx"
    '''
    # 填寫(xiě)真實(shí)的發(fā)郵件服務(wù)器用戶(hù)名、密碼
    user = 'user_name@qq.com'
    password = 'jxsnhxlaerizbihi'  //授權(quán)碼
    host = 'smtp.qq.com'
    # 郵件內(nèi)容
    # msg = MIMEText(message, 'plain', _charset="utf-8")
    content = MIMEText(message)
    msg = MIMEMultipart()  # 多個(gè)MIME對(duì)象
    msg.attach(content)  # 添加內(nèi)容
    # 郵件主題描述
    msg["Subject"] = subject
    # 發(fā)件人顯示，不起實(shí)際作用
    msg["From"] = sender_show
    # 收件人顯示，不起實(shí)際作用
    msg["To"] = recipient_show
    # 抄送人顯示，不起實(shí)際作用
    msg["Cc"] = cc_show
    cur_dir = os.path.dirname(os.path.realpath(__file__))
    file_name = 'filename.xlsx'  # 文件名
    file_path = os.path.join(cur_dir, file_name)  # 文件路徑
    xlsx = MIMEApplication(open(file_path, 'rb').read())  # 打開(kāi)Excel,讀取Excel文件
    xlsx["Content-Type"] = 'application/octet-stream'  # 設(shè)置內(nèi)容類(lèi)型
    xlsx.add_header('Content-Disposition', 'attachment', filename=file_name)  # 添加到header信息
    msg.attach(xlsx)
    with SMTP_SSL(host=host, port=465) as smtp:
        # 登錄發(fā)郵件服務(wù)器
        smtp.login(user=user, password=password)
        # 實(shí)際發(fā)送、接收郵件配置
        # smtp.sendmail(from_addr=user, to_addrs=to_addrs.split(','), msg=msg.as_string())
        smtp.sendmail(from_addr=user, to_addrs=to_addrs.split(','), msg=msg.as_string())
//從mysql中查詢(xún)數(shù)據(jù)寫(xiě)入本地xlsx文件
def get_data():
    con_engine = pymysql.connect(host='host_address',
                                 user='app_read', password='pwd', database='db_name', 								port=3306, charset='utf8')  # 通過(guò)參數(shù)形式傳遞，參數(shù)是字符串形式
    global sql
    df = pd.read_sql(sql, con_engine)
    file = 'file_name.xlsx'
    if os.path.exists(file):
        os.remove(file)
    df.to_excel(file, 'sheet1', index=False)
# Press the green button in the gutter to run the script.
if __name__ == '__main__':
    get_data()
    send_mail('見(jiàn)附件', '標(biāo)題', 'sender', 'recipient','jjt@xxx.com')