def posttest_answers():
params = request.args
#update order number
flask.session['order'] = flask.session['order'] + 1
#data
best1 = params['best1']
best2 = params['best2']
order = params['order']
#student_test_id = flask.session['student_test_id']
student_id = flask.session['userid']
answer_list = [(best1,1000), (best2,1001)]
#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':int(str(student_id) + str(answer[1])),
'answer':answer[0],
'graph_id':'na',
} for answer in answer_list])
#get next question
# question_json = first_question()
# return question_json
return flask.jsonify(result={"status": 200})
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})
