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
