我们提供统一消息系统招投标所需全套资料,包括统一消息系统介绍PPT、统一消息系统产品解决方案、
统一消息系统产品技术参数,以及对应的标书参考文件,详请联系客服。
CREATE TABLE users (
user_id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(50) NOT NULL
);
CREATE TABLE messages (
message_id INT PRIMARY KEY AUTO_INCREMENT,
sender_id INT,
receiver_id INT,
content TEXT NOT NULL,
FOREIGN KEY (sender_id) REFERENCES users(user_id),
FOREIGN KEY (receiver_id) REFERENCES users(user_id)
);
CREATE TABLE status (
status_id INT PRIMARY KEY AUTO_INCREMENT,
message_id INT,
is_read BOOLEAN DEFAULT FALSE,
FOREIGN KEY (message_id) REFERENCES messages(message_id)
);
]]>
from flask import Flask, request, jsonify
app = Flask(__name__)
@app.route('/send_message', methods=['POST'])
def send_message():
data = request.get_json()
sender = data['sender']
receiver = data['receiver']
content = data['content']
# Insert into database
cursor.execute("INSERT INTO messages (sender_id, receiver_id, content) VALUES (%s, %s, %s)", (sender, receiver, content))
db.commit()
return jsonify({"status": "success"}), 200
if __name__ == '__main__':
app.run(debug=True)
]]>