python实现sqlalchemy多表联合查询
session = Session()
bps: list[BusinessProduct] = (
session.execute(
select(BusinessProduct)
.join(Product, BusinessProduct.product_id == Product.id)
.join(
BusinessProductCategory,
BusinessProduct.business_product_category_id
== BusinessProductCategory.id,
)
.join(Shop, Product.shop_uid == Shop.shop_uid)
.where(*conditions)
.order_by(BusinessProduct.display_order)
.offset((page - 1) * page_size)
.limit(page_size)
)
.scalars()
.all()
)