Hello,
I have this query:
rsvp = session.query(Project.project,
func.count(Reservation.project_id)).join(Reservation.project).group_by(Project.project,
Project.id).order_by(Project.project)
>>> print rsvp
SELECT project.project AS project_project, count(reservation.project_id)
AS count_1
FROM reservation JOIN project ON project.id = reservation.project_id
GROUP BY project.project, project.id ORDER BY project.project
So far so good - but what if I want to order by column
"func.count(Reservation.project_id)"?
I can do this in SQL all right:
SELECT project.project AS project_project, count(reservation.project_id)
AS count_1
FROM reservation JOIN project ON project.id = reservation.project_id
GROUP BY project.project, project.id ORDER BY count_1 DESC
But how to do this in above sqla query?
--
Regards,
mk
--
Premature optimization is the root of all fun.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.