adminView.py 文件源码

def getScore(username=None):
    counts = db.session.query(User.name, func.sum(DailyCompletion.score).label("score")).join(
        User.points).group_by(User.name).order_by(func.sum(DailyCompletion.score).desc())
    if username:
        counts = counts.filter(User.slackHandle == username)

    if not counts.count():
        return None
    elif username:
        return counts.first()
    else:
        return counts.all()