使用sqlalchemy从PostgreSQL DB上的列更新单个值

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

engine = create_engine('postgresql://username:password@host:port/database')

Session = sessionmaker(bind=engine)
session = Session()

Base = declarative_base()

class YourTable(Base):
    __tablename__ = 'your_table_name'
    id = Column(Integer, primary_key=True)
    column_name = Column(String)
    # 其他列...

session.query(YourTable).filter(YourTable.id == your_id).update({YourTable.column_name: new_value})
session.commit()