学生信息管理系统

from flask import Flask, jsonify

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)

score = db.Column(db.Float, nullable=False)

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

def get_rank():

students = Student.query.order_by(Student.score.desc()).all()

return jsonify([{'name': s.name, 'score': s.score} for s in students])

if __name__ == '__main__':

app.run(debug=True)