def applicants_and_mentors():
return render_template('queries.html',
data_list=queries.fetch_database(queries.show_applicants_and_mentors()),
table_head=['Applicants first name', 'Application code', 'Mentor first name', 'Mentor last name'])
def applicants():
return render_template('queries.html',
data_list=queries.fetch_database(queries.show_applicants()),
table_head=['Applicant first name', 'Application code', 'Creation_date'])
def mentors_by_country():
return render_template('queries.html',
data_list=queries.fetch_database(queries.show_mentors_by_country()),
table_head=['Country', 'Mentor'])
def contacts():
return render_template('queries.html',
data_list=queries.fetch_database(queries.show_contacts()),
table_head=['School name', 'Mentor first name', 'Mentor last name'])
def all_school():
return render_template('queries.html',
data_list=queries.fetch_database(queries.show_all_school()),
table_head=['Mentor first name', 'Mentor last name', 'School name', 'Country'])