用于返回子对象列表的SqlAlchemy ORM查询

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

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

# 创建基类
Base = declarative_base()

# 定义父表
class Parent(Base):
    __tablename__ = 'parent'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    children = relationship("Child")  # 定义与子表的关系

# 定义子表
class Child(Base):
    __tablename__ = 'child'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    parent_id = Column(Integer, ForeignKey('parent.id'))

# 查询父表及其子对象列表
parent = session.query(Parent).filter_by(id=1).first()
children = parent.children

# 打印结果
print(f"父对象：{parent.name}")
print("子对象列表：")
for child in children:
    print(child.name)