Example #1
0
 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
Example #2
0
 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