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 TableA(Base):
    __tablename__ = 'table_a'
    id = Column(Integer, primary_key=True)
    name = Column(String)

class TableB(Base):
    __tablename__ = 'table_b'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    table_a_id = Column(Integer, ForeignKey('table_a.id'))
    table_a = relationship("TableA")

# 创建会话
session = Session()

# 查询不在TableB中的TableA记录
result = session.query(TableA).filter(TableA.id.notin_(session.query(TableB.table_a_id))).all()

# 打印结果
for row in result:
    print(row.id, row.name)