def UpdateTable_SubmittedRecordsOfProblems_TimbeOver(self): try: db_session.query(SubmittedRecordsOfProblems).\ filter_by(problemId = self.problemNum, courseId = self.courseNum).\ update(dict(sumOfSubmissionCount = SubmittedRecordsOfProblems.sumOfSubmissionCount + 1, sumOfTimeOverCount = SubmittedRecordsOfProblems.sumOfTimeOverCount + 1)) except Exception as e: raise e
def UpdateTableSubmissions(self, result, score, runTime, usingMem): try: db_session.query(Submissions).\ filter_by(memberId = self.stdNum, problemId = self.problemNum, courseId = self.courseNum, submissionCount = self.submitCount).\ update(dict(status = ListResources.const.GRADERESULT_List.index(result), score = score, runTime = runTime, usedMemory = usingMem, solutionCheckCount = Submissions.solutionCheckCount+1)) except Exception as e: raise e
def UpdateServerError(stdNum, problemNum, courseNum, submitCount): try : db_session.query(Submissions).\ filter_by(memberId = stdNum, problemId = problemNum, courseId = courseNum, submissionCount = submitCount).\ update(dict(status = 8, score = 0, runTime = 0, usedMemory = 0)) db_session.commit() print '...server error...' except Exception as e: raise e