from sqlalchemy import func #rows = session.query(Person).count() c.count = Session.query(func.count(Person.id)).scalar() c.avg = Session.query(func.avg(Person.id).label('average')).scalar() c.sum = Session.query(func.sum(Person.id).label('average')).scalar() c.max = Session.query(func.max(Person.id).label('average')).scalar()
Group by
c.coutg = Session.query(func.count(Person.id).label('count'), Person.name ).group_by(Person.name).all()
templet:
Group count <br> count g <table border="1"> % for a in c.coutg: <tr> <td>${ a.name } </td> <td> ${ a.count }</td> </tr> % endfor
Distinct
from sqlalchemy import distinct # count distinct "name" values session.query(func.count(distinct(User.name)))