def job_inquiry():
"""Displays the Job Inquiry page"""
filter_words = {'sql_query': '',
'job_identifier': '',
'summary': '',
'location' : '',
'discipline' : 'Computer, Electrical, Software, Computer Science',
'job_title': '',
'employer_name' : '',
'languages' : '',
'junior' : 'junior',
'intermediate' : 'intermediate',
'senior': 'senior' }
jobs = []
prioritized_languages = logic.get_prioritized_languages()
return render_template("JobInquiry.html", jobs = jobs, filter_words = filter_words, prioritized_languages = prioritized_languages)
def submit():
"""Submits user's query to the database and returns with appropriate results"""
#do not add request.form['junior'] or other levels here. Will cause 500 errors
filters = {'sql_query': request.form['sql_query'],
'job_identifier': str(request.form['job_identifier']),
'summary': request.form['summary'],
'location' : request.form['location'],
'discipline' : request.form['discipline'],
'job_title': request.form['job_title'],
'employer_name' : request.form['employer_name'],
'languages' : request.form['languages'],
}
print('going into initialize_level_filters(filters)')
try:
if request.form['junior']:
filters['junior'] = 'junior'
except:
filters['junior'] = 'impossible'
print('set junior, which is now' + filters['junior'])
try:
if request.form['intermediate']:
filters['intermediate'] = 'intermediate'
except:
filters['intermediate'] = 'impossible'
print('set intermediate, which is now' + filters['intermediate'])
try:
if request.form['senior']:
filters['senior'] = 'senior'
except:
filters['senior'] = 'impossible'
print('set senior, which is now' + filters['senior'])
jobs = logic.submit(filters)
prioritized_languages = logic.get_prioritized_languages()
return render_template("JobInquiry.html", jobs = jobs, filter_words = filters, prioritized_languages = prioritized_languages)
