[sqlalchemy] Re: Append AND NULL condition on joins

2015-06-19 Thread david . ceresuela
After some testing, I have found where the trouble lies. In the orm/util file there is this code around line 836: if not prop and getattr(right_info, 'mapper', None) \ and right_info.mapper.single: # if single inheritance target and we are using a manual # or implicit ON clause, a

[sqlalchemy] Append AND NULL condition on joins

2015-06-17 Thread david . ceresuela
Hi all, I was giving SQLAlchemy 1.0 series a try but I have found some problems along the way. There are some queries that in the 0.9.9 version used to work, but they do not work as expected anymore. An example of one of those is: feeds = DBSession.query(Feed, Client, ClientPro).outerjoin( C

Re: [sqlalchemy] Polymorphic joined-table inheritance

2014-01-13 Thread david . ceresuela
@Kevin Horn: I removed the __init__ methods and the problem did not get solved, but thank you very much for your suggestion. @Michael Bayer: I run your test in my environment and it behaved as expected (no WHERE clause), so maybe it is not SQLAlchemy's problem but Pyramid's (or some other thing

[sqlalchemy] Polymorphic joined-table inheritance

2014-01-10 Thread david . ceresuela
Hello all, I'm trying to use SQLAlchemy inheritance in a (company's) project and I cannot seem to make it work. First, the versions: - Ubuntu: 12.10 - Python: 2.7.3 - SQLAlchemy: 0.9.1 - PostgreSQL: 9.1 - sqlite: 3.7.13 - Pyramid: 1.4.2 All of the problems happen in both PostgreSQL and sqlite.