基于另一个表中的值的简单SQLAlchemy更新表

from sqlalchemy import create_engine, update, select
from sqlalchemy.orm import sessionmaker

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

# 定义目标表和源表的映射类
class TargetTable(Base):
    __tablename__ = 'target_table'
    id = Column(Integer, primary_key=True)
    value = Column(Integer)

class SourceTable(Base):
    __tablename__ = 'source_table'
    id = Column(Integer, primary_key=True)
    value = Column(Integer)

# 创建更新语句
stmt = update(TargetTable).\
    values(value=select([SourceTable.value]).where(SourceTable.id == TargetTable.id))

# 执行更新操作
session.execute(stmt)

# 提交事务
session.commit()