On 28.4.2012, at 18:39, Michael Bayer wrote: > > On Apr 28, 2012, at 5:52 AM, Stefan Urbanek wrote: > >> This is what I used as workaround [1]: >> >> # select is sqlalchemy.sql.expression.select() >> # each selected column was derived as column = >> table.c[reference].label(label_with_dot) >> >> labels = [c.name for c in select.columns] >> ... >> record = dict(zip(labels, row)) >> > > please try out the patch at > http://www.sqlalchemy.org/trac/attachment/ticket/2475/2475.patch . This > would provide: > > > conn = engine.connect().execution_options({"sqlite_raw_colnames":True}) > result = conn.execute(stmt) > > no removal of dots would proceed. > > > if this works for you it can go right in to 0.7 and 0.8. >
Thanks, works nicely. (had to change to: execution_options(sqlite_raw_colnames=True)). Is there (going to be) a way how I would be able to pass this option to the engine, so I can have all connections like that? 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. Stefan Urbanek data analyst and data brewmaster Twitter: @Stiivi Home: http://stiivi.com Brewery: http://databrewery.org Github: https://github.com/Stiivi -- 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.
