[sqlalchemy] Re: Data Inheritance

2008-07-21 Thread laureano arcanio
Yeah thats kind of what I'm trying to do, i think it would help me a little. Thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com

[sqlalchemy] Re: Data Inheritance

2008-07-17 Thread laureano arcanio
Thanks Michael. I might not explain it well, but I've traying to make some kind of data ( rows ) inheritance, this is copying a table value and all it's related childrens, and modify it as necesary with new values in an automated way. ( not inherit Table structures ) It's looks weird i think,

[sqlalchemy] Data Inheritance

2008-07-16 Thread laureano arcanio
Hi, I'm planning to implement Data inheritance for an os project i'm working on [1]. I have a model with a few tables and relationships between them ( not a complicated stuff ) and i was wandering if there is a way to accomplish data inheritance in an automated way ( i can eventually make a script

[sqlalchemy] Order_by

2008-06-30 Thread laureano arcanio
Hi guys, I'm new to this list but I I'm using SA from a while ago. I'm wondering how to sort a query based on a child table attribute. Table A- Many to One - Table B. I need to make a query in A, then order those records by a property of B. query = session.query(A).order_by( B.something )

[sqlalchemy] Re: Order_by

2008-06-30 Thread laureano arcanio
I found the solution using Joins. Thanks anyways. This is it: query = session.query(A).select_from(join(A, B)).order_by(B.some_attr) cheers --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post