开发者

Database-Independent MAX() Function in SQLAlchemy

I'd like to calculate a MAX() value for a column. What's the proper way to do this in sqlalchemy开发者_运维知识库 while preserving database independence?


You can find aggregate functions in:

from sqlalchemy import func 
func.avg(...) 
func.sum(...) 
func.max(...) 

In 0.5 you can use an ORM query like a select:

session.query(func.max(Table.column)) 
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜