On Feb 28, 12:30 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
> you have to show me what youre doing since from my understanding,
> youre using literal text, and nothing should get added to that.
Here is a quicky Test:
from sqlalchemy import *
e=create_engine('sqlite://memory')
ts=Table('ts',e,
Column ( 'id',Integer,primary_key=True),
Column ( 'dat',Integer,nullable=False))
ts.create()
sel=select( [ "case when id > 5 then 'ok' else 'tolow' end as
test" ] , from_obj=[ts], use_labels=True )
print str(sel)
___
And here is the output I get:
SELECT case when id > 5 then 'ok' else 'tolow' end as test AS
casewhenid5thenokelsetolowendastest
FROM t
Am I doing something wrong with the literal text block? Is there
another way to specify one besides simply passing in a string.
Thanks
Dennis
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
