SQLAlchemy删除多对多行

from sqlalchemy import create_engine, Table, Column, Integer, 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()

association_table = Table('关系表名称', Base.metadata,
    Column('左侧外键列名称', Integer, ForeignKey('左侧表名称.主键列名称')),
    Column('右侧外键列名称', Integer, ForeignKey('右侧表名称.主键列名称'))
)

class LeftTable(Base):
    __tablename__ = '左侧表名称'
    id = Column(Integer, primary_key=True)
    right_tables = relationship('RightTable', secondary=association_table, back_populates='left_tables')

class RightTable(Base):
    __tablename__ = '右侧表名称'
    id = Column(Integer, primary_key=True)
    left_tables = relationship('LeftTable', secondary=association_table, back_populates='right_tables')

left_table_id = 1  # 要删除的左侧表的ID
right_table_id = 2  # 要删除的右侧表的ID

left_table = session.query(LeftTable).get(left_table_id)
right_table = session.query(RightTable).get(right_table_id)

left_table.right_tables.remove(right_table)
session.commit()