Best way to order by columns in relationships?
- by Timmy
im using sqlalchemy, and i have a few polymorphic tables, and i want to sort by a column in one of the relationship.
i have tables a,b,c,d, with relationship a to b, b to c, c to d.
a to b is one-to-many
b to c and c to d are one-to-one, but polymorphic.
given an item in table a, i will have a list of items b, c, d (all one to one). how do i use sqlalchemy to sort them by a column in table d?