def get_quiz_result_by_quiz_id_user_id(quiz_id, user_id):
hs = Historysession.get_current_history_session_by_user_id_quiz_id(user_id)
if hs:
qr = QuizResult.query.filter_by(session_id=hs.hsid).first()
if qr:
qr.quiz = Quiz.get_quiz_only_by_id(qr.quiz_id)
return qr
else:
return None
def jdelete(quiz_id):
current_app.logger.debug("jdelete. quiz_id - " + str(quiz_id))
quiz = Quiz.get_quiz_only_by_id(quiz_id)
if quiz:
if current_user.id == quiz.user_id:
QuizResult.delete_quiz_results_by_quiz_id(quiz_id)
Quiz.delete_quiz_by_id(quiz_id)
db.session.commit()
current_app.logger.debug("Quiz deleted")
return jsonify({"status": "OK"})
else:
msg = auth_failure_message + u"delete this quiz(id = " + str(quiz_id).decode("UTF-8")+")"
current_app.logger.warning(msg)
return jsonify({"status": "ERROR", "message" : msg})
else:
msg = u"No quiz found with such quiz_id" + str(quiz_id).decode("UTF-8")
current_app.logger.warning(msg)
return jsonify({"status": "ERROR", "message": msg})
def get_quiz_result_by_id(session_id):
quiz_result = QuizResult.query.filter_by(session_id=session_id).first()
if quiz_result:
quiz_result.quiz = Quiz.get_quiz_only_by_id(quiz_result.quiz_id)
quiz_result.question_results = QuestionResult.get_question_results_by_id(session_id)
return quiz_result