On Fri, Jan 29, 2016 at 08:51:36AM -0800, Sergei Iakhnin wrote:
> Hi,
>
> Suppose I have a table Blah(colA int, colB int) and I am using
> session.query() to query its rows.
>
> my_results = session.query(Blah.xxx.label("my_result").first() I want to be
> able to have a python flag such that, depending on its value colA or colB
> gets selected as the result column. Please help me replace xxx in the query
> above to achieve this.
>
> In this toy example I could just copy the query inside an if statement, but
> the actual query I'm trying to build is large and I don't want to duplicate
> it.
Hi Sergei,
Perhaps you're looking for something like the following::
if some_condition:
query_column = Blah.colA
else:
query_column = Blah.colB
my_result = session.query(query_column.label("my_result")).first()
Cheers,
Michal
>
> Thanks in advance,
>
> Sergei.
--
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.
signature.asc
Description: Digital signature
