统一消息系统

# 导入必要的库

from transformers import AutoTokenizer, AutoModelForSeq2SeqLM

import sqlite3

# 加载预训练模型和分词器

tokenizer = AutoTokenizer.from_pretrained("google/flan-t5-base")

model = AutoModelForSeq2SeqLM.from_pretrained("google/flan-t5-base")

# 用户输入的自然语言查询

user_query = "帮我查一下上个月销售额最高的产品"

# 将自然语言转换为SQL

input_ids = tokenizer(user_query, return_tensors="pt").input_ids

outputs = model.generate(input_ids)

sql_query = tokenizer.decode(outputs[0], skip_special_tokens=True)

print("生成的SQL查询:", sql_query)

# 连接数据库并执行查询

conn = sqlite3.connect('sales.db')

cursor = conn.cursor()

cursor.execute(sql_query)

results = cursor.fetchall()

for row in results:

print(row)

conn.close()

# 导入必要的库

from transformers import pipeline

import smtplib

from email.mime.text import MIMEText

# 初始化文本生成器

generator = pipeline("text-generation", model="gpt-3.5-turbo")

# 生成报告内容

report_content = generator(

"请根据以下销售数据生成一份简要报告：\n"

"产品A: 销售额10000元\n"

"产品B: 销售额8000元\n"

"产品C: 销售额6000元",

max_length=200,

num_return_sequences=1

)[0]['generated_text']

print("生成的报告内容:\n", report_content)

# 配置邮件参数

sender_email = "your_email@example.com"

receiver_email = "recipient@example.com"

subject = "销售报告"

message = MIMEText(report_content)

message["Subject"] = subject

message["From"] = sender_email

message["To"] = receiver_email

# 发送邮件

with smtplib.SMTP("smtp.example.com") as server:

server.starttls()

server.login(sender_email, "your_password")

server.sendmail(sender_email, receiver_email, message.as_string())

print("报告已成功发送！")