def assignmentResponse(self, courseid, assignmentid):
ctx = {
"course": CourseHelper.fetch_course(courseid),
"assignment": AssignmentHelper.fetch_assignment(assignmentid),
}
if ctx["course"] == None:
return whiteboard.template.render(
"error.html", context_dict={"error": "The specified course does not exist"}
)
if ctx["assignment"] == None:
return whiteboard.template.render(
"error.html", context_dict={"error": "The specified assignment does not exist"}
)
return whiteboard.template.render("submitresponse.html", context_dict=ctx)
def viewResponses(self, courseid, assignmentid):
ctx = {
"course": CourseHelper.fetch_course(courseid),
"assignment": AssignmentHelper.fetch_assignment(assignmentid),
}
if ctx["course"] == None or ctx["assignment"] == None:
return whiteboard.template.render("error.html", "That doesn't exist.")
sql = whiteboard.sqltool.SqlTool()
sql.query_text = """
SELECT D.*, G.* FROM Documents D
JOIN Grades G on D.assignmentid = G.assignmentid
WHERE type = 'response'
AND substring(D.name, G.caseid) IS NOT NULL
AND D.courseid = @courseid
AND D.assignmentid = @assignmentid"""
sql.addParameter("@courseid", courseid)
sql.addParameter("@assignmentid", assignmentid)
with sql.execute() as datareader:
ctx["submissions"] = [row for row in datareader]
return whiteboard.template.render("viewresponses.html", context_dict=ctx)
