from flask import Flask, jsonify, request

from sqlalchemy import create_engine, Column, Integer, String, ForeignKey

from sqlalchemy.ext.declarative import declarative_base

from sqlalchemy.orm import sessionmaker

app = Flask(__name__)

engine = create_engine('sqlite:///university.db')

Base = declarative_base()

class Student(Base):

__tablename__ = 'student'

id = Column(Integer, primary_key=True)

name = Column(String)

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

def get_grades(student_id):

Session = sessionmaker(bind=engine)

session = Session()

grades = session.query(Student).filter_by(id=student_id).first().grades

return jsonify(grades)

if __name__ == '__main__':

Base.metadata.create_all(engine)

SSO统一登录平台

app.run(debug=True)

]]>