thanx alot
it works
On Sep 21, 2:05 am, Michael Bayer <[EMAIL PROTECTED]> wrote:
> On Sep 20, 2008, at 7:59 AM, m.talaee wrote:
>
>
>
> > hi all
> > i need to sort users by number of theirfriends.
> > there is many to many relation table between user table and itself.
> > order_by don't support ordering (or i couldn't find).
> > please help me
>
> for a mapping like:
>
> mapper(User, users, properties={
> 'friends':relation(User, secondary=user_friends, primaryjoin=....,
> secondaryjoin=...)
>
> })
>
> you can say:
>
> subq =
> select
> ([func
> .count
> (user_friends
> .c.friend_id).label('friendcount')]).group_by(user_friends.c.user_id)
>
> sess.query(User).select_from(users.join(subq,
> users.c.user_id==subq.c.user_id)).order_by(subq.c.friendcount)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
