[sqlalchemy] StaleDataError with cascade and deleting bottom-up

2012-09-04 Thread Sebastian Elner
Hello, I am using SA 0.6.9 at the moment and get a StaleDataError if I run the code attached. In 0.7 it works without error. I wanted to understand what’s changed and have browsed Trac and the migration guide, but only came across similar looking issues (like

[sqlalchemy] help with hierarchy

2012-07-10 Thread Sebastian Elner
Hello, I need some hints on how to build a query on a data structure which turned out to be a hierarchy. Please find the picture of the EER diagram attached. I want to get all note entities for a given project with their corresponding project, shots and assets. Something like: (project1,

Re: [sqlalchemy] logging - get source line

2012-06-29 Thread Sebastian Elner
the appropriate number of steps before reporting the source line. On Jun 28, 2012, at 1:32 PM, Sebastian Elner wrote: Hello, I have an app here, which issues quite a number of sql statements. I would like to track down where in the code the sql is issued. Setting echo to True does not give

[sqlalchemy] logging - get source line

2012-06-28 Thread Sebastian Elner
Hello, I have an app here, which issues quite a number of sql statements. I would like to track down where in the code the sql is issued. Setting echo to True does not give the .py file and line number, so I setup my own logger as described in the docs: import logging logging.basicConfig()