Gregg Lind wrote:
> session.query(Route.ts,Route.startpoint,Route.target,func.max(Route.hop_id).label('max_hop'))\
> .group_by(Route.ts,Route.startpoint,Route.target).subquery()
> q =
> session.query(Route,sq.c.max_hop).join(sq,sq.c.max_hop==Route.hop_id)
> q.all()
join takes tuples in this form:
join((sq,sq.c.max_hop==Route.hop_id))
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
