一站式网上办事大厅
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL UNIQUE,
password_hash VARCHAR(255) NOT NULL,
role ENUM('admin', 'teacher', 'student') DEFAULT 'student'
);
]]>
CREATE TABLE processes (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT,
type ENUM('registration', 'reimbursement') NOT NULL,
status ENUM('pending', 'approved', 'rejected'),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES users(id)
);
]]>
from flask import Flask, request, jsonify
app = Flask(__name__)
@app.route('/submit', methods=['POST'])
def submit():
data = request.get_json()
# 检查参数完整性
if not all(key in data for key in ('type', 'user_id')):
return jsonify({'error': 'Missing required fields'}), 400
# 插入新流程
cursor.execute("INSERT INTO processes (user_id, type) VALUES (%s, %s)",
(data['user_id'], data['type']))
db.commit()
return jsonify({'message': 'Process submitted successfully'}), 201
if __name__ == '__main__':
app.run(debug=True)
]]>
