[sqlalchemy] Ordering by related column's related column

2008-02-04 Thread Utku Altinkaya
Greetings, I have Users class with relation to Address which have relation to Cities, all are eager loaded. I want to sort the Users query with the name field of the cities table. But if I order by City.name the cities table is joined to the actual query. How can I explain it to use the

[sqlalchemy] Re: Ordering by related column's related column

2008-02-04 Thread Utku Altinkaya
On Feb 4, 8:13 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Feb 4, 2008, at 11:29 AM, Utku Altinkaya wrote: Greetings, I have Users class with relation to Address which have relation to Cities, all are eager loaded. I want to sort the Users query with the name field of the cities

[sqlalchemy] Re: Ordering by related column's related column

2008-02-04 Thread Utku Altinkaya
On Feb 4, 11:03 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Feb 4, 2008, at 3:46 PM, Utku Altinkaya wrote: I get it, the result with joins for eager loading has nothing to do with sorting. So I have to join them to base selected set to use. But I feel like selecting twice

[sqlalchemy] Re: Using ORM Object as an intermadiate holder

2007-12-17 Thread Utku Altinkaya
On 16 Aralık, 22:22, Michael Bayer [EMAIL PROTECTED] wrote: On Dec 15, 11:02 pm, Utku Altinkaya [EMAIL PROTECTED] wrote: I do not want to lose invalid values, becouse I want to send them to the user again, so while using object as intermediate holder I have to set attributes invalid

[sqlalchemy] Re: Using ORM Object as an intermadiate holder

2007-12-16 Thread Utku Altinkaya
of session. http://www.sqlalchemy.org/docs/04/session.html#unitofwork_using_refreshing Utku Altinkaya wrote: Hi, I am using SQLAlchemy on a web application, I have used a base class for ORM clases which provides soem web related things like validation and loading data from forms etc