Hi everyone, I'm using sqlalchemy 0.7.8 with sqlite and I'm encountering a
problem trying to retrieve data from a table having a column named
"input"_1. If I run this simple code:
from sqlalchemy import *
db = create_engine('sqlite:///test.db')
db.echo = False
metadata = MetaData(db)
t = Table('my_table', metadata, autoload=True)
print t.select().execute()
i get the following error:
OperationalError: (OperationalError) no such column: my_table.input"_1
u'SELECT my_table.id, my_table.input"_1 FROM my_table'. It seems that the
first double quotes are truncated by the query function. Of course I can
arrange things such that no double quotes are present in column names, but
I would like to know if SA can somehow handle this situation automatically
and in a platform-independent way.
Thanks in advance for your help!
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sqlalchemy/-/FtTj3V7BtcYJ.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
