def get_interviews_by_job_id(job_id): interview_list1 = [] return_job = db_session.query(JobHasCandidate).filter( JobHasCandidate.position_id == job_id) for row in return_job: jhcid = row.id print(jhcid) # get list of interviews for that job_has_candidate_id result11 = db_session.query(Interview).filter( Interview.job_has_candidate_id == jhcid) # Loop through interview list, convert to json and add to result list for interview in result11: interview_list1.append(interview.serialize()) return jsonify(interview_list1)
def get_interviews_by_candidate_id(candi_id): interview_list = [] # Get entries from JobHasCandidate table for the specific candidate id return_interview = db_session.query(JobHasCandidate).filter( JobHasCandidate.candidate_id == candi_id) for row in return_interview: jhcid = row.id # get list of interviews for that job_has_candidate_id result = db_session.query(Interview).filter( Interview.job_has_candidate_id == jhcid) # Loop through interview list, convert to json and add to result list for interview in result: interview_list.append(interview.serialize()) return jsonify(interview_list)
def get_interview_by_candidate_id(id): result = db_session.query(Interview).filter( Interview.job_has_candidate_id == id) candidate_list = [] for value in result: candidate_list.append(value.serialize()) return jsonify(candidate_list)
def get_interview_by_date(days): current_date = datetime.now() search_date = datetime.now() + timedelta(days=int(days)) results = db_session.query(Interview).filter(Interview.schedule_time.between(current_date, search_date)) date_list = [] for value in results: date_list.append(value.serialize()) return jsonify(date_list)
def update_interview(id): content = request.get_json() interviewUpdatedObj = Interview(content) # interviewObj.id = id # db_session.add(interviewObj) interviewObj = db_session.query(Interview).get(id) interviewObj = interviewUpdatedObj db_session.commit() return {"id": interviewObj.id,"status": "OK"}
def patch_interview(id): content = request.get_json() db_value = db_session.query(Interview).get(id) key_list = content.keys() if 'comment' in key_list: db_value.comment = content['comment'] if 'feedback' in key_list: db_value.feedback = content['feedback'] db_session.commit() return {"id": id, "status": "Feedback recorded"}
def patch_interview(id): content = request.get_json() db_value = db_session.query(Interview).get(id) key_list = content.keys() if 'channel' in key_list: db_value.channel=content['channel'] if 'location' in key_list: db_value.location = content['location'] if 'comment' in key_list: db_value.comment = content['comment'] if 'feedback' in key_list: db_value.feedback = content['feedback'] db_session.commit() return "Row updated"
def delete_interview(id): x = db_session.query(Interview).get(id) db_session.delete(x) db_session.commit() return {"status": "OK"}
def get_interview(id): return jsonify(db_session.query(Interview).get(id).serialize())
def get_interviews(): interviews = db_session.query(Interview).all() interview_list = [] for interview in interviews: interview_list.append(interview.serialize()) return jsonify(interview_list)
def get_interview(id): interview_obj = db_session.query(Interview).get(id) if interview_obj == None: abort(404) return jsonify(interview_obj.serialize())