SqlAchemy products表使用sum连接到stock表

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

engine = create_engine('数据库连接字符串')
Session = sessionmaker(bind=engine)
session = Session()

Base = declarative_base()

class Product(Base):
    __tablename__ = 'products'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    price = Column(Integer)
    stock_id = Column(Integer, ForeignKey('stock.id'))
    stock = relationship("Stock", back_populates="products")

class Stock(Base):
    __tablename__ = 'stock'
    id = Column(Integer, primary_key=True)
    quantity = Column(Integer)
    products = relationship("Product", back_populates="stock")

result = session.query(Product.name, func.sum(Stock.quantity)).join(Stock).group_by(Product.name).all()

for name, total_quantity in result:
    print(f"产品名称：{name}，总库存数量：{total_quantity}")