Python SQL脚本-如何发送出错的电子邮件

import smtplib
from email.mime.text import MIMEText
from email.header import Header

def send_error_email(error_message):
    # 邮件配置
    smtp_server = "smtp.example.com"  # 邮件服务器地址
    smtp_port = 587  # 邮件服务器端口
    sender = "sender@example.com"  # 发件人邮箱
    receiver = "receiver@example.com"  # 收件人邮箱
    username = "username"  # 邮箱登录用户名
    password = "password"  # 邮箱登录密码

    # 构造邮件内容
    subject = "SQL脚本执行出错通知"
    content = f"SQL脚本执行出错，错误信息：\n\n{error_message}"
    message = MIMEText(content, "plain", "utf-8")
    message["From"] = Header(sender, "utf-8")
    message["To"] = Header(receiver, "utf-8")
    message["Subject"] = Header(subject, "utf-8")

    try:
        # 连接邮件服务器并发送邮件
        smtp_obj = smtplib.SMTP(smtp_server, smtp_port)
        smtp_obj.starttls()
        smtp_obj.login(username, password)
        smtp_obj.sendmail(sender, receiver, message.as_string())
        smtp_obj.quit()
        print("邮件发送成功")
    except Exception as e:
        print("邮件发送失败:", str(e))

# 调用示例
try:
    # 执行SQL脚本的代码
    # ...
    # 如果出错，抛出异常
    raise Exception("SQL脚本执行出错")
except Exception as e:
    # 发送出错的电子邮件
    send_error_email(str(e))