Re: [sqlalchemy] Conflicting relationships in class hierarchy

2017-09-15 Thread Julio César Gázquez
El 11/09/17 a las 14:52, Mike Bayer escribió: > Please provide all mappings including the missing "Prestacion" class > as well as exact information on which classes have their own tables or > not.The code should be a mappings I can paste into a .py file and > run to see the error you are

[sqlalchemy] Conflicting relationships in class hierarchy

2017-09-11 Thread Julio César Gázquez
Hi list. I guess I messed it. I built an app on the premise I can build two different relationships relying on the same field. My data model is basically as below. Class names are roughly translated from Spanish. Please read comments in Charge subclasses to grasp the problem. class

Re: [sqlalchemy] SQLAlchemy and PyQT5

2017-06-06 Thread Julio César Gázquez
Hi Wayne. El 02/06/17 a las 06:43, Wayne escribió: Hi, Does anyone have any experience, links to open source code or anything else that shows the integration of PyQT5 with SQLAlchemy? I'm using SQLAlchemy with PyQt4. My experience is valid for PyQt5 using QtWidgets module, QtQuick is a

[sqlalchemy] Deleting detached objects

2016-12-28 Thread Julio César Gázquez
Hi list. I just noticed that if I retrieve an object, and close the session letting the object in detached state, then I can delete the object from the database using a new session simply issuing session.delete(), without merging it first. SQL Alchemy simply emits the DELETE and that's it,

Re: [sqlalchemy] select_from() and single table inheritance

2015-03-19 Thread Julio César Gázquez
El 19/03/15 a las 10:34, Michael Bayer escribió: While the select_from() still does correctly the A/B join, the filtering condition is missing, so select_from(C) becomes the same as select_from(B). did you try 1.0.0b1 for this? The mechanics for single-table have been improved in this

[sqlalchemy] select_from() and single table inheritance

2015-03-19 Thread Julio César Gázquez
Hi. I have an inheritance hierarchy on the form, C inherits B (with single table inheritance), B inherits A (with joined table inheritance). The next query works perfectly: session.query(C)\ .join(C.related_objects) .filter( ... ) # Unrelated filtering conditions as the resulting

[sqlalchemy] How to not losing changes on rollback?

2013-09-25 Thread Julio César Gázquez
Hi. I'd like to know what's the recommended approach to keep the state of the session and the associated objects when session.flush() fails, in order to being able to fix the cause of the problem and retry the operation. For cases with a single object hierarchy, I think using session.merge()