从pandas dataframe列更新slqalchemy orm列的正确方法是什么

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

engine = create_engine('数据库连接字符串')
Session = sessionmaker(bind=engine)
session = Session()
Base = declarative_base()

class MyTable(Base):
    __tablename__ = 'my_table'
    id = Column(Integer, primary_key=True)
    column1 = Column(String)
    column2 = Column(String)
    # 定义其他列...

# 创建表格
Base.metadata.create_all(engine)

query = session.query(MyTable).filter(MyTable.id == 1)
result = query.first()

result.column1 = dataframe['column1']
result.column2 = dataframe['column2']
# 更新其他列...

session.commit()