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?
--
Jonathan LaCour
http://cleverdevil.org
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
