SQLAlchemy -如何在提交前处理列？

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

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    age = Column(Integer)

def process_columns_before_commit(mapper, connection, target):
    # 在提交前处理列的逻辑
    target.name = target.name.upper()  # 将name列的值转换为大写

event.listen(User, 'before_insert', process_columns_before_commit)
event.listen(User, 'before_update', process_columns_before_commit)

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

# 创建一个User对象并添加到会话中
user = User(name='John', age=25)
session.add(user)

# 提交会话
session.commit()

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    age = Column(Integer)

    def __setattr__(self, name, value):
        if name == 'name':
            value = value.upper()  # 将name列的值转换为大写
        super().__setattr__(name, value)

# 创建数据库连接和会话，以及创建和提交会话的代码与上述示例相同