SQL Alchemy Samples

sql_alchemy_samples.py

########## CASE IN UPDATE STATEMENT ############

from sqlalchemy import case

# single value modification (the 'else' is not mandatory)
session.query(User).update({User.status : case([(User.status == "pending", "approved")], else_=User.status)}, False)

# multiple values modification
session.query(User).update({User.status : case([(User.status == "pending", "approved"),
                                                (User.status == "waiting", "deprecated_status")])}, False)
                                                
########## CONCAT ############

from sqlalchemy.sql.functions import concat

session.query(User).update({ User.department: concat(PREFIX, User.department, SUFFIX)}, False)

########## CAST ############

from sqlalchemy.sql.expression import cast
import sqlalchemy

session.query(User).update({User.name: cast(User.user_id, sqlalchemy.String)}, False)

Thanks for posting useful examples!

Thanks a lot