def user_all_class_assignment_performance(user_id): """Summary Args: user_id (TYPE): Description Returns: TYPE: Description """ problem_logs = db.problem_logs class_assignments = db.with_labels(db.class_assignments) join = db.join( class_assignments, problem_logs, problem_logs.assignment_id == class_assignments.class_assignments_id ) correct = join.filter( class_assignments.class_assignments_assignment_type_id == 1, problem_logs.correct == 1, problem_logs.original == 1, problem_logs.user_id == user_id, ).count() incorrect = join.filter( class_assignments.class_assignments_assignment_type_id == 1, problem_logs.correct < 1, problem_logs.original == 1, problem_logs.user_id == user_id, ).count() return get_performance(correct, incorrect)
def user_all_homework_completion_rate(user_id): """Summary Args: user_id (TYPE): Description Returns: TYPE: Description """ assignment_logs = db.assignment_logs class_assignments = db.with_labels(db.class_assignments) join = db.join( class_assignments, assignment_logs, assignment_logs.assignment_id == class_assignments.class_assignments_id ) complete = join.filter( class_assignments.class_assignments_assignment_type_id == 1, assignment_logs.user_id == user_id, assignment_logs.end_time != None, ).count() incomplete = join.filter( class_assignments.class_assignments_assignment_type_id == 1, assignment_logs.user_id == user_id, assignment_logs.end_time == None, ).count() return get_performance(complete, incomplete)
def user_assignment_performance(user_id, class_assignment_id): """Summary Args: user_id (TYPE): Description class_assignment_id (TYPE): Description Returns: TYPE: Description """ correct = user_assignemnt_correct_num(user_id, class_assignment_id) incorrect = user_assignemnt_incorrect_num(user_id, class_assignment_id) return get_performance(correct, incorrect)
def user_reassessment_performance(user_id): """Summary Args: user_id (TYPE): Description Returns: TYPE: Description """ res_prbs = db.student_reassessment_problems problem_logs = db.with_labels(db.problem_logs) join = db.join(res_prbs, problem_logs, res_prbs.problem_log_id == problem_logs.problem_logs_id) where = res_prbs.student_id == user_id_to_student_id(user_id) correct = join.filter(where, problem_logs.problem_logs_correct == 1).count() incorrect = join.filter(where, problem_logs.problem_logs_correct < 1).count() return get_performance(correct, incorrect)
def user_all_homework_completion_rate(user_id): """Summary Args: user_id (TYPE): Description Returns: TYPE: Description """ assignment_logs = db.assignment_logs class_assignments = db.with_labels(db.class_assignments) join = db.join( class_assignments, assignment_logs, assignment_logs.assignment_id == class_assignments.class_assignments_id) complete = join.filter( class_assignments.class_assignments_assignment_type_id == 1, assignment_logs.user_id == user_id, assignment_logs.end_time != None).count() incomplete = join.filter( class_assignments.class_assignments_assignment_type_id == 1, assignment_logs.user_id == user_id, assignment_logs.end_time == None).count() return get_performance(complete, incomplete)
def user_all_class_assignment_performance(user_id): """Summary Args: user_id (TYPE): Description Returns: TYPE: Description """ problem_logs = db.problem_logs class_assignments = db.with_labels(db.class_assignments) join = db.join( class_assignments, problem_logs, problem_logs.assignment_id == class_assignments.class_assignments_id) correct = join.filter( class_assignments.class_assignments_assignment_type_id == 1, problem_logs.correct == 1, problem_logs.original == 1, problem_logs.user_id == user_id).count() incorrect = join.filter( class_assignments.class_assignments_assignment_type_id == 1, problem_logs.correct < 1, problem_logs.original == 1, problem_logs.user_id == user_id).count() return get_performance(correct, incorrect)