[sqlalchemy] SQLAlchemy cant convert boolean to int with mysql

2013-10-25 Thread Gustavo Gawryszewski
I've got an error while trying to retrieve boolean items from mysql. as stated in http://stackoverflow.com/questions/19591801/sqlalchemy-cant-convert-boolean-to-int-with-mysql but when I've installed without the C Extensions everything worked fine. Is that a bug? -- You received this

Re: [sqlalchemy] SQLAlchemy cant convert boolean to int with mysql

2013-10-25 Thread Michael Bayer
On Oct 25, 2013, at 12:59 PM, Gustavo Gawryszewski gustavoga...@gmail.com wrote: I've got an error while trying to retrieve boolean items from mysql. as stated in http://stackoverflow.com/questions/19591801/sqlalchemy-cant-convert-boolean-to-int-with-mysql but when I've installed

Re: [sqlalchemy] dynamically mapped tables with ORM

2013-10-25 Thread Tim Pierson
Hi everyone, I'm new to SQLSoup and only have a little sqlalchemy experience and I'm wondering if anyone can give me some direction on how to use the subclassed sqlsoup object outlined in previous posts. I also have more than a few talbes with no primary keys that I need dynamically mapped

Re: [sqlalchemy] dynamically mapped tables with ORM

2013-10-25 Thread Michael Bayer
that answer is a little overkill, you can share the tables already reflected in a MetaData with a SQLSoup object like this: from sqlalchemy import create_engine # table with no PK e = create_engine(sqlite://, echo=True) e.execute( create table no_pk( id integer, data

Re: [sqlalchemy] dynamically mapped tables with ORM

2013-10-25 Thread Tim Pierson
Sweet, Thanks! On Friday, October 25, 2013 3:56:59 PM UTC-4, Michael Bayer wrote: that answer is a little overkill, you can share the tables already reflected in a MetaData with a SQLSoup object like this: from sqlalchemy import create_engine # table with no PK e =

[sqlalchemy] Resolving oracle synonyms with reflection

2013-10-25 Thread Kyle Derr
I have a few questions regarding using reflection with synonyms. At my company, we use sqlalchemy as the foundation of a tool that extracts data from our clients' oracle database installations. One of our clients seems to be using synonyms to implement a permissions scheme. That is, for all

Re: [sqlalchemy] Resolving oracle synonyms with reflection

2013-10-25 Thread Michael Bayer
On Oct 25, 2013, at 5:53 PM, Kyle Derr kyle.d...@gmail.com wrote: diff --git a/lib/sqlalchemy/dialects/oracle/base.py b/lib/sqlalchemy/dialects/oracle/base.py index 54c254c..209db66 100644 --- a/lib/sqlalchemy/dialects/oracle/base.py +++ b/lib/sqlalchemy/dialects/oracle/base.py @@