如何在控制器中使用多个排序顺序

SELECT * FROM products
ORDER BY price ASC, rating DESC;

from sqlalchemy import create_engine, Column, Integer, String, Float
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

Base = declarative_base()

class Product(Base):
    __tablename__ = 'products'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    price = Column(Float)
    rating = Column(Float)

engine = create_engine('sqlite:///example.db')
Session = sessionmaker(bind=engine)
session = Session()

# 多列排序
products = session.query(Product).order_by(Product.price.asc(), Product.rating.desc()).all()

for product in products:
    print(f'{product.name} - ${product.price} - Rating: {product.rating}')