def delete_employee(employee_id):
Database.set_engine()
try:
Database.open_connection()
employee = EmployeeModel(employee_id, None, None, None, None)
employee.delete()
except Exception as ex:
raise InvalidUsage(str(ex), status_code=500)
finally:
Database.close_connection()
return json.dumps({'status':'ok',})
def get_person(person_id):
Database.set_engine()
person = PersonModel(person_id, None, None, None)
try:
Database.open_connection()
person.getdata()
except Exception as ex:
raise InvalidUsage(str(ex), status_code=500)
finally:
Database.close_connection()
return json.dumps({
'person_id':person.person_id,
'last_name':person.last_name,
'first_name':person.first_name,
'birth_date':datetime.strftime(person.birth_date, "%Y-%m-%d")})
def get_employee(employee_id):
Database.set_engine()
employee = EmployeeModel(employee_id, None, None, None, None)
try:
Database.open_connection()
employee.getdata()
except Exception as ex:
raise InvalidUsage(str(ex), status_code=500)
finally:
Database.close_connection()
return json.dumps({
'employee_id':employee.employee_id,
'person_id':employee.person_id,
'employee_num':employee.employee_num,
'employed_date':datetime.strftime(employee.employed_date, "%Y-%m-%d"),
'terminated_date':datetime.strftime(employee.terminated_date, "%Y-%m-%d")})
