On Wed 03 Sep 2008 03:33:23 PM EDT, Oleg Broytmann wrote:
> On Wed, Sep 03, 2008 at 01:43:54PM +0000, Matthew Wilson wrote:
>> I want to do a select like this with SQLObject:
>> select * from people
>> where date_part('day', createddate) = date '2008-09-01';
>> That query should choose people created any time on September 1st.
>> In SQLObject, this is what I'm doing:
>> People.select("date_part('day', createddate) = date '2008-09-01'")
>> Is there some way to avoid using a string of raw SQL?
> Something like
> from sqlobject.sqbuilder import func
> People.select(func.date_part('day', createddate) == '2008-09-01')
> 'func' is a pretty simple object whose attributes are passed unchanged
> (unquoted, unescaped) to SQL.
Oleg -- thanks so much for the help. You're a fantastic benefit to the