def updateStats(db, passageId, userId, timeTaken, answers):
questions = databaseQueries.getQuestions(db, passageId)
score = 0
count = 1
for question in questions:
correctAnswer = question.answer
givenAnswer = answers[count - 1]
if(givenAnswer == None):
givenAnswer = "N/A"
databaseQueries.insertAnswerStats(db, question.id, userId, givenAnswer)
score += 1 if(correctAnswer == givenAnswer) else 0
count += 1
databaseQueries.insertPassageStats(db, passageId, userId, timeTaken, score)
def getResultsReviewHTMLCode(db, passageId, answers, numberOfAttempts):
htmlCode = ""
questions = databaseQueries.getQuestions(db, passageId)
count = 1
for question in questions:
htmlCode += str(count) + ". "
htmlCode += question.question + "<br/>"
correctAnswer = question.answer
givenAnswer = answers[count - 1]
isCorrect = True if(correctAnswer == givenAnswer) else False
colors = {}
colors["A"] = "FFFFFF"
colors["B"] = "FFFFFF"
colors["C"] = "FFFFFF"
colors["D"] = "FFFFFF"
colors["E"] = "FFFFFF"
colors[givenAnswer] = "ED534F" #Red
colors[correctAnswer] = "F7E259" #Yellow
if(isCorrect):
colors[givenAnswer] = "73D549" #Green
htmlCode+="<font style='BACKGROUND-COLOR: #" + colors["A"] + "'>"
htmlCode += "<b>(A)</b> " + (question.optionA if question.optionA!="" else "---")
htmlCode+="</font><br/>"
htmlCode+="<font style='BACKGROUND-COLOR: #" + colors["B"] + "'>"
htmlCode += "<b>(B)</b> " + (question.optionB if question.optionB!="" else "---")
htmlCode+="</font><br/>"
htmlCode+="<font style='BACKGROUND-COLOR: #" + colors["C"] + "'>"
htmlCode += "<b>(C)</b> " + (question.optionC if question.optionC!="" else "---")
htmlCode+="</font><br/>"
htmlCode+="<font style='BACKGROUND-COLOR: #" + colors["D"] + "'>"
htmlCode += "<b>(D)</b> " + (question.optionD if question.optionD!="" else "---")
htmlCode+="</font><br/>"
htmlCode+="<font style='BACKGROUND-COLOR: #" + colors["E"] + "'>"
htmlCode += "<b>(E)</b> " + (question.optionE if question.optionE!="" else "---")
htmlCode+="</font>"
if(numberOfAttempts>20):
htmlCode += "<div id='question" + str(count) + "Chart' style='width: 200px; height: 200px;'></div><br/>"
else:
htmlCode += "<br/><br/>"
count += 1
return htmlCode
def getQuestionsHTMLCode(db, passageId):
htmlCode = ""
questions = databaseQueries.getQuestions(db, passageId)
count = 1
for question in questions:
htmlCode += str(count) + ". "
htmlCode += question.question + "<br/>"
htmlCode += '<input type="radio" value="A" name="question-' + str(count)+ '">' + " <b>(A)</b> " + (question.optionA if question.optionA!="" else "---") + "<br/>"
htmlCode += '<input type="radio" value="B" name="question-' + str(count)+ '">' + " <b>(B)</b> " + (question.optionB if question.optionB!="" else "---") + "<br/>"
htmlCode += '<input type="radio" value="C" name="question-' + str(count)+ '">' + " <b>(C)</b> " + (question.optionC if question.optionC!="" else "---") + "<br/>"
htmlCode += '<input type="radio" value="D" name="question-' + str(count)+ '">' + " <b>(D)</b> " + (question.optionD if question.optionD!="" else "---") + "<br/>"
htmlCode += '<input type="radio" value="E" name="question-' + str(count)+ '">' + " <b>(E)</b> " + (question.optionE if question.optionE!="" else "---") + "<br/><br/>"
count += 1
return htmlCode
def getResultsHTMLCode(db, passageId, answers, elapsedTime, numberOfAttempts):
htmlCode = ""
htmlCode += "<table class='ResultTable'>\n"
htmlCode += "<tr><td>Question</td>\n"
htmlCode += "<td>Your Answer</td>\n"
htmlCode += "<td>Correct Answer</td>\n"
htmlCode += "<td>Result</td></tr>\n"
questions = databaseQueries.getQuestions(db, passageId)
count = 1
numCorrect = 0
for question in questions:
correctAnswer = question.answer
givenAnswer = answers[count - 1]
if(givenAnswer==None):
givenAnswer = "Not Answered"
isCorrect = True if(correctAnswer == givenAnswer) else False
if(isCorrect):
numCorrect += 1
score = str(IMG(_src= URL('static','images/correct.png'),_alt="Correct") if(isCorrect) else IMG(_src= URL('static','images/wrong.png'),_alt="Wrong"))
htmlCode += "<tr>\n"
htmlCode += "<td>" + str(count) + "</td>\n"
htmlCode += "<td>" + givenAnswer + "</td>\n"
htmlCode += "<td>" + correctAnswer + "</td>\n"
htmlCode += "<td>" + score + "</td>\n"
htmlCode += "</tr>\n"
count += 1
htmlCode += "</table><br/>\n"
htmlCode += "<div align='center'>Time Taken : <b>" + elapsedTime + "</b></div>"
htmlCode += "<div align='center'>Your total score is : <b>" + str(numCorrect) + "/" + str(count-1) + " </b></div>"
if(numberOfAttempts>20):
averageNumOfSeconds = databaseQueries.getAverageTime(db, passageId)
htmlCode += "<div align='center'>Average Time Taken : <b>" + str(time.strftime('%M:%S',time.gmtime(averageNumOfSeconds))) + "</b></div>"
htmlCode += "<div align='center'>Average Score : <b>" + str(databaseQueries.getAverageScore(db, passageId)) + " </b></div>"
htmlCode += "<br/>"
return htmlCode