def search():
query = request.args.get('query').upper()
resp = utilities.get_results(cur, query)
flat_list = []
for a_tuple in resp:
flat_list.append(str(a_tuple[0]) + ' - ' + str(a_tuple[1][1]))
return jsonify(result='@'.join(map(str, flat_list)))
def results_page():
if session.get('logged_in'):
cursor = conn.cursor()
students_query = query_student_all()
quiz_query = query_quiz_all()
student_results = get_results(cursor, students_query)
quiz_results = get_results(cursor, quiz_query)
student_values = merge_tuples_to_dict(
config_student_keys(),
student_results) if student_results else student_results
quiz_values = merge_tuples_to_dict(
config_quiz_keys(), quiz_results) if quiz_results else quiz_results
return render_template('results.html',
student_values=student_values,
quiz_values=quiz_values,
cache_bust=random.random())
else:
return redirect(url_for('dashboard'))
def get_quiz(id):
cursor = conn.cursor()
anon_query = find_quizes_with_students(id)
anon_results = get_results(cursor, anon_query)
anon_values = merge_tuples_to_dict(
config_anon_view_keys(),
anon_results) if anon_results else anon_results
return render_template('quiz-detail.html',
anon_values=anon_values,
cache_bust=random.random())
def get_students(id):
if session.get('logged_in'):
cursor = conn.cursor()
result_query = find_student_quizes(id)
details_results = get_results(cursor, result_query)
details_values = merge_tuples_to_dict(
config_results_keys(),
details_results) if details_results else details_results
return render_template('student.html',
details_values=details_values,
cache_bust=random.random())
else:
flash('please login!')
return redirect(url_for('home'))