SQL Alchemy根据rest api中的可选字段更新行

from sqlalchemy import create_engine

engine = create_engine('mysql://username:password@localhost/db_name')

from sqlalchemy import Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'

    id = Column(Integer, primary_key=True)
    name = Column(String)
    age = Column(Integer)
    email = Column(String)

from sqlalchemy.orm import sessionmaker

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

# 查询数据
user = session.query(User).filter_by(id=1).first()

# 更新数据
if 'name' in optional_fields:
    user.name = optional_fields['name']
if 'age' in optional_fields:
    user.age = optional_fields['age']
if 'email' in optional_fields:
    user.email = optional_fields['email']

# 提交事务
session.commit()