如何根据模型的自定义附加关系进行排序

from sqlalchemy import Column, Integer, Float, ForeignKey
from sqlalchemy.orm import relationship
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class Product(Base):
    __tablename__ = 'products'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    price = Column(Float)
    sales = Column(Integer)  # 销量
    rating = Column(Float)   # 评分

    # 假设还有其他关联模型...

from sqlalchemy import desc

def get_sorted_products(session):
    # 先按销量降序排序，销量相同的再按评分降序排序
    sorted_products = session.query(Product).order_by(desc(Product.sales), desc(Product.rating)).all()
    return sorted_products

# 假设已经有了一个SQLAlchemy的session对象
products = get_sorted_products(session)
for product in products:
    print(f"{product.name} - 销量: {product.sales}, 评分: {product.rating}")