统一消息系统

CREATE TABLE messages (

id INT AUTO_INCREMENT PRIMARY KEY,

sender_id INT NOT NULL,

receiver_id INT NOT NULL,

content TEXT NOT NULL,

timestamp DATETIME DEFAULT CURRENT_TIMESTAMP

);

from sqlalchemy import create_engine, Column, Integer, Text, DateTime

from sqlalchemy.ext.declarative import declarative_base

from sqlalchemy.orm import sessionmaker

Base = declarative_base()

class Message(Base):

__tablename__ = 'messages'

id = Column(Integer, primary_key=True)

sender_id = Column(Integer, nullable=False)

receiver_id = Column(Integer, nullable=False)

content = Column(Text, nullable=False)

timestamp = Column(DateTime, default=datetime.now)

engine = create_engine('sqlite:///messages.db')

Session = sessionmaker(bind=engine)

session = Session()

def add_message(sender_id, receiver_id, content):

new_message = Message(sender_id=sender_id, receiver_id=receiver_id, content=content)

session.add(new_message)

session.commit()

from flask import Flask, send_file

app = Flask(__name__)

@app.route('/download/')

def download_scheme(scheme_id):

file_path = f'schemes/{scheme_id}.pdf'

return send_file(file_path, as_attachment=True)