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)