def assignment_status(manual_grading, not_visible_before, cannot_build_after):
is_visible = now_compare(not_visible_before) >= 0
if not is_visible:
return ("purple", "Hidden")
elif manual_grading:
return ("grey", "Visible")
can_build = now_compare(cannot_build_after) <= 0
if not can_build:
return ("grey", "Finished")
else:
return ("green", "Ongoing")
def assignments():
with DbCursor() as c:
student = _get_student(c)
user_id, _, _, login, _, _ = student
super_value = get_super(c, user_id)
dropped = super_value is not None and super_value < 0
c.execute(
"SELECT assignment, score, slipunits, updated FROM grades WHERE user = ?",
[user_id])
grade_info = {
assignment: (score, slipunits, updated)
for assignment, score, slipunits, updated in c.fetchall()
}
template_common = _template_common(c)
assignments_info = []
if not dropped:
for assignment in config.assignments:
a = assignment.student_view(login)
if now_compare(a.not_visible_before) >= 0:
assignments_info.append(
(a.name, a.full_score, a.weight, a.due_date) +
grade_info.get(a.name, (None, None, None)))
return render_template("dashboard/assignments.html",
assignments_info=assignments_info,
**template_common)
def auto_build_status(manual_grading, begin, end):
if manual_grading:
return ("grey", "Manual Grading")
status = now_compare(begin, end)
if status == 0:
return ("green", "Enabled")
elif status == -1:
return ("purple", "Not yet enabled")
else:
return ("grey", "Disabled")
def assignments():
with DbCursor() as c:
c.execute("SELECT assignment, score, slipunits, updated FROM grades WHERE user = ?",
[user_id()])
grade_info = {assignment: (score, slipunits, updated)
for assignment, score, slipunits, updated in c.fetchall()}
template_common = _template_common(c)
assignments_info = [(a.name, a.full_score, a.weight, a.due_date) +
grade_info.get(a.name, (None, None, None))
for a in config.assignments if now_compare(a.not_visible_before) >= 0]
return render_template("dashboard/assignments.html",
assignments_info=assignments_info,
**template_common)
def build_now():
job_name = request.form.get("f_job_name")
repo = request.form.get("f_repo")
assignment = get_assignment_by_name(job_name)
if not assignment:
abort(400)
assignment = assignment.student_view(repo)
if assignment.manual_grading:
abort(400)
with DbCursor() as c:
student = _get_student(c)
user_id, _, _, login, _, _ = student
super_value = get_super(c, user_id)
dropped = super_value is not None and super_value < 0
if assignment.is_group:
repos = get_groups(c, user_id)
else:
repos = [login]
if repo not in repos:
abort(403)
if now_compare(assignment.not_visible_before,
add_grace_period(
assignment.cannot_build_after)) != 0 or dropped:
abort(400)
branch_hash = get_branch_hash(repo, "master")
message = None
if branch_hash:
message = get_commit_message(repo, branch_hash)
# This section doesn't absolutely NEED to be consistent with the previous transaction,
# since we have not specified any actual data constraints. The only possible logical error
# would be to fulfill a request when the current user's permissions have been revoked
# between these two transactions.
with DbCursor() as c:
build_name = create_build(c, job_name, repo, branch_hash, message)
if should_limit_source(repo, job_name):
rate_limit_fail_build(build_name)
else:
job = Job(build_name, repo, "Web interface")
dockergrader_queue.enqueue(job)
return redirect(url_for("dashboard.builds_one", name=build_name))
def assignments():
with DbCursor() as c:
c.execute(
"SELECT assignment, score, slipunits, updated FROM grades WHERE user = ?",
[user_id()])
grade_info = {
assignment: (score, slipunits, updated)
for assignment, score, slipunits, updated in c.fetchall()
}
template_common = _template_common(c)
assignments_info = [(a.name, a.full_score, a.weight, a.due_date) +
grade_info.get(a.name, (None, None, None))
for a in config.assignments
if now_compare(a.not_visible_before) >= 0]
return render_template("dashboard/assignments.html",
assignments_info=assignments_info,
**template_common)
def build_now():
job_name = request.form.get("f_job_name")
repo = request.form.get("f_repo")
assignment = get_assignment_by_name(job_name)
if not assignment:
abort(400)
if assignment.manual_grading:
abort(400)
if now_compare(assignment.not_visible_before, assignment.cannot_build_after) != 0:
abort(400)
with DbCursor() as c:
student = _get_student(c)
user_id, _, _, login, _, _ = student
if assignment.is_group:
repos = get_groups(c, user_id)
else:
repos = [login]
if repo not in repos:
abort(403)
branch_hash = get_branch_hash(repo, "master")
message = None
if branch_hash:
message = get_commit_message(repo, branch_hash)
# This section doesn't absolutely NEED to be consistent with the previous transaction,
# since we have not specified any actual data constraints. The only possible logical error
# would be to fulfill a request when the current user's permissions have been revoked
# between these two transactions.
with DbCursor() as c:
build_name = create_build(c, job_name, repo, branch_hash, message)
job = Job(build_name, repo, "Web interface")
dockergrader_queue.enqueue(job)
return redirect(url_for("dashboard.builds_one", name=build_name))
def assignments_one(name):
with DbCursor() as c:
student = _get_student(c)
user_id, _, _, login, _, _ = student
assignment = get_assignment_by_name(name)
if not assignment:
abort(404)
slipunits_now = slip_units_now(assignment.due_date)
is_visible = now_compare(assignment.not_visible_before) >= 0
if assignment.manual_grading:
can_build = False
else:
can_build = now_compare(assignment.cannot_build_after) <= 0
if not is_visible:
abort(404)
c.execute("SELECT score, slipunits, updated FROM grades WHERE user = ? AND assignment = ?",
[user_id, name])
grade = c.fetchone()
if not grade:
grade = (None, None, None)
if assignment.is_group:
repos = get_groups(c, user_id)
else:
repos = [login]
c.execute('''SELECT build_name, source, status, score, `commit`, message, started
FROM builds WHERE job = ? AND source IN (%s)
ORDER BY started DESC''' % (",".join(["?"] * len(repos))),
[name] + repos)
builds = c.fetchall()
if builds:
most_recent_repo = builds[0][1]
else:
most_recent_repo = None
if grade[0] is not None:
c.execute('''SELECT COUNT(*) + 1 FROM grades WHERE assignment = ? AND score > ?''',
[name, grade[0]])
rank, = c.fetchone()
else:
rank = None
c.execute('''SELECT COUNT(*), AVG(score) FROM grades
WHERE assignment = ? AND score IS NOT NULL''', [name])
stats = c.fetchone()
if stats[0] == 0:
variance = None
stddev = None
else:
c.execute("SELECT AVG((score - ?) * (score - ?)) FROM grades WHERE assignment = ?",
[stats[1], stats[1], name])
variance, = c.fetchone()
stddev = sqrt(variance)
assignment_info = ((assignment.name, assignment.full_score, assignment.weight,
assignment.due_date, assignment.category, assignment.is_group,
assignment.manual_grading) + grade + (rank,) + stats + (stddev,))
template_common = _template_common(c)
return render_template("dashboard/assignments_one.html",
assignment_info=assignment_info,
builds=builds,
repos=repos,
most_recent_repo=most_recent_repo,
slipunits_now=slipunits_now,
can_build=can_build,
**template_common)
def assignments_one(name):
with DbCursor() as c:
student = _get_student(c)
user_id, _, _, login, _, _ = student
assignment = get_assignment_by_name(name)
if not assignment:
abort(404)
slipunits_now = slip_units_now(assignment.due_date)
is_visible = now_compare(assignment.not_visible_before) >= 0
if assignment.manual_grading:
can_build = False
else:
can_build = now_compare(assignment.cannot_build_after) <= 0
if not is_visible:
abort(404)
c.execute(
"SELECT score, slipunits, updated FROM grades WHERE user = ? AND assignment = ?",
[user_id, name])
grade = c.fetchone()
if not grade:
grade = (None, None, None)
if assignment.is_group:
repos = get_groups(c, user_id)
else:
repos = [login]
c.execute(
'''SELECT build_name, source, status, score, `commit`, message, started
FROM builds WHERE job = ? AND source IN (%s)
ORDER BY started DESC''' % (",".join(["?"] * len(repos))),
[name] + repos)
builds = c.fetchall()
if builds:
most_recent_repo = builds[0][1]
else:
most_recent_repo = None
if grade[0] is not None:
c.execute(
'''SELECT COUNT(*) + 1 FROM grades WHERE assignment = ? AND score > ?''',
[name, grade[0]])
rank, = c.fetchone()
else:
rank = None
c.execute(
'''SELECT COUNT(*), AVG(score) FROM grades
WHERE assignment = ? AND score IS NOT NULL''', [name])
stats = c.fetchone()
if stats[0] == 0:
variance = None
stddev = None
else:
c.execute(
"SELECT AVG((score - ?) * (score - ?)) FROM grades WHERE assignment = ?",
[stats[1], stats[1], name])
variance, = c.fetchone()
stddev = sqrt(variance)
assignment_info = (
(assignment.name, assignment.full_score, assignment.weight,
assignment.due_date, assignment.category, assignment.is_group,
assignment.manual_grading) + grade + (rank, ) + stats +
(stddev, ))
template_common = _template_common(c)
return render_template("dashboard/assignments_one.html",
assignment_info=assignment_info,
builds=builds,
repos=repos,
most_recent_repo=most_recent_repo,
slipunits_now=slipunits_now,
can_build=can_build,
**template_common)
