一站式网上办事大厅

from flask import Flask

from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

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

db = SQLAlchemy(app)

class Teacher(db.Model):

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

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

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

email = db.Column(db.String(120), unique=True, nullable=False)

class Course(db.Model):

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

course_name = db.Column(db.String(120), nullable=False)

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

credits = db.Column(db.Integer, nullable=False)

]]>

if __name__ == '__main__':

db.create_all()

alice = Teacher(name='Alice Smith', department='Engineering', email='alice.smith@example.com')

bob = Teacher(name='Bob Johnson', department='Engineering', email='bob.johnson@example.com')

db.session.add(alice)

db.session.add(bob)

db.session.commit()

print("Database initialized.")

]]>

from flask import jsonify

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

def get_teachers():

teachers = Teacher.query.all()

return jsonify([t.serialize for t in teachers])

]]>