SQLAlchemy监听多对多关系中的属性更改并更改发起方的其他属性

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

# 创建数据库引擎和会话
engine = create_engine('数据库连接字符串')
Session = sessionmaker(bind=engine)
session = Session()

# 创建中间表
association_table = Table('association', Base.metadata,
    Column('student_id', Integer, ForeignKey('students.id')),
    Column('course_id', Integer, ForeignKey('courses.id'))
)

# 定义学生和课程模型
class Student(Base):
    __tablename__ = 'students'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    courses = relationship('Course', secondary=association_table, back_populates='students')

class Course(Base):
    __tablename__ = 'courses'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    students = relationship('Student', secondary=association_table, back_populates='courses')

# 监听多对多关系中的属性更改事件
@listens_for(Student.courses, 'append')
def on_courses_append(target, value, initiator):
    # 在学生选择课程时，更新学生的其他属性
    target.name = 'Updated Name'

# 测试代码
student = session.query(Student).first()
course = session.query(Course).first()
student.courses.append(course)
session.commit()