mysql存储过程发邮件

DELIMITER //

CREATE PROCEDURE SendEmail(
    IN p_to VARCHAR(255),
    IN p_subject VARCHAR(255),
    IN p_message TEXT
)
BEGIN
    -- 这里可以调用外部程序或服务来发送邮件
    -- 例如，通过执行一个系统命令来调用 Python 脚本
    SET @command = CONCAT('python3 /path/to/send_email.py ', p_to, ' ', p_subject, ' ', p_message);
    PREPARE stmt FROM @command;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
END //

DELIMITER ;

import sys
import smtplib
from email.mime.text import MIMEText

def send_email(to, subject, message):
    # 邮件服务器配置
    smtp_server = 'smtp.example.com'
    smtp_port = 587
    smtp_username = 'your_email@example.com'
    smtp_password = 'your_email_password'

    # 创建邮件对象
    msg = MIMEText(message)
    msg['Subject'] = subject
    msg['From'] = smtp_username
    msg['To'] = to

    # 发送邮件
    with smtplib.SMTP(smtp_server, smtp_port) as server:
        server.starttls()
        server.login(smtp_username, smtp_password)
        server.sendmail(smtp_username, [to], msg.as_string())

if __name__ == '__main__':
    to, subject, message = sys.argv[1], sys.argv[2], sys.argv[3]
    send_email(to, subject, message)