锦中迎新管理系统

from flask import Flask, request

from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///students.db'

db = SQLAlchemy(app)

class Student(db.Model):

id = db.Column(db.Integer, primary_key=True)

name = db.Column(db.String(80), nullable=False)

student_id = db.Column(db.String(20), unique=True, nullable=False)

reason = db.Column(db.Text, nullable=False)

status = db.Column(db.String(20), default='pending')

approver = db.Column(db.String(80))

@app.route('/apply', methods=['POST'])

def apply():

data = request.json

new_application = Student(name=data['name'], student_id=data['student_id'], reason=data['reason'])

db.session.add(new_application)

db.session.commit()

return {'message': 'Application submitted.'}, 201