On Wed, Jun 27, 2018 at 3:22 AM, arjun k <arjun...@gmail.com> wrote: > Hi > i was trying to convert the below query to sqlalchemy > > > SELECT > addr_idn, > (SELECT MAX(LastUpdateDate) > FROM (VALUES (crt_dt),(upd_dt),) AS UpdateDate(LastUpdateDate)) > AS LastUpdateDate > FROM ( > select a. addr_idn,a.crt_dt crt_dt , b.upd_dt upd_dt > from emp_addr > where emp_addr.addr_idn = 1 > ) a > > > > but i am not able to convert this into sqlalchemy. please help me out to > convert this query.
the hard part here is the "FROM VALUES" which is not built-in to SQLAlchemy. There is a recipe at https://bitbucket.org/zzzeek/sqlalchemy/wiki/UsageRecipes/PGValues that will show how to build a "values()" function that will give you the VALUES() expression you're looking for. > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.