ok;
see mapper.py line 1134, calling after_update with state instead of state.obj()
Michael Bayer wrote:
>
> On Dec 16, 2007, at 2:40 AM, [EMAIL PROTECTED] wrote:
>
>> from sqlalchemy import *
>> m= MetaData()
>> trans =Table( 'trans', m, Column( 'date', Date), )
>> balance=Table( 'balance', m, Column( 'finaldate', Date), )
>>
>> b = balance.alias('b')
>> sprev = select( [ func.max( b.c.finaldate)],
>> b.c.finaldate < balance.c.finaldate
>> )
>> #correlate is non-generative in 0.3 (ret None) but generative in 0.4
>> sprev = sprev.correlate( balance) or sprev
>>
>> r = trans.c.date > func.coalesce( sprev,0 )
>> #, as_scalar=True ) with or without all the same
>
>
> r = trans.c.date > func.coalesce( sprev.as_scalar(),0 )
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
