Re: [sqlalchemy] Trouble with AbstractConcreteBase and aliased columns

2015-07-09 Thread Alex Grönholm
Thanks for the response! The solution looks too hairy for my tastes, and I can manage with what I currently have. Good to know it's possible though! 10.07.2015, 02:25, Mike Bayer kirjoitti: On 7/9/15 12:17 PM, Alex Grönholm wrote: Thanks. What about my other question? Is it possible to have t

Re: [sqlalchemy] Trouble with AbstractConcreteBase and aliased columns

2015-07-09 Thread Mike Bayer
On 7/9/15 12:17 PM, Alex Grönholm wrote: Thanks. What about my other question? Is it possible to have two layers of classes (Document and ContactDocument) mapped to polymorphic unions? OK. So, AbstractConcreteBase struggles hard against Declarative wanting to map things. So as far as how

Re: [sqlalchemy] Trouble with AbstractConcreteBase and aliased columns

2015-07-09 Thread Alex Grönholm
Thanks. What about my other question? Is it possible to have two layers of classes (Document and ContactDocument) mapped to polymorphic unions? torstai 9. heinäkuuta 2015 18.31.36 UTC+3 Michael Bayer kirjoitti: > > Thanks for reporting. Issue > https://bitbucket.org/zzzeek/sqlalchemy/issues/3

Re: [sqlalchemy] Using Postgres Composite Types

2015-07-09 Thread Mike Bayer
On 7/8/15 9:25 PM, Vincent Catalano wrote: I've been trying to get SQLAlchemy to work with Postgres composite types for the last couple days with no luck. I've implemented the PGCompositeType that Michael created in another post (https://groups.google.com/forum/#!searchin/sqlalchemy/postgres$

[sqlalchemy] What means this 'Decimal()'?

2015-07-09 Thread c.buhtz
X-Post on stackoverflow: I use SQLAlchemy with Python3 and sqlite3. I tried to `add()` and new object into a sqlite database and got this error message. sqlalchemy.exc.InterfaceError: (sqlite3.InterfaceError) Error binding parameter 3 - probably

Re: [sqlalchemy] Trouble with AbstractConcreteBase and aliased columns

2015-07-09 Thread Mike Bayer
Thanks for reporting. Issue https://bitbucket.org/zzzeek/sqlalchemy/issues/3480/abstractconcretebase-regression-with is created, create the Column objects with an explicit key for now: class Document(object): date = Column(Date) documentType = Column('documenttype', String, key="docu

[sqlalchemy] Trouble with AbstractConcreteBase and aliased columns

2015-07-09 Thread Alex Grönholm
The following script no longer works in 1.0.6, but does in 0.9.9: from sqlalchemy.ext.declarative import declarative_base, AbstractConcreteBase from sqlalchemy.ext.declarative.api import declared_attr from sqlalchemy.orm.mapper import configure_mappers from sqlalchemy.orm.session import Session f

[sqlalchemy] Expanded view of query parameters

2015-07-09 Thread Horcle
Dear all, How can I expand the output to show ALL query parameters. For example, I have the following: 2015-07-09 09:51:09,478 INFO sqlalchemy.engine.base.Engine (['test_code'], ['13457-7'], ['result_value_num'], '160', '160', ['1970-01-01'], ['blood_pressure'], ['blood_pressure'] ... displayi