On Sep 24, 2007, at 11:15 AM, Berik Visschers wrote:
> The SQL query I'm trying to map is:
> SELECT id, begin_date, end_date,
> begin_date IS NOT NULL
> OR begin_date <= NOW()
> AND
> end_date IS NULL
> OR end_date > NOW() AS active
> FROM package WHERE active = 't'
>
more specifically youre looking for:
SELECT id, begin_date, end_date,
(begin_date IS NOT NULL
OR begin_date <= NOW()
AND
end_date IS NULL
OR end_date > NOW()) AS active
FROM package WHERE active = 't'
right ? I would think we can just add "label()" support to
ClauseList for this. you can open a trac ticket for this and
someone will get around to it, or if you want to try a patch (its
not hard one).
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
