[sqlalchemy] unexpected chained relations and append behaviour

2009-09-23 Thread Crusty
Hello everyone, I have a realy simple model for you to consider: 1 car has n wheels car.wheels is a relation from cars to wheels wheel.car is a backref to cars 1 car has n parts car.parts is a relation from car to parts I just wondered why my app was really getting slow, turned on SA debug

[sqlalchemy] Re: do I need subqueries for this?

2009-09-16 Thread Crusty
. Greetings, Tom On Tue, Sep 15, 2009 at 5:30 PM, Conor conor.edward.da...@gmail.com wrote: On Sep 15, 5:38 am, Crusty crust...@gmail.com wrote: Hey everyone, sorry for the title, I couldnt think of any way to describe this in short. I have 3 Classes, which have basically this relationship

[sqlalchemy] do I need subqueries for this?

2009-09-15 Thread Crusty
Hey everyone, sorry for the title, I couldnt think of any way to describe this in short. I have 3 Classes, which have basically this relationship: 1 Class1 has n Class2 ( 1:n) 1 Class2 has n Class3 ( 1:n) So basically it looks like this: Class1 |-- Class2 |-- Class3 Now if I