def training_answers(): params = request.args #update order number flask.session['order'] = flask.session['order'] + 1 #data order = params['order'] graph1 = flask.session['graph1'] student_test_id = flask.session['student_test_id'] student_id = flask.session['userid'] if flask.session['question_type'] == 'rating': answer_id = params['rating1'] else: answer1 = params['best1'] #figure out answer if answer1 == 'optionA': answer_id = flask.session['answer1'] elif answer1 == 'optionB': answer_id = flask.session['answer2'] elif answer1 == 'optionC': answer_id = flask.session['answer3'] elif answer1 == 'optionD': answer_id = flask.session['answer4'] elif answer1 == 'optionE': answer_id = flask.session['answer5'] answer_list = [(answer_id,graph1)] #write to db #update complete row in StudentsTest table r = conn.execute(StudentsTest.update().\ where(StudentsTest.c.student_test_id == student_test_id).\ values(complete='yes')) conn.execute(Results.insert(), [{ 'student_id':student_id, 'student_test_id':student_test_id, 'answer':answer[0], 'graph_id':answer[1], } for answer in answer_list]) #get next question # question_json = first_question() # return question_json return flask.jsonify(result={"status": 200})
def pretest_answers(): params = request.args #update order number flask.session['order'] = flask.session['order'] + 1 #data best1 = params['best1'] best2 = params['best2'] best3 = params['best3'] order = params['order'] graph1 = flask.session['graph1'] graph2 = flask.session['graph2'] graph3 = flask.session['graph3'] student_test_id = flask.session['student_test_id'] student_id = flask.session['userid'] try: best4 = params['best4'] answer_list = [(best1,graph1),(best2,graph2),(best3,graph3),(best4,'na')] except: answer_list = [(best1,graph1),(best2,graph2),(best3,graph3)] #write to db #update complete row in StudentsTest table r = conn.execute(StudentsTest.update().\ where(StudentsTest.c.student_test_id == student_test_id).\ values(complete='yes')) conn.execute(Results.insert(), [{ 'student_id':student_id, 'student_test_id':student_test_id, 'answer':answer[0], 'graph_id':answer[1], } for answer in answer_list]) #get next question # question_json = first_question() # return question_json return flask.jsonify(result={"status": 200})