如何使用sqlalchemy/python在sqlite中定义数据库触发器？

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('sqlite:///your_database.db')
Session = sessionmaker(bind=engine)
session = Session()
Base = declarative_base()

class YourModel(Base):
    __tablename__ = 'your_table'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    # 其他字段...

def your_trigger_function(target, connection, **kwargs):
    # 触发器逻辑...

event.listen(YourModel, 'after_insert', your_trigger_function)
event.listen(YourModel, 'after_update', your_trigger_function)
event.listen(YourModel, 'after_delete', your_trigger_function)

Base.metadata.create_all(engine)