使用SQLAlchemy对象模型根据多对一关系中的一个对象过滤查询

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)

# 创建基类和对象模型
Base = declarative_base()

class Parent(Base):
    __tablename__ = 'parents'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    children = relationship('Child')

class Child(Base):
    __tablename__ = 'children'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    parent_id = Column(Integer, ForeignKey('parents.id'))

# 进行查询操作
session = Session()

# 根据Parent对象的name属性进行过滤查询
parents = session.query(Parent).filter_by(name='某个名字').all()

# 输出查询结果
for parent in parents:
    print(parent.name)
    for child in parent.children:
        print(child.name)

# 关闭会话
session.close()