从两个表连接的Flask SQLalchemy order_by值

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'your_database_uri'
db = SQLAlchemy(app)

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))

class Order(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    amount = db.Column(db.Float)

@app.route('/')
def index():
    # 连接两个表并按照订单金额降序排序
    orders = db.session.query(Order).join(User).order_by(Order.amount.desc()).all()
    # 处理结果...
    return 'Hello World'

if __name__ == '__main__':
    app.run()