models.py 文件源码

def get_graded_count(exercise_id):
    query = db.session.query(Response.id,
                             func.count(func.coalesce(ResponseGrade.id, None))) \
        .outerjoin(ResponseGrade) \
        .filter(Response.exercise_id == exercise_id) \
        .group_by(Response.id) \
        .order_by(Response.id)

    return query.all()