如何获取sqlalchemy中受影响的行数？

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

# 创建数据库引擎
engine = create_engine('sqlite:///example.db')

# 创建会话
Session = sessionmaker(bind=engine)
session = Session()

# 定义一个模型
class User(object):
    def __init__(self, id, name):
        self.id = id
        self.name = name

# 更新操作
update_query = "UPDATE users SET name = 'new_name' WHERE id = 1"
result = session.execute(update_query)

# 获取受影响的行数
affected_rows = result.rowcount
print(f"受影响的行数：{affected_rows}")

# 提交事务
session.commit()

# 关闭会话
session.close()