如何在函数内部强制提交，以便其他会话可以看到更新的行？

BEGIN;

-- 执行更新操作
UPDATE table_name SET column1 = value1 WHERE condition;

COMMIT;

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;

BEGIN;

-- 执行更新操作
UPDATE table_name SET column1 = value1 WHERE condition;

COMMIT;

BEGIN;

-- 执行更新操作
UPDATE table_name SET column1 = value1 WHERE condition;

COMMIT;

from sqlalchemy import create_engine, text

engine = create_engine('your_database_connection_string')

def update_data():
    with engine.connect() as connection:
        try:
            # 开始事务
            connection.begin()
            
            # 执行更新操作
            update_stmt = text("UPDATE table_name SET column1 = :value1 WHERE condition")
            connection.execute(update_stmt, value1='new_value')
            
            # 提交事务
            connection.commit()
        except Exception as e:
            # 发生错误时回滚事务
            connection.rollback()
            raise e

update_data()