thats a behavior there for the purposes of SQLite that's been removed and made specific to the SQLite dialect in 0.7.
On Mar 2, 2011, at 6:18 PM, Stefan Urbanek wrote: > Hi, > > I have a table with column names that contain dots, like > "category.name" or "category.desc". When I do: > > stmt = table.select(whereclause = condition) > cursor = connection.execute(stmt) > print cursor.keys() > > I will get just [ ... "name", "desc" ....] - nothing before the dot > '.'. > > When I try: > > row = cursor.fetchone() > for (key, value) in row.items(): > ... > > It fails with an exception on the 'for' statement, that there are > duplicate column names - like "name" or "desc". There are not > duplicates, because they are called "something.name" and > "otherthing.name". > > Is there any option to be passed to the select() to return full column > names? > > Regards, > > Stefan > > -- > 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. > -- 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.
