def done():
question_type = [x[0] for x in conn.execute(select([Questions.c.question_type]).\
select_from(StudentsTest.join(Questions,
Questions.c.question_id == StudentsTest.c.question_id)).\
where(StudentsTest.c.student_id == flask.session['userid'])).fetchall()]
if 'multiple_choice' in question_type:
return flask.render_template('doneA.html')
elif 'heuristic' in question_type:
return flask.render_template('doneB.html')
else:
asdf
def get_question(order):
progress, graph_id, questions, question_type, answers, complete, dataset, student_test_id, question_id = conn.execute(select([Students.c.progress,
StudentsTest.c.graph_id,
Questions.c.question,
Questions.c.question_type,
Answers.c.answer,
StudentsTest.c.complete,
StudentsTest.c.dataset,
StudentsTest.c.student_test_id,
Questions.c.question_id]).\
select_from(StudentsTest.join(Students,
Students.c.student_id == StudentsTest.c.student_id).\
join(Questions,
Questions.c.question_id == StudentsTest.c.question_id)).\
where(and_(StudentsTest.c.student_id == flask.session['userid'],
StudentsTest.c.test == Students.c.progress,
StudentsTest.c.order == order))).fetchone()
return progress, graph_id, questions, question_type, answers, complete, dataset, student_test_id, question_id
def first_question():
userid = flask.session['userid']
try:
order = flask.session['order']
except:
order = 1
try:
progress, graph_id, question, question_type, answers, complete, dataset, student_test_id,question_id = get_question(order)
except:
complete = 'yes'
progress = conn.execute(select([Students.c.progress]).\
where(Students.c.student_id == flask.session['userid'])).fetchone()
progress = progress[0]
#check to make sure they have not done the question before
if complete == 'yes':
#this means the question has already been completed
order_list = conn.execute(select([StudentsTest.c.order]).\
select_from(StudentsTest.join(Students,
Students.c.student_id == StudentsTest.c.student_id)).\
where(and_(StudentsTest.c.student_id == flask.session['userid'],
StudentsTest.c.complete == 'no',
StudentsTest.c.test == Students.c.progress))).fetchall()
order_list = sorted(order_list)
if len(order_list) >= 1:
progress, graph_id, question, question_type, answers, complete, dataset, student_test_id, question_id = get_question(order_list[0][0])
else:
#the section has been completed, update progress and return to home page
#update order back to start
flask.session['order'] = 1
progress_list = ['pre_test', 'training', 'post_test']
ix = progress_list.index(progress) + 1
if ix == len(progress_list):
new_progress = 'complete'
else:
new_progress = progress_list[ix]
r = conn.execute(Students.update().\
where(Students.c.student_id == flask.session['userid']).\
values(progress=new_progress))
#return to homepage
if new_progress == 'complete':
return flask.jsonify(progress='done')
else:
return flask.jsonify(progress='next')
#put the student_test_id in session
flask.session['student_test_id'] = student_test_id
flask.session['order'] = order
flask.session['question_type'] = question_type
#check which test
if progress == 'pre_test' or progress == 'post_test':
# query three graphs
graph_list = conn.execute(select([Graphs.c.graph_location,
Graphs.c.graph_id]).\
where(Graphs.c.dataset == dataset)).fetchall()
#randomly shuffle order of graphs
shuffle(graph_list)
#put graph id's in session
flask.session['graph1'] = graph_list[0][1]
flask.session['graph2'] = graph_list[1][1]
flask.session['graph3'] = graph_list[2][1]
return flask.jsonify(graph1='<img class=graph src=' + url_for('static',filename='graphs/'+str(graph_list[0][0])) + '>',
graph2='<img class=graph src=' + url_for('static',filename='graphs/'+str(graph_list[1][0])) + '>',
graph3='<img class=graph src=' + url_for('static',filename='graphs/'+str(graph_list[2][0])) + '>',
question=question,
question_type=question_type,
order=order,
progress=progress)
elif progress == 'training':
#get graph location
graph_location = conn.execute(select([Graphs.c.graph_location]).\
where(Graphs.c.graph_id == graph_id)).fetchall()
#if it is a rating question just return graph
if question_type == 'rating':
flask.session['graph1'] = graph_id
return flask.jsonify(graph1='<img class=graph src=' + url_for('static',filename='graphs/'+str(graph_location[0][0])) + '>',
question=question,
question_type=question_type,
order=order,
progress=progress)
else:
#get answers query
answer_list = conn.execute(select([Answers.c.answer,
Answers.c.answer_id]).\
where(Answers.c.question_id == question_id)).fetchall()
try:
answer_list[0][1]
except:
if len(answer_list) >1:
longg
elif len(answer_list) <= 1:
shortt
if question_type == 'heuristic':
#put graph id's in session
flask.session['graph1'] = graph_id
flask.session['answer1'] = answer_list[0][1]
flask.session['answer2'] = answer_list[1][1]
flask.session['answer3'] = answer_list[2][1]
flask.session['answer4'] = answer_list[3][1]
flask.session['answer5'] = answer_list[4][1]
return flask.jsonify(graph1='<img src=' + url_for('static',filename='graphs/'+str(graph_location[0][0])) + ' height="500" width="500">',
question=question,
question_type=question_type,
order=order,
progress=progress,
answer1=answer_list[0][0],
answer2=answer_list[1][0],
answer3=answer_list[2][0],
answer4=answer_list[3][0],
answer5=answer_list[4][0])
else:
#put graph id's in session
flask.session['graph1'] = graph_id
flask.session['answer1'] = answer_list[0][1]
flask.session['answer2'] = answer_list[1][1]
flask.session['answer3'] = answer_list[2][1]
return flask.jsonify(graph1='<img src=' + url_for('static',filename='graphs/'+str(graph_location[0][0])) + ' height="500" width="500">',
question=question,
question_type=question_type,
order=order,
progress=progress,
answer1=answer_list[0][0],
answer2=answer_list[1][0],
answer3=answer_list[2][0])