Skip to content

Instantly share code, notes, and snippets.

@carlosmontoya89

carlosmontoya89/sql_alchemy_samples.py

Forked from olgakogan/sql_alchemy_samples.py
Created July 9, 2020 18:47
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save carlosmontoya89/1e04d13f71fbdd3021418fc26c196774 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save carlosmontoya89/1e04d13f71fbdd3021418fc26c196774 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Alchemy Samples
Raw
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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment