def get(self, id=None):
"""GET operation for the endpoint class.
Returns:
A collection of jobs associated with a specified skill UUID.
"""
if id is not None:
#results = JobSkill.query.filter_by(skill_uuid = id).all()
results = SkillImportance.query.filter_by(skill_uuid = id).all()
if len(results) > 0:
all_jobs = OrderedDict()
skill = SkillMaster.query.filter_by(uuid = id).first()
all_jobs['skill_uuid'] = id
all_jobs['skill_name'] = skill.skill_name
all_jobs['normalized_skill_name'] = skill.nlp_a
all_jobs['jobs'] = []
for result in results:
job = OrderedDict()
job_desc = JobMaster.query.filter_by(uuid = result.job_uuid).first()
job['job_uuid'] = result.job_uuid
job['job_title'] = job_desc.title
job['normalized_job_title'] = job_desc.nlp_a
job['importance'] = result.importance
job['level'] = result.level
all_jobs['jobs'].append(job)
all_jobs['jobs'] = sorted(all_jobs['jobs'], key=lambda k: k['importance'], reverse=True)
return create_response(all_jobs, 200)
else:
return create_error('No associated jobs found for skill ' + id, 404)
else:
return create_error('No skill UUID specified for query', 400)
def get(self):
args = request.args
if args is not None:
if 'title' in args.keys():
search_string = str(args['title'])
else:
return create_error({'message': 'Invalid parameter specified for job title normalization'}, 400)
search_string = search_string.replace('"','').strip()
all_suggestions = []
results = JobUnusualTitle.query.filter(JobUnusualTitle.title.contains(search_string)).all()
if len(results) == 0:
return create_error({'message': 'No normalized job titles found'}, 404)
for result in results:
suggestion = {}
suggestion['title'] = result.title
suggestion['uuid'] = result.uuid
suggestion['parent_uuid'] = result.job_uuid
suggestion['description'] = result.description
all_suggestions.append(suggestion)
return create_response(all_suggestions, 200)
else:
return create_error({'message': 'No normalized job titles found'}, 404)
def get(self):
"""GET operation for the endpoint class.
Returns:
A normalized version of a specified skill name.
"""
args = request.args
if args is not None:
if 'skill_name' in args.keys():
search_string = str(args['skill_name'])
else:
return create_error('Invalid parameter specified for skill name normalization', 400)
search_string = search_string.replace('"','').strip()
all_suggestions = []
results = SkillMaster.query.filter(SkillMaster.skill_name.contains(search_string)).all()
if len(results) == 0:
return create_error('No normalized skill names found', 404)
for result in results:
suggestion = OrderedDict()
suggestion['uuid'] = result.uuid
suggestion['skill_name'] = result.skill_name
all_suggestions.append(suggestion)
return create_response(all_suggestions, 200)
else:
return create_error('No normalized skill names found', 404)
def get(self, id=None):
if id is not None:
result = SkillMaster.query.filter_by(uuid = id).first()
if result is None:
all_skills = {}
job = JobMaster.query.filter_by(onet_soc_code = id).first()
if job is not None:
search_uuid = job.uuid
else:
return create_error({'message':'Cannot find skills associated with id ' + id}, 404)
results = JobSkill.query.filter_by(job_uuid = search_uuid).all()
if len(results) == 0:
return create_error({'message':'Cannot find skills associated with id ' + id}, 404)
else:
all_skills['onet_soc_code'] = id
all_skills['job_uuid'] = search_uuid
all_skills['title'] = job.title
all_skills['skills'] = []
for result in results:
output = OrderedDict()
output['skill_uuid'] = result.skill_uuid
all_skills['skills'].append(output)
return create_response(all_skills, 200)
else:
output = OrderedDict()
output['uuid'] = result.uuid
output['skill_name'] = result.skill_name
output['count'] = result.count
return create_response(output, 200)
def get(self):
args = request.args
if args is not None:
if 'title' in args.keys():
search_string = str(args['title'])
else:
return create_error({'message': 'Invalid parameter specified for skill name normalization'}, 400)
search_string = search_string.replace('"','').strip()
all_suggestions = []
results = SkillMaster.query.filter(SkillMaster.skill_name.contains(search_string)).all()
if len(results) == 0:
return create_error({'message': 'No normalized skill names found'}, 404)
for result in results:
suggestion = {}
suggestion['skill_name'] = result.skill_name
suggestion['uuid'] = result.uuid
all_suggestions.append(suggestion)
return create_response(all_suggestions, 200)
else:
return create_error({'message': 'No normalized skill names found'}, 404)
def get(self, id=None):
"""GET operation for the endpoint class.
Returns:
A collection of skills associated with a specified skill UUID.
"""
if id is not None:
result = SkillMaster.query.filter_by(uuid = id).first()
if result is not None:
all_skills = OrderedDict()
skills = SkillMaster.query.filter(SkillMaster.skill_name.contains(result.skill_name)).all()
if len(skills) > 0:
all_skills['skills'] = []
for skill in skills:
output = OrderedDict()
output['uuid'] = skill.uuid
output['skill_name'] = skill.skill_name
output['normalized_skill_name'] = skill.nlp_a
all_skills['skills'].append(output)
return create_response(all_skills, 200)
else:
return create_error('Cannot find skills associated with id ' + id, 404)
else:
return create_error('No skill UUID specified for query', 400)
def get(self, id=None):
"""GET operation for the endpoint class.
Returns:
A collection of skills associated with a specified skill UUID.
"""
if id is not None:
result = SkillMaster.query.filter_by(uuid=id).first()
if result is not None:
all_skills = OrderedDict()
skills = SkillMaster.query.filter(
SkillMaster.skill_name.contains(result.skill_name)).all()
if len(skills) > 0:
all_skills['skills'] = []
for skill in skills:
output = OrderedDict()
output['uuid'] = skill.uuid
output['skill_name'] = skill.skill_name
output['normalized_skill_name'] = skill.nlp_a
all_skills['skills'].append(output)
return create_response(all_skills, 200)
else:
return create_error(
'Cannot find skills associated with id ' + id, 404)
else:
return create_error('No skill UUID specified for query', 400)
def get(self):
"""GET operation for the endpoint class.
Returns:
A normalized version of a specified skill name.
"""
args = request.args
if args is not None:
if 'skill_name' in args.keys():
search_string = str(args['skill_name'])
else:
return create_error(
'Invalid parameter specified for skill name normalization',
400)
search_string = search_string.replace('"', '').strip()
all_suggestions = []
results = SkillMaster.query.filter(
SkillMaster.skill_name.contains(search_string)).all()
if len(results) == 0:
return create_error('No normalized skill names found', 404)
for result in results:
suggestion = OrderedDict()
suggestion['uuid'] = result.uuid
suggestion['skill_name'] = result.skill_name
all_suggestions.append(suggestion)
return create_response(all_suggestions, 200)
else:
return create_error('No normalized skill names found', 404)
def get(self):
"""GET operation for the endpoint class.
Returns:
A collection of jobs that partially match the specified search string.
"""
args = request.args
query_mode = ''
if args is not None:
if 'begins_with' in args.keys():
search_string = str(args['begins_with'])
query_mode = 'begins_with'
elif 'contains' in args.keys():
search_string = str(args['contains'])
query_mode = 'contains'
elif 'ends_with' in args.keys():
search_string = str(args['ends_with'])
query_mode = 'ends_with'
else:
return create_error(
'Invalid query mode specified for job title autocomplete',
400)
search_string = search_string.replace('"', '').strip()
all_suggestions = []
if query_mode == 'begins_with':
results = JobAlternateTitle.query.filter(
JobAlternateTitle.nlp_a.startswith(
search_string.lower())).all()
if query_mode == 'contains':
results = JobAlternateTitle.query.filter(
JobAlternateTitle.nlp_a.contains(
search_string.lower())).all()
if query_mode == 'ends_with':
results = JobAlternateTitle.query.filter(
JobAlternateTitle.nlp_a.endswith(
search_string.lower())).all()
if len(results) == 0:
return create_error('No job title suggestions found', 404)
for result in results:
suggestion = OrderedDict()
suggestion['uuid'] = result.uuid
suggestion['suggestion'] = result.title
suggestion['normalized_job_title'] = result.nlp_a
suggestion['parent_uuid'] = result.job_uuid
all_suggestions.append(suggestion)
return create_response(all_suggestions, 200)
else:
return create_error('No job title suggestions found', 404)
def get(self, id=None):
"""GET operation for the endpoint class.
Returns:
A collection of skills associated with a particular job UUID.
"""
if id is not None:
#results = JobSkill.query.filter_by(job_uuid = id).all()
results = SkillImportance.query.filter_by(job_uuid=id).all()
job = JobMaster.query.filter_by(uuid=id).first()
if not results:
parent_uuid = None
job = JobAlternateTitle.query.filter_by(uuid=id).first()
if job:
parent_uuid = job.job_uuid
else:
job = JobUnusualTitle.query.filter_by(uuid=id).first()
if job:
parent_uuid = job.job_uuid
if parent_uuid is not None:
#results = JobSkill.query.filter_by(job_uuid = parent_uuid).all()
results = SkillImportance.query.filter_by(
job_uuid=parent_uuid).all()
if len(results) > 0:
all_skills = OrderedDict()
all_skills['job_uuid'] = id
all_skills['job_title'] = job.title
all_skills['normalized_job_title'] = job.nlp_a
all_skills['skills'] = []
for result in results:
skill = OrderedDict()
skill_desc = SkillMaster.query.filter_by(
uuid=result.skill_uuid).first()
skill['skill_uuid'] = result.skill_uuid
skill['skill_name'] = skill_desc.skill_name
skill['skill_type'] = skill_desc.ksa_type
skill['description'] = skill_desc.description
skill['normalized_skill_name'] = skill_desc.nlp_a
skill['importance'] = result.importance
skill['level'] = result.level
all_skills['skills'].append(skill)
all_skills['skills'] = sorted(all_skills['skills'],
key=lambda k: k['importance'],
reverse=True)
return create_response(all_skills, 200)
else:
return create_error('No associated skills found for job ' + id,
404)
else:
return create_error('No job UUID specified for query', 400)
def get(self, id=None):
"""GET operation for the endpoint class.
Returns:
A collection of jobs associated with a specified job UUID.
"""
if id is not None:
parent_uuid = None
result = JobMaster.query.filter_by(uuid=id).first()
if result is None:
result = JobAlternateTitle.query.filter_by(uuid=id).first()
if result is None:
result = JobUnusualTitle.query.filter_by(uuid=id).first()
if result is not None:
parent_uuid = result.job_uuid
else:
return create_error(
'No job found matching the specified uuid ' + id,
404)
else:
parent_uuid = result.job_uuid
else:
parent_uuid = result.uuid
output = OrderedDict()
output['related_job_titles'] = []
output['unusual_job_titles'] = []
# alternate job titles
alt_titles = JobAlternateTitle.query.filter_by(
job_uuid=parent_uuid).all()
for alt_title in alt_titles:
title = OrderedDict()
title['uuid'] = alt_title.uuid
title['title'] = alt_title.title
title['parent_uuid'] = parent_uuid
output['related_job_titles'].append(title)
# unusual job titles
other_titles = JobUnusualTitle.query.filter_by(
job_uuid=parent_uuid).all()
for other_title in other_titles:
title = OrderedDict()
title['uuid'] = other_title.uuid
title['title'] = other_title.title
title['parent_uuid'] = parent_uuid
output['unusual_job_titles'].append(title)
return create_response(output, 200)
else:
return create_error('No Job UUID specified for query', 400)
def get(self):
"""GET operation for the endpoint class.
Returns:
A collection of jobs that partially match the specified search string.
"""
args = request.args
query_mode = ''
if args is not None:
if 'begins_with' in args.keys():
search_string = str(args['begins_with'])
query_mode = 'begins_with'
elif 'contains' in args.keys():
search_string = str(args['contains'])
query_mode = 'contains'
elif 'ends_with' in args.keys():
search_string = str(args['ends_with'])
query_mode = 'ends_with'
else:
return create_error('Invalid query mode specified for job title autocomplete', 400)
search_string = search_string.replace('"','').strip()
all_suggestions = []
if query_mode == 'begins_with':
results = JobAlternateTitle.query.filter(JobAlternateTitle.nlp_a.startswith(search_string.lower())).all()
if query_mode == 'contains':
results = JobAlternateTitle.query.filter(JobAlternateTitle.nlp_a.contains(search_string.lower())).all()
if query_mode == 'ends_with':
results = JobAlternateTitle.query.filter(JobAlternateTitle.nlp_a.endswith(search_string.lower())).all()
if len(results) == 0:
return create_error('No job title suggestions found', 404)
for result in results:
suggestion = OrderedDict()
suggestion['uuid'] = result.uuid
suggestion['suggestion'] = result.title
suggestion['normalized_job_title'] = result.nlp_a
suggestion['parent_uuid'] = result.job_uuid
all_suggestions.append(suggestion)
return create_response(all_suggestions, 200)
else:
return create_error('No job title suggestions found', 404)
def get(self, id=None):
"""GET operation for the endpoint class.
Returns:
A collection of skills associated with a particular job UUID.
"""
if id is not None:
#results = JobSkill.query.filter_by(job_uuid = id).all()
results = SkillImportance.query.filter_by(job_uuid = id).all()
job = JobMaster.query.filter_by(uuid = id).first()
if not results:
parent_uuid = None
job = JobAlternateTitle.query.filter_by(uuid = id).first()
if job:
parent_uuid = job.job_uuid
else:
job = JobUnusualTitle.query.filter_by(uuid = id).first()
if job:
parent_uuid = job.job_uuid
if parent_uuid is not None:
#results = JobSkill.query.filter_by(job_uuid = parent_uuid).all()
results = SkillImportance.query.filter_by(job_uuid = parent_uuid).all()
if len(results) > 0:
all_skills = OrderedDict()
all_skills['job_uuid'] = id
all_skills['job_title'] = job.title
all_skills['normalized_job_title'] = job.nlp_a
all_skills['skills'] = []
for result in results:
skill = OrderedDict()
skill_desc = SkillMaster.query.filter_by(uuid = result.skill_uuid).first()
skill['skill_uuid'] = result.skill_uuid
skill['skill_name'] = skill_desc.skill_name
skill['description'] = skill_desc.description
skill['normalized_skill_name'] = skill_desc.nlp_a
skill['importance'] = result.importance
skill['level'] = result.level
all_skills['skills'].append(skill)
all_skills['skills'] = sorted(all_skills['skills'], key=lambda k: k['importance'], reverse=True)
return create_response(all_skills, 200)
else:
return create_error('No associated skills found for job ' + id, 404)
else:
return create_error('No job UUID specified for query', 400)
def get(self, id=None):
"""GET operation for the endpoint class.
Returns:
A collection of jobs associated with a specified job UUID.
"""
if id is not None:
parent_uuid = None
result = JobMaster.query.filter_by(uuid = id).first()
if result is None:
result = JobAlternateTitle.query.filter_by(uuid = id).first()
if result is None:
result = JobUnusualTitle.query.filter_by(uuid = id).first()
if result is not None:
parent_uuid = result.job_uuid
else:
return create_error('No job found matching the specified uuid ' + id, 404)
else:
parent_uuid = result.job_uuid
else:
parent_uuid = result.uuid
output = OrderedDict()
output['related_job_titles'] = []
output['unusual_job_titles'] = []
# alternate job titles
alt_titles = JobAlternateTitle.query.filter_by(job_uuid = parent_uuid).all()
for alt_title in alt_titles:
title = OrderedDict()
title['uuid'] = alt_title.uuid
title['title'] = alt_title.title
title['parent_uuid'] = parent_uuid
output['related_job_titles'].append(title)
# unusual job titles
other_titles = JobUnusualTitle.query.filter_by(job_uuid = parent_uuid).all()
for other_title in other_titles:
title = OrderedDict()
title['uuid'] = other_title.uuid
title['title'] = other_title.title
title['parent_uuid'] = parent_uuid
output['unusual_job_titles'].append(title)
return create_response(output, 200)
else:
return create_error('No Job UUID specified for query', 400)
def get(self, id=None):
if id is not None:
results = JobSkill.query.filter_by(job_uuid = id).all()
if len(results) > 0:
all_skills = {}
all_skills['job_uuid'] = id
all_skills['skills'] = []
for result in results:
skill ={}
skill['skill_uuid'] = result.skill_uuid
all_skills['skills'].append(skill)
return create_response(all_skills, 200)
else:
return create_error({'message': 'No associated skills found for job ' + id}, 404)
else:
return create_error({'message': 'No job UUID specified for query'}, 400)
def get(self, id=None):
if id is not None:
results = JobSkill.query.filter_by(skill_uuid = id).all()
if len(results) > 0:
all_jobs = {}
all_jobs['skill_uuid'] = id
all_jobs['jobs'] = []
for result in results:
job ={}
job['job_uuid'] = result.job_uuid
all_jobs['jobs'].append(job)
return create_response(all_jobs, 200)
else:
return create_error({'message': 'No associated jobs found for skill ' + id}, 404)
else:
return create_error({'message': 'No skill UUID specified for query'}, 400)
def get(self):
"""GET operation for the endpoint class.
Returns:
A normalized version of a specified job title.
"""
args = request.args
if args is not None:
if 'job_title' in args.keys():
search_string = str(args['job_title'])
else:
return create_error('Invalid parameter specified for job title normalization', 400)
if 'limit' in args.keys():
try:
suggestion_limit = int(args['limit'])
except:
suggestion_limit = 1
else:
suggestion_limit = 1
search_string = search_string.replace('"','').strip()
all_suggestions = []
result = JobUnusualTitle.query.filter(JobUnusualTitle.title.contains(search_string.lower())).first()
if result is None:
return create_error('No normalized job titles found', 404)
alt_titles = JobAlternateTitle.query.filter_by(job_uuid = result.job_uuid).all()
if suggestion_limit > len(alt_titles):
suggestion_limit = len(alt_titles)
for i in range(0, suggestion_limit):
suggestion = OrderedDict()
chosen_title = random.randint(0, len(alt_titles) - 1)
suggestion['uuid'] = alt_titles[chosen_title].uuid
suggestion['title'] = alt_titles[chosen_title].title
suggestion['relevance_score'] = fake_relevance_score()
suggestion['parent_uuid'] = alt_titles[chosen_title].job_uuid
all_suggestions.append(suggestion)
return create_response(sorted(all_suggestions, key=lambda k: k['relevance_score'], reverse=True), 200)
else:
return create_error('No normalized job titles found', 404)
def get(self, id=None):
if id is not None:
result = SkillMaster.query.filter_by(uuid = id).first()
if result is not None:
all_skills = {}
skills = SkillMaster.query.filter(SkillMaster.skill_name.contains(result.skill_name)).all()
if len(skills) > 0:
all_skills['skills'] = []
for skill in skills:
output = OrderedDict()
output['skill_uuid'] = skill.uuid
output['skill_name'] = skill.skill_name
all_skills['skills'].append(output)
return create_response(all_skills, 200)
else:
return create_error({'message':'Cannot find skills associated with id ' + id}, 404)
else:
return create_error({'message': 'No skill UUID specified for query'}, 400)
def get(self, id=None):
"""GET operation for the endpoint class.
Returns:
The name and frequency of all skills.
"""
if id is not None:
result = SkillMaster.query.filter_by(uuid=id).first()
if result is None:
all_skills = OrderedDict()
job = JobMaster.query.filter_by(onet_soc_code=id).first()
if job is not None:
search_uuid = job.uuid
else:
return create_error(
'Cannot find skills associated with id ' + id, 404)
#results = JobSkill.query.filter_by(job_uuid = search_uuid).all()
results = SkillImportance.query.filter_by(
job_uuid=search_uuid).all()
if len(results) == 0:
return create_error(
'Cannot find skills associated with id ' + id, 404)
else:
all_skills['onet_soc_code'] = id
all_skills['job_uuid'] = search_uuid
all_skills['title'] = job.title
all_skills['skills'] = []
for result in results:
output = OrderedDict()
output['skill_uuid'] = result.skill_uuid
all_skills['skills'].append(output)
return create_response(all_skills, 200)
else:
output = OrderedDict()
output['uuid'] = result.uuid
output['skill_name'] = result.skill_name
output['description'] = result.description
output['normalized_skill_name'] = result.nlp_a
return create_response(output, 200)
def get(self):
args = request.args
query_mode = ''
if args is not None:
if 'begins_with' in args.keys():
search_string = str(args['begins_with'])
query_mode = 'begins_with'
elif 'contains' in args.keys():
search_string = str(args['contains'])
query_mode = 'contains'
elif 'ends_with' in args.keys():
search_string = str(args['ends_with'])
query_mode = 'ends_with'
else:
return create_error({'message': 'Invalid query mode specified for job title autocomplete'}, 400)
search_string = search_string.replace('"','').strip()
all_suggestions = []
if query_mode == 'begins_with':
results = JobAlternateTitle.query.filter(JobAlternateTitle.title.startswith(search_string)).all()
if query_mode == 'contains':
results = JobAlternateTitle.query.filter(JobAlternateTitle.title.contains(search_string)).all()
if query_mode == 'ends_with':
results = JobAlternateTitle.query.filter(JobAlternateTitle.title.endswith(search_string)).all()
if len(results) == 0:
return create_error({'message': 'No job title suggestions found'}, 404)
for result in results:
suggestion = {}
suggestion['suggestion'] = result.title
suggestion['uuid'] = result.uuid
suggestion['parent_uuid'] = result.job_uuid
all_suggestions.append(suggestion)
return create_response(all_suggestions, 200)
else:
return create_error({'message': 'No job title suggestions found'}, 404)
def get(self, id=None):
if id is not None:
parent_uuid = None
result = JobMaster.query.filter_by(uuid = id).first()
if result is None:
result = JobAlternateTitle.query.filter_by(uuid = id).first()
if result is None:
result = JobUnusualTitle.query.filter_by(uuid = id).first()
if result is None:
parent_uuid = result.job_id
else:
return create_error({'message': 'No job found matching the specified uuid ' + id}, 404)
else:
parent_uuid = result.job_uuid
else:
parent_uuid = result.uuid
output = OrderedDict()
output['related_job_titles'] = []
output['unusual_job_titles'] = []
# alternate job titles
alt_titles = JobAlternateTitle.query.filter_by(job_uuid = parent_uuid).all()
for alt_title in alt_titles:
title = OrderedDict()
title['uuid'] = alt_title.uuid
title['title'] = alt_title.title
output['related_job_titles'].append(title)
# unusual job titles
other_titles = JobUnusualTitle.query.filter_by(job_uuid = parent_uuid).all()
for other_title in other_titles:
title = OrderedDict()
title['uuid'] = other_title.uuid
title['title'] = other_title.title
output['unusual_job_titles'].append(title)
return create_response(output, 200)
else:
return create_error({'message': 'No Job UUID specified for query'}, 400)
def get(self, id=None):
if id is not None:
result = JobMaster.query.filter_by(onet_soc_code = id).first()
if result is None:
result = JobMaster.query.filter_by(uuid = id).first()
if result is None:
# search for a related job
result = JobAlternateTitle.query.filter_by(uuid = id).first()
if result is not None:
output = OrderedDict()
output['uuid'] = result.uuid
output['title'] = result.title
output['parent_uuid'] = result.job_uuid
return create_response(output, 200)
else:
result = JobUnusualTitle.query.filter_by(uuid = id).first()
if result is not None:
output = OrderedDict()
output['uuid'] = result.uuid
output['title'] = result.title
output['description'] = result.description
output['parent_uuid'] = result.job_uuid
return create_response(output, 200)
else:
return create_error({'message':'Cannot find job with id ' + id}, 404)
else:
output = OrderedDict()
output['uuid'] = result.uuid
output['onet_soc_code'] = result.onet_soc_code
output['title'] = result.title
output['description'] = result.description
output['related_job_titles'] = []
output['unusual_job_titles'] = []
# alternate job titles
alt_titles = JobAlternateTitle.query.filter_by(job_uuid = result.uuid).all()
for alt_title in alt_titles:
title = OrderedDict()
title['uuid'] = alt_title.uuid
title['title'] = alt_title.title
output['related_job_titles'].append(title)
# unusual job titles
other_titles = JobUnusualTitle.query.filter_by(job_uuid = result.uuid).all()
for other_title in other_titles:
title = OrderedDict()
title['uuid'] = other_title.uuid
title['title'] = other_title.title
output['unusual_job_titles'].append(title)
return create_response(output, 200)
def get(self, id=None):
"""GET operation for the endpoint class.
Returns:
The name and frequency of all skills.
"""
if id is not None:
result = SkillMaster.query.filter_by(uuid = id).first()
if result is None:
all_skills = OrderedDict()
job = JobMaster.query.filter_by(onet_soc_code = id).first()
if job is not None:
search_uuid = job.uuid
else:
return create_error('Cannot find skills associated with id ' + id, 404)
#results = JobSkill.query.filter_by(job_uuid = search_uuid).all()
results = SkillImportance.query.filter_by(job_uuid = search_uuid).all()
if len(results) == 0:
return create_error('Cannot find skills associated with id ' + id, 404)
else:
all_skills['onet_soc_code'] = id
all_skills['job_uuid'] = search_uuid
all_skills['title'] = job.title
all_skills['skills'] = []
for result in results:
output = OrderedDict()
output['skill_uuid'] = result.skill_uuid
all_skills['skills'].append(output)
return create_response(all_skills, 200)
else:
output = OrderedDict()
output['uuid'] = result.uuid
output['skill_name'] = result.skill_name
output['description'] = result.description
output['normalized_skill_name'] = result.nlp_a
return create_response(output, 200)
def get(self):
all_skills = []
skills = SkillMaster.query.order_by(SkillMaster.count.desc()).all()
if skills is not None:
for skill in skills:
skill_response = OrderedDict()
skill_response['uuid'] = skill.uuid
skill_response['name'] = skill.skill_name
skill_response['count'] = skill.count
all_skills.append(skill_response)
return create_response(all_skills, 200)
else:
return create_error({'message':'No skills were found'}, 404)
def get(self, id=None):
"""GET operation for the endpoint class.
Returns:
A collection of jobs associated with a specified skill UUID.
"""
if id is not None:
#results = JobSkill.query.filter_by(skill_uuid = id).all()
results = SkillImportance.query.filter_by(skill_uuid=id).all()
if len(results) > 0:
all_jobs = OrderedDict()
skill = SkillMaster.query.filter_by(uuid=id).first()
all_jobs['skill_uuid'] = id
all_jobs['skill_name'] = skill.skill_name
all_jobs['normalized_skill_name'] = skill.nlp_a
all_jobs['jobs'] = []
for result in results:
job = OrderedDict()
job_desc = JobMaster.query.filter_by(
uuid=result.job_uuid).first()
job['job_uuid'] = result.job_uuid
job['job_title'] = job_desc.title
job['normalized_job_title'] = job_desc.nlp_a
job['importance'] = result.importance
job['level'] = result.level
all_jobs['jobs'].append(job)
all_jobs['jobs'] = sorted(all_jobs['jobs'],
key=lambda k: k['importance'],
reverse=True)
return create_response(all_jobs, 200)
else:
return create_error('No associated jobs found for skill ' + id,
404)
else:
return create_error('No skill UUID specified for query', 400)
def get(self):
all_jobs = []
jobs = JobMaster.query.order_by(JobMaster.title.asc()).all()
if jobs is not None:
for job in jobs:
job_response = OrderedDict()
job_response['uuid'] = job.uuid
job_response['onet_soc_code'] = job.onet_soc_code
job_response['title'] = job.title
job_response['description'] = job.description
all_jobs.append(job_response)
return create_response(all_jobs, 200)
else:
return create_error({'message':'No jobs were found'}, 404)
def get(self):
"""GET operation for the endpoint class.
Returns:
A collection of job titles that fall outside the standard titles used for particular jobs.
"""
all_jobs = []
jobs = JobUnusualTitle.query.order_by(JobUnusualTitle.title.asc()).all()
if jobs is not None:
for job in jobs:
job_response = OrderedDict()
job_response['uuid'] = job.uuid
job_response['title'] = job.title
job_response['description'] = job.description
job_response['job_uuid'] = job.job_uuid
all_jobs.append(job_response)
return create_response(all_jobs, 200)
else:
return create_error('No jobs were found', 404)
def get(self):
"""GET operation for the endpoint class.
Returns:
A collection of job titles that fall outside the standard titles used for particular jobs.
"""
all_jobs = []
jobs = JobUnusualTitle.query.order_by(
JobUnusualTitle.title.asc()).all()
if jobs is not None:
for job in jobs:
job_response = OrderedDict()
job_response['uuid'] = job.uuid
job_response['title'] = job.title
job_response['description'] = job.description
job_response['job_uuid'] = job.job_uuid
all_jobs.append(job_response)
return create_response(all_jobs, 200)
else:
return create_error('No jobs were found', 404)
def get(self):
"""GET operation for the endpoint class.
Returns:
A collection of jobs.
Notes:
The endpoint supports pagination.
"""
args = request.args
limit, offset = get_limit_and_offset(args)
all_jobs = []
links = OrderedDict()
links['links'] = []
if args is not None:
geography = None
if 'fips' in args.keys():
fips = args['fips']
geography = Geography.query.filter_by(
geography_type='CBSA', geography_name=fips).first()
if geography is None:
return create_error(
'Core-Based Statistical Area FIPS code not found', 404)
base_stmt = '''select
tc.job_title,
tc.job_uuid,
round(avg(gtc.count), 2)
from
title_counts tc
join geo_title_counts gtc using (job_uuid, quarter_id)
where geography_id = %(geography_id)s
group by 1, 2 order by 3 desc
'''
job_results = db.engine.execute(
'''{}
limit %(limit)s
offset %(offset)s
'''.format(base_stmt),
geography_id=geography.geography_id,
limit=limit,
offset=offset)
rows = [
row[0] for row in db.engine.execute(
'select count(*) from ({}) q'.format(base_stmt),
geography_id=geography.geography_id,
)
][0]
else:
base_stmt = '''select
tc.job_title,
tc.job_uuid,
round(avg(tc.count), 2)
from title_counts tc
group by 1, 2 order by 3 desc
'''
job_results = db.engine.execute('''{}
limit %(limit)s
offset %(offset)s
'''.format(base_stmt),
limit=limit,
offset=offset)
rows = [
row[0] for row in db.engine.execute(
'select count(*) from ({}) q'.format(base_stmt))
][0]
# compute pages
url_link = '/title_counts?offset={}&limit={}'
custom_headers = []
custom_headers.append('X-Total-Count = ' + str(rows))
total_pages = int(math.ceil(rows / limit))
current_page = compute_page(offset, limit)
first = OrderedDict()
prev = OrderedDict()
next = OrderedDict()
last = OrderedDict()
current = OrderedDict()
current['rel'] = 'self'
current['href'] = url_link.format(str(offset), str(limit))
links['links'].append(current)
first['rel'] = 'first'
first['href'] = url_link.format(str(compute_offset(1, limit)),
str(limit))
links['links'].append(first)
if current_page > 1:
prev['rel'] = 'prev'
prev['href'] = url_link.format(
str(compute_offset(current_page - 1, limit)), str(limit))
links['links'].append(prev)
if current_page < total_pages:
next['rel'] = 'next'
next['href'] = url_link.format(
str(compute_offset(current_page + 1, limit)), str(limit))
links['links'].append(next)
last['rel'] = 'last'
last['href'] = url_link.format(str(compute_offset(total_pages, limit)),
str(limit))
links['links'].append(last)
if job_results is not None:
for job in job_results:
title, job_uuid, count = job
job_response = OrderedDict()
job_response['uuid'] = job_uuid
job_response['title'] = title
job_response['count'] = float(count)
job_response['normalized_job_title'] = None
job_response['parent_uuid'] = None
all_jobs.append(job_response)
all_jobs.append(links)
return create_response(all_jobs, 200, custom_headers)
else:
return create_error('No jobs were found', 404)
def get(self):
"""GET operation for the endpoint class.
Returns:
A collection of jobs.
Notes:
The endpoint supports pagination.
"""
args = request.args
limit, offset = get_limit_and_offset(args)
all_jobs = []
links = OrderedDict()
links['links'] = []
jobs = JobAlternateTitle.query.order_by(JobAlternateTitle.title.asc()).limit(limit).offset(offset)
rows = JobAlternateTitle.query.count()
# compute pages
url_link = '/jobs?offset={}&limit={}'
custom_headers = []
custom_headers.append('X-Total-Count = ' + str(rows))
total_pages = int(math.ceil(rows / limit))
current_page = compute_page(offset, limit)
first = OrderedDict()
prev = OrderedDict()
next = OrderedDict()
last = OrderedDict()
current = OrderedDict()
current['rel'] = 'self'
current['href'] = url_link.format(str(offset), str(limit))
links['links'].append(current)
first['rel'] = 'first'
first['href'] = url_link.format(str(compute_offset(1, limit)), str(limit))
links['links'].append(first)
if current_page > 1:
prev['rel'] = 'prev'
prev['href'] = url_link.format(str(compute_offset(current_page - 1, limit)), str(limit))
links['links'].append(prev)
if current_page < total_pages:
next['rel'] = 'next'
next['href'] = url_link.format(str(compute_offset(current_page + 1, limit)), str(limit))
links['links'].append(next)
last['rel'] = 'last'
last['href'] = url_link.format(str(compute_offset(total_pages, limit)), str(limit))
links['links'].append(last)
if jobs is not None:
for job in jobs:
job_response = OrderedDict()
job_response['uuid'] = job.uuid
job_response['title'] = job.title
job_response['normalized_job_title'] = job.nlp_a
job_response['parent_uuid'] = job.job_uuid
all_jobs.append(job_response)
all_jobs.append(links)
return create_response(all_jobs, 200, custom_headers)
else:
return create_error('No jobs were found', 404)
def get(self):
"""GET operation for the endpoint class.
Returns:
A collection of skills.
Notes:
The endpoint supports pagination.
"""
args = request.args
limit, offset = get_limit_and_offset(args)
all_skills = []
links = OrderedDict()
links['links'] = []
skills = SkillMaster.query.order_by(SkillMaster.skill_name.asc()).limit(limit).offset(offset)
rows = SkillMaster.query.count()
# compute pages
url_link = '/skills?offset={}&limit={}'
custom_headers = []
custom_headers.append('X-Total-Count = ' + str(rows))
total_pages = int(math.ceil(rows / limit))
current_page = compute_page(offset, limit)
first = OrderedDict()
prev = OrderedDict()
next = OrderedDict()
last = OrderedDict()
current = OrderedDict()
current['rel'] = 'self'
current['href'] = url_link.format(str(offset), str(limit))
links['links'].append(current)
first['rel'] = 'first'
first['href'] = url_link.format(str(compute_offset(1, limit)), str(limit))
links['links'].append(first)
if current_page > 1:
prev['rel'] = 'prev'
prev['href'] = url_link.format(str(compute_offset(current_page - 1, limit)), str(limit))
links['links'].append(prev)
if current_page < total_pages:
next['rel'] = 'next'
next['href'] = url_link.format(str(compute_offset(current_page + 1, limit)), str(limit))
links['links'].append(next)
last['rel'] = 'last'
last['href'] = url_link.format(str(compute_offset(total_pages, limit)), str(limit))
links['links'].append(last)
if skills is not None:
for skill in skills:
skill_response = OrderedDict()
skill_response['uuid'] = skill.uuid
skill_response['name'] = skill.skill_name
skill_response['description'] = skill.description
skill_response['onet_element_id'] = skill.onet_element_id
skill_response['normalized_skill_name'] = skill.nlp_a
all_skills.append(skill_response)
all_skills.append(links)
return create_response(all_skills, 200, custom_headers)
else:
return create_error('No skills were found', 404)
def get(self, id=None):
"""GET operation for the endpoint class.
Returns:
A job associated with its O*NET SOC code or UUID.
Notes:
This endpoint actually supports two use cases. It first checks if
the identifier is a valid O*NET SOC code, if not it queries for a
UUID.
"""
if id is not None:
result = JobMaster.query.filter_by(onet_soc_code = id).first()
if result is None:
result = JobMaster.query.filter_by(uuid = id).first()
if result is None:
# search for a related job
result = JobAlternateTitle.query.filter_by(uuid = id).first()
if result is not None:
output = OrderedDict()
output['uuid'] = result.uuid
output['title'] = result.title
output['normalized_job_title'] = result.nlp_a
output['parent_uuid'] = result.job_uuid
return create_response(output, 200)
else:
result = JobUnusualTitle.query.filter_by(uuid = id).first()
if result is not None:
output = OrderedDict()
output['uuid'] = result.uuid
output['title'] = result.title
output['normalized_job_title'] = result.title
output['parent_uuid'] = result.job_uuid
return create_response(output, 200)
else:
return create_error('Cannot find job with id ' + id, 404)
else:
output = OrderedDict()
output['uuid'] = result.uuid
output['onet_soc_code'] = result.onet_soc_code
output['title'] = result.title
output['description'] = result.description
output['related_job_titles'] = []
output['unusual_job_titles'] = []
# alternate job titles
alt_titles = JobAlternateTitle.query.filter_by(job_uuid = result.uuid).all()
for alt_title in alt_titles:
title = OrderedDict()
title['uuid'] = alt_title.uuid
title['title'] = alt_title.title
output['related_job_titles'].append(title)
# unusual job titles
other_titles = JobUnusualTitle.query.filter_by(job_uuid = result.uuid).all()
for other_title in other_titles:
title = OrderedDict()
title['uuid'] = other_title.uuid
title['title'] = other_title.title
output['unusual_job_titles'].append(title)
return create_response(output, 200)
def get(self):
"""GET operation for the endpoint class.
Returns:
A collection of jobs.
Notes:
The endpoint supports pagination.
"""
args = request.args
limit, offset = get_limit_and_offset(args)
all_jobs = []
links = OrderedDict()
links['links'] = []
jobs = JobAlternateTitle.query.order_by(
JobAlternateTitle.title.asc()).limit(limit).offset(offset)
rows = JobAlternateTitle.query.count()
# compute pages
url_link = '/jobs?offset={}&limit={}'
custom_headers = []
custom_headers.append('X-Total-Count = ' + str(rows))
total_pages = int(math.ceil(rows / limit))
current_page = compute_page(offset, limit)
first = OrderedDict()
prev = OrderedDict()
next = OrderedDict()
last = OrderedDict()
current = OrderedDict()
current['rel'] = 'self'
current['href'] = url_link.format(str(offset), str(limit))
links['links'].append(current)
first['rel'] = 'first'
first['href'] = url_link.format(str(compute_offset(1, limit)),
str(limit))
links['links'].append(first)
if current_page > 1:
prev['rel'] = 'prev'
prev['href'] = url_link.format(
str(compute_offset(current_page - 1, limit)), str(limit))
links['links'].append(prev)
if current_page < total_pages:
next['rel'] = 'next'
next['href'] = url_link.format(
str(compute_offset(current_page + 1, limit)), str(limit))
links['links'].append(next)
last['rel'] = 'last'
last['href'] = url_link.format(str(compute_offset(total_pages, limit)),
str(limit))
links['links'].append(last)
if jobs is not None:
for job in jobs:
job_response = OrderedDict()
job_response['uuid'] = job.uuid
job_response['title'] = job.title
job_response['normalized_job_title'] = job.nlp_a
job_response['parent_uuid'] = job.job_uuid
all_jobs.append(job_response)
all_jobs.append(links)
return create_response(all_jobs, 200, custom_headers)
else:
return create_error('No jobs were found', 404)
def get(self, id=None):
"""GET operation for the endpoint class.
Returns:
A job associated with its O*NET SOC code or UUID.
Notes:
This endpoint actually supports two use cases. It first checks if
the identifier is a valid O*NET SOC code, if not it queries for a
UUID.
"""
if id is not None:
args = request.args
if args is not None:
geography = None
if 'fips' in args.keys():
fips = args['fips']
geography = Geography.query.filter_by(
geography_type='CBSA', geography_name=fips).first()
if geography is None:
return create_error(
'Core-Based Statistical Area FIPS code not found',
404)
importance = JobImportance.query.filter_by(
geography_id=geography.geography_id,
job_uuid=id).first()
if importance is None:
return create_error(
'Job not found in given Core-Based statistical area',
404)
result = JobMaster.query.filter_by(onet_soc_code=id).first()
if result is None:
result = JobMaster.query.filter_by(uuid=id).first()
if result is None:
# search for a related job
result = JobAlternateTitle.query.filter_by(uuid=id).first()
if result is not None:
output = OrderedDict()
output['uuid'] = result.uuid
output['title'] = result.title
output['normalized_job_title'] = result.nlp_a
output['parent_uuid'] = result.job_uuid
return create_response(output, 200)
else:
result = JobUnusualTitle.query.filter_by(uuid=id).first()
if result is not None:
output = OrderedDict()
output['uuid'] = result.uuid
output['title'] = result.title
output['normalized_job_title'] = result.title
output['parent_uuid'] = result.job_uuid
return create_response(output, 200)
else:
return create_error('Cannot find job with id ' + id,
404)
else:
output = OrderedDict()
output['uuid'] = result.uuid
output['onet_soc_code'] = result.onet_soc_code
output['title'] = result.title
output['description'] = result.description
output['related_job_titles'] = []
output['unusual_job_titles'] = []
# alternate job titles
alt_titles = JobAlternateTitle.query.filter_by(
job_uuid=result.uuid).all()
for alt_title in alt_titles:
title = OrderedDict()
title['uuid'] = alt_title.uuid
title['title'] = alt_title.title
output['related_job_titles'].append(title)
# unusual job titles
other_titles = JobUnusualTitle.query.filter_by(
job_uuid=result.uuid).all()
for other_title in other_titles:
title = OrderedDict()
title['uuid'] = other_title.uuid
title['title'] = other_title.title
output['unusual_job_titles'].append(title)
return create_response(output, 200)
def get(self):
"""GET operation for the endpoint class.
Returns:
A normalized version of a specified job title.
"""
args = request.args
if args is not None:
if 'limit' in args.keys():
try:
limit = int(args['limit'])
if limit < 0:
return create_error(
'Limit must be a positive integer.', 400)
if limit > 10:
return create_error('Limit has a maximum of 10.', 400)
except:
return create_error('Limit must be an integer', 400)
else:
limit = 1
if 'job_title' in args.keys():
search_string = str(args['job_title'])
else:
return create_error(
'Invalid parameter specified for job title normalization',
400)
indexed_field = 'canonicaltitle'
request_body = {
"size": limit * 10, # give us a buffer to remove duplicates
"fields": [indexed_field],
"query": {
"bool": {
"should": [{
"multi_match": {
"query":
search_string,
"fields": [
'{}^5'.format(indexed_field), "occupation",
"jobtitle"
]
}
}, {
"terms": {
"jobdesc": search_string.split(' ')
}
}]
}
}
}
response = es.search(index='job_normalize', body=request_body)
results = response['hits']['hits']
if len(results) == 0:
return create_error('No normalized job titles found', 404)
def normalize(value):
minimum = 0.0
maximum = 10.0
if value < minimum:
return 0.0
elif value > maximum:
return 1.0
else:
return (value - minimum) / (maximum - minimum)
# take unique titles until reaching the limit
distinct_titles = set()
titles = []
num_distinct_titles = 0
for result in results:
if num_distinct_titles >= limit:
break
if 'fields' not in result or indexed_field not in result[
'fields']:
continue
title = result['fields'][indexed_field][0]
if title in distinct_titles:
continue
distinct_titles.add(title)
titles.append({
'title': title,
'score': normalize(result['_score']),
'uuid': str(hashlib.md5(title).hexdigest())
})
num_distinct_titles += 1
all_suggestions = []
category_fetch_stmt = JobAlternateTitle.__table__.select(
JobAlternateTitle.uuid.in_([title['uuid']
for title in titles]))
category_fetch_results = db.engine.execute(category_fetch_stmt)
category_lookup = {
row[0]: row[3]
for row in category_fetch_results
}
for row in titles:
suggestion = OrderedDict()
suggestion['uuid'] = row['uuid']
suggestion['title'] = row['title']
suggestion['relevance_score'] = row['score']
if row['uuid'] in category_lookup:
suggestion['parent_uuid'] = category_lookup[row['uuid']]
else:
suggestion['parent_uuid'] = ''
all_suggestions.append(suggestion)
return create_response(
sorted(all_suggestions,
key=lambda k: k['relevance_score'],
reverse=True), 200)
else:
return create_error('No normalized job titles found', 404)
def get(self):
"""GET operation for the endpoint class.
Returns:
A collection of skills.
Notes:
The endpoint supports pagination.
"""
args = request.args
limit, offset = get_limit_and_offset(args)
all_skills = []
links = OrderedDict()
links['links'] = []
skills = SkillMaster.query.order_by(
SkillMaster.skill_name.asc()).limit(limit).offset(offset)
rows = SkillMaster.query.count()
# compute pages
url_link = '/skills?offset={}&limit={}'
custom_headers = []
custom_headers.append('X-Total-Count = ' + str(rows))
total_pages = int(math.ceil(rows / limit))
current_page = compute_page(offset, limit)
first = OrderedDict()
prev = OrderedDict()
next = OrderedDict()
last = OrderedDict()
current = OrderedDict()
current['rel'] = 'self'
current['href'] = url_link.format(str(offset), str(limit))
links['links'].append(current)
first['rel'] = 'first'
first['href'] = url_link.format(str(compute_offset(1, limit)),
str(limit))
links['links'].append(first)
if current_page > 1:
prev['rel'] = 'prev'
prev['href'] = url_link.format(
str(compute_offset(current_page - 1, limit)), str(limit))
links['links'].append(prev)
if current_page < total_pages:
next['rel'] = 'next'
next['href'] = url_link.format(
str(compute_offset(current_page + 1, limit)), str(limit))
links['links'].append(next)
last['rel'] = 'last'
last['href'] = url_link.format(str(compute_offset(total_pages, limit)),
str(limit))
links['links'].append(last)
if skills is not None:
for skill in skills:
skill_response = OrderedDict()
skill_response['uuid'] = skill.uuid
skill_response['name'] = skill.skill_name
skill_response['description'] = skill.description
skill_response['onet_element_id'] = skill.onet_element_id
skill_response['normalized_skill_name'] = skill.nlp_a
all_skills.append(skill_response)
all_skills.append(links)
return create_response(all_skills, 200, custom_headers)
else:
return create_error('No skills were found', 404)