构建基于科学管理的研究生管理系统

from flask import Flask, request, jsonify

from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

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

db = SQLAlchemy(app)

class Student(db.Model):

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

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

advisor_id = db.Column(db.Integer, db.ForeignKey('advisor.id'))

class Advisor(db.Model):

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

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

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

def add_student():

data = request.get_json()

new_student = Student(name=data['name'], advisor_id=data['advisor_id'])

db.session.add(new_student)

db.session.commit()

return jsonify({'message': 'Student added successfully'}), 201

]]>

数据融合