On Apr 23, 2008, at 9:24 AM, Adrian wrote:
>
> I should have mentioned that - cutoff is simply a float, e.g.
>
> query = query.where(query.c.brayCurtis >= 0.8)
>
> that's why I think there is a trivial solution. If I do the above, the
> whole query will be added as a subquery and the where and order by
> clauses duplicated. It works fine for the order_by statement though.
If you want to force the label substitution, you can do it like this:
where(literal_column('mylabelname') >= 0.8)
or instead of pulling the label off the select itself, use the
original label construct, which is not the same as stmt.c.labelname -
this will repeat the expression, which is what many DBs will require,
but because its not attached to a selectable (unlike
stmt.c.labelname), will not pollute the FROM clause of the select
(select() pulls FROM clauses from everything in the columns and where
clauses):
col = abs(foo - bar).sum() / float(...).label('somelabel')
s = select([..., col, ...]).where(col > 0.8)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
