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
def UpdateResutl(self, messageParaList): try: if len(messageParaList) != 4: return False else: result = messageParaList[0] score = messageParaList[1] runTime = messageParaList[2] usingMem = messageParaList[3] if result == ENUMResources.const.WRONG_ANSWER: self.UpdateTable_SubmittedRecordsOfProblems_WrongAnswer() elif result == ENUMResources.const.TIME_OVER: self.UpdateTable_SubmittedRecordsOfProblems_TimbeOver() elif result == ENUMResources.const.SOLVED: self.UpdateTable_SubmittedRecordsOfProblems_Solved() elif result == ENUMResources.const.RUNTIME_ERROR: self.UpdateTable_SubmittedRecordsOfProblems_RunTimeError() elif result == ENUMResources.const.COMPILE_ERROR: self.UpdateTable_SubmittedRecordsOfProblems_CompileError() else: return False self.UpdateTableSubmissions(result, score, runTime, usingMem) db_session.commit() return True except Exception as e: db_session.rollback() return False