On Jan 8, 2008, at 5:05 PM, Jonathan LaCour wrote:
>
> Michael Bayer wrote:
>
>> unfortunately it requires a bugfix, r4031:
>>
>> s = select([(func.max(task.c.sequence)
>> +100).label('value')]).union(select([literal(100.0).label('value')]))
>> print select([func.max(s.c.value)])
>
> Thanks Mike. My unit test now gets past the SQL generation, but
> still fails. It appears that the SQL gets generated and run, but
> the value doesn't show up in the database as expected.
>
> Note: I am using this SQL expression as part of an insert by setting
> it directly on my mapped object:
>
> task = Task()
> task.sequence = <crazy sql expression>
> session.save(task)
>
> Might this have something to do with it?
>
sure...what do your SQL logs say ?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
