sqlalchemy触发器在不同表上的delete之后自动插入

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

# 创建数据库引擎和会话
engine = create_engine('mysql+pymysql://username:password@host:port/database')
Session = sessionmaker(bind=engine)
session = Session()

# 创建基类
Base = declarative_base()

# 定义表模型
class Table1(Base):
    __tablename__ = 'table1'
    id = Column(Integer, primary_key=True)
    name = Column(String(255))

class Table2(Base):
    __tablename__ = 'table2'
    id = Column(Integer, primary_key=True)
    name = Column(String(255))

# 定义事件监听器
@event.listens_for(Table1, 'after_delete')
def insert_data(mapper, connection, target):
    # 在delete操作之后自动插入数据到Table2
    data = Table2(name=target.name)
    session.add(data)
    session.commit()

# 删除Table1中的数据
table1_data = session.query(Table1).filter(Table1.id == 1).first()
session.delete(table1_data)
session.commit()