Python自动化脚本实现

import mysql.connector
from mysql.connector import errorcode

config = {
  'user': 'root',
  'password': '******',
  'host': '127.0.0.1',
  'database': 'tsinghua',
  'raise_on_warnings': True,
}

try:
    cnx = mysql.connector.connect(**config)
except mysql.connector.Error as err:
    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
        print("Something is wrong with your user name or password")
    elif err.errno == errorcode.ER_BAD_DB_ERROR:
        print("Database does not exist")
    else:
        print(err)

cursor = cnx.cursor()

cursor.execute(sqlStr)
cnx.close()

import smtplib
import mimetypes
from email.MIMEMultipart import MIMEMultipart
from email.mime.audio import MIMEAudio
from email.mime.base import MIMEBase
from email.mime.image import MIMEImage
from email.mime.text import MIMEText
from email import encoders
from email.utils import parseaddr, formataddr
from email.header import Header

def sendEmail(fromaddr, senderName, toaddr, subject, body, filename,
              fileToSend):
    """
    fromaddr 发件人邮箱
    senderName 发件人姓名
    toaddr 收件人邮箱，多个邮箱用逗号分隔，格式为
            '"yangle@kaoshixing.com","liyang0007@mail.tsinghua.edu.cn"'
    subject 邮件标题
    body 邮件正文
    filename 附件名称
    fileToSend 附件路径
    """
    # 格式化地址函数
    def _format_addr(s):
        name, addr = parseaddr(s)
        return formataddr((Header(name, 'utf-8').encode(),
                           addr.encode('utf-8') if isinstance(addr, unicode)
                           else addr))

    # 邮件内容
    msg = MIMEMultipart()
    # 收件人会看到发件人的姓名，而不只是邮件地址
    msg['From'] = _format_addr(u'%s <%s>' % (senderName, fromaddr))
    msg['To'] = _format_addr(u'<%s>' % toaddr)
    # 邮件标题
    msg['Subject'] = Header(subject, 'utf-8').encode()
    # 邮件正文
    msg.attach(MIMEText(body.encode("utf-8") if isinstance(body, unicode) else
                        body, 'plain'))

    # 处理附件，处理不同的格式
    ctype, encoding = mimetypes.guess_type(fileToSend)
    if ctype is None or encoding is not None:
        ctype = "application/octet-stream"
    maintype, subtype = ctype.split("/", 1)
    if maintype == "text":
        fp = open(fileToSend)
        attachment = MIMEText(fp.read(), _subtype=subtype)
        fp.close()
    elif maintype == "image":
        fp = open(fileToSend, "rb")
        attachment = MIMEImage(fp.read(), _subtype=subtype)
        fp.close()
    elif maintype == "audio":
        fp = open(fileToSend, "rb")
        attachment = MIMEAudio(fp.read(), _subtype=subtype)
        fp.close()
    else:
        fp = open(fileToSend, "rb")
        attachment = MIMEBase(maintype, subtype)
        attachment.set_payload(fp.read())
        fp.close()
        encoders.encode_base64(attachment)
    attachment.add_header(
        "Content-Disposition", "attachment",
        filename=filename.encode("utf-8") if isinstance(filename, unicode)
        else filename)
    msg.attach(attachment)

    # 连接邮件服务
    server = smtplib.SMTP()
    server.connect('smtp.163.com')
    server.login(fromaddr, "FrrqWs5I")

    # 发送邮件
    text = msg.as_string()
    server.sendmail(fromaddr, toaddr, text)
    server.quit()
    
fromaddr = "18601036905@163.com"
senderName = u"杨乐"
# 多个收件人采用这种格式
toaddr = '"yangle@kaoshixing.com","766433030@qq.com"'
subject = u"报名统计表"
body = u"请查收附件"
# 附件名称
filename = "tsinghua1008.csv"
# 附件在磁盘上的路径
fileToSend = "/tmp/tsinghua1008.csv"

sendEmail(fromaddr, senderName, toaddr, subject, body, filename,
          fileToSend)