model.py 文件源码

def get_recordcnts_by_classification():
        q = db.session.query(Classification.classification, db.func.count(Record.id).label('total'))
        q = q.join(Record.classification)
        q = q.group_by(Classification.classification)
        q = q.order_by(desc('total'))
        return q.all()