sqlalchemy group by

Re: [sqlalchemy] Simple example of a GROUP BY

Lance Edgar
Mon, 05 Jul 2010 21:24:08 -0700

On 7/5/2010 10:55 PM, Andrew Bialecki wrote:

I've looked for a while, but I can't find the *best* way to use the
ORM to generate the following query:

SELECT user_id, count(*) cnt
FROM orders
GROUP BY user_id

I have classes that represent both User and Order.  So what should go
after:

Order.query.[fill this in]

Sorry this is such an easy question, feel free to forward me to an
example, I just couldn't find one.

I think the following might work?


from sqlalchemy import func

session.query(Order.user_id,  func.count(Order.user_id)).group_by(Order.user_id)

Anyway a little more is to be found here:

 http://www.sqlalchemy.org/docs/ormtutorial.html#counting 
 http://www.sqlalchemy.org/docs/reference/orm/query.html#sqlalchemy.orm.query.Query.group_by 

Lance

--
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 .

[sqlalchemy] Simple example of a GROUP BY   Andrew Bialecki

Re: [sqlalchemy] Simple example of a GROUP BY   Lance Edgar

Reply via email to

查看更多关于sqlalchemy group by的详细内容...

声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://haodehen.cn/did43780