基于后端开发的漳州高校排课系统设计与实现

from flask import Flask

app = Flask(__name__)

@app.route('/')

def index():

return "漳州高校排课系统"

if __name__ == '__main__':

app.run(debug=True)

]]>

from flask_sqlalchemy import SQLAlchemy

app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://username:password@localhost/vocourse'

db = SQLAlchemy(app)

class Course(db.Model):

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

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

teacher_id = db.Column(db.Integer, db.ForeignKey('teacher.id'))

]]>

with app.app_context():

db.create_all()

course = Course(name="计算机科学导论", teacher_id=1)

db.session.add(course)

db.session.commit()

]]>

@app.route('/courses', methods=['GET'])

def get_courses():

courses = Course.query.all()

return [{"id": c.id, "name": c.name} for c in courses]

]]>