def delete(employee_id):
"""
:param employee_id:
:return:
"""
session = create_session()
try:
if not session.query(exists().where(Employee.id == employee_id)).scalar():
session.rollback()
return {'error message': 'An employee with the id of %s does not exist' % employee_id}, 500
employee = get(employee_id=[employee_id])
session.query(Employee).filter_by(id=employee_id).delete()
except SQLAlchemyError:
session.rollback()
error_message = "Error while deleting employee %s" % employee_id
logger.warning("Employees.py - " + error_message)
return {'error_message': error_message}, 500
# COMMIT & CLOSE
session.commit()
session.close()
print(employee['employee_array'])
employee_object = employee['employee_array'][0]
logger.warning("Successfully deleted the following employee: "
"Employee ID: %s, Name %s, Birth Date %s, Department: %s"
% (employee_object['employee_id'],
employee_object['name'],
datetime.strptime(str(employee_object['birth_date']), '%Y-%m-%d').date(),
employee_object['department']))
return {'Magic': 'Magically making things vanish since 2017', 'deleted_employee': employee}, 200
def get(employee_id, session=None):
""" This is the GET function that will return one or more employee objects within the system.
:param employee_id:
:return: a set of Employee Objects
"""
if session == None:
session = create_session()
try:
employee_object = session.query(Employee).get(employee_id)
except SQLAlchemyError:
session.rollback()
logger.error(
"Employee.py Get - Failed to retrieve employee number %s. "
"Invalid statement." % str(employee_id))
return {
'error_message': 'Error while retrieving employee %s' % employee_id
}, 400
try:
children = get_all_children_objects(employee_object)
except AttributeError:
logger.error(
"Employee.py Get - failed to retrieve employee number %s. Employee does not exist."
% str(employee_id))
return {
'error_message': 'Error while retrieving employee %s' % employee_id
}, 400
employee = EmployeeApiModel(
is_active=employee_object.is_active,
employee_id=employee_object.id,
name=employee_object.first_name + ' ' + employee_object.last_name,
birth_date=employee_object.birth_date,
email=employee_object.email,
address=children['address'].to_str(),
department=children['department'].to_str(),
role=children['title'].to_str(),
team_start_date=children['department'].start_date,
start_date=employee_object.start_date,
salary=children['salary'].to_str())
session.close()
logger.warning(
"Employee.py Get - Retrieved Employee ID %s"
" (Name: %s, Email: %s, Birth date: %s, Department: %s, Role: %s)" %
(str(employee_id),
employee_object.first_name + ' ' + employee_object.last_name,
employee_object.email, employee_object.birth_date,
children['department'].to_str(), children['title'].to_str()))
return EmployeeResponse(employee).to_dict()
def get():
session = create_session()
employee_collection = []
info = "Get Employees - Found the following employees - "
try:
if not session.query(Employee).first():
session.rollback()
logger.warning("Get Employees - No employees exist in the system")
return {'error message': 'No employees exist in the system'}, 400
all_employee_objects = session.query(Employee).all()
for employee_object in all_employee_objects:
employee = EmployeeRewardApiModel(employee_id=employee_object.id,
name=employee_object.first_name +
' ' + employee_object.last_name,
phones=employee_object.phones,
orders=employee_object.orders)
if employee_object.phones != 0 and employee_object.orders != 0:
employee_collection.append(employee)
except SQLAlchemyError:
session.rollback()
error_message = 'Error while retrieving all employee rewards'
logger.warning("Employees.py Get - " + error_message)
return {'error_message': error_message}, 400
# CLOSE
session.close()
logger.warning(info)
if not employee_collection:
logger.warning(
"Get Employees - No employees that can receive rewards are in the system"
)
return {
'error message':
'No employees that can receive rewards are in the system'
}, 400
else:
return EmployeeResponse(employee_collection).to_dict()
def post(employee):
"""
:param employee:
:return:
1. check employee exists and grab it
2. add information to that employee
3. for each id in the array check for status from manufacturing
4. if low/medium increment
5. increment by 1.
"""
session = create_session()
try:
# Check if Employee exists
if not session.query(exists().where(
Employee.id == employee['employeeId'])).scalar():
error_message = 'This employee does not exist in the system yet. ' \
'Please use employees POST to add them as a new employee'
logger.warning("rewards.py POST - "
"The employee does not exist in the system")
return {'error_message': error_message}, 400
employee_object = session.query(Employee).get(employee['employeeId'])
if employee['replace']:
return {
'message':
'No rewards were counted for the employee {0}'.format(
employee['employeeId'])
}
else:
for serial_id in employee['serialIds']:
try:
phone_payload = requests.get(
"http://vm343b.se.rit.edu:5000/inventory/phones/{0}".
format(str(serial_id)))
phone = phone_payload.json()
except:
session.rollback()
error_message = 'Error while information from inventory with phone_serial_id: {0}'.format(
str(serial_id))
logger.warning(error_message)
return {'error_message': error_message}, 400
if phone[0]['fields']['modelId'] == 2 or phone[0]['fields'][
'modelId'] == 3:
employee_object.phones += +1
employee_object.orders += 1
except:
session.rollback()
error_message = 'Error while modifying employee base in rewards.py'
logger.warning("rewards.py employees POST - "
"Error while modifying the employee:")
return {'error_message': error_message}, 400
return_message = "Employee {0}'s count for phones has incremented now is {1} and now has {2} " \
"eligible orders".format(employee['employeeId'], employee_object.phones, employee_object.orders)
session.commit()
session.close()
return {'message': return_message}, 200
def patch(employee):
"""
:param employee:
:return:
"""
session = create_session()
try:
# Check if Employee exists
if not session.query(exists().where(Employee.id == employee['employee_id'])).scalar():
error_message = 'This employee does not exist in the system yet. ' \
'Please use POST to add them as a new employee'
logger.warning("Employees.py Patch - "
"The following employee does not exist in the system" +
"Employee Name: %s, Birth Date: %s, Start Date: %s." %
(employee['fname'] + ' ' + employee['lname'],
employee['birth_date'],
employee['start_date']))
return {'error_message': error_message}, 500
employee_object = session.query(Employee).get(employee['employee_id'])
old_employee = 'Employee ID: %s, Name: %s, Birth Date: %s, Start Date: %s,' \
' Active Status: %s' \
% (employee_object.id,
employee_object.first_name + ' ' + employee_object.last_name,
employee_object.birth_date,
employee_object.start_date,
employee_object.is_active)
new_employee = 'Employee ID: %s, Name: %s, Birth Date: %s, Start Date: %s,' \
' Active Status: %s' \
% (employee['employee_id'],
employee['fname'] + ' ' + employee['lname'],
datetime.strptime(employee['birth_date'], '%Y-%m-%d').date(),
datetime.strptime(employee['start_date'], '%Y-%m-%d').date(),
employee['is_active'])
# MODIFY EMPLOYEE
if 'is_active' in employee:
employee_object.is_active = employee['is_active']
if 'fname' in employee:
employee_object.first_name = employee['fname']
if 'lname' in employee:
employee_object.last_name = employee['lname']
if 'birth_date' in employee:
employee_object.birth_date = datetime.strptime(employee['birth_date'], '%Y-%m-%d').date()
if 'start_date' in employee:
employee_object.start_date = datetime.strptime(employee['start_date'], '%Y-%m-%d').date()
except SQLAlchemyError:
session.rollback()
error_message = 'Error while modifying employee base'
logger.warning("Employees.py Patch - "
"Error while modifying the following employee:" +
"Employee Name: %s, Birth Date: %s, Start Date: %s." %
(employee['fname'] + ' ' + employee['lname'],
employee['birth_date'],
employee['start_date']))
return {'error_message': error_message}, 500
# MODIFY USER
try:
if 'username' in employee:
employee_object.user.username = employee['username']
if 'password' in employee:
employee_object.user.password = employee['password']
except SQLAlchemyError:
session.rollback()
error_message = 'Error while modifying employee user security information'
logger.warning("Employees.py Patch - "
"Error while modifying the username and "
"password for the following employee:" +
"Employee Name: %s, Birth Date: %s, Start Date: %s." %
(employee['fname'] + ' ' + employee['lname'],
employee['birth_date'],
employee['start_date']))
return {'error_message': error_message}, 500
# MODIFY ADDRESS
address = ''
try:
if 'address' or 'address_start_date' in employee:
address_object = get_active_address(employee_object)
if 'address_start_date' in employee and 'address' not in employee:
address_object.start_date = datetime.strptime(employee['address_start_date'], '%Y-%m-%d').date()
elif 'address' in employee and 'address_start_date' not in employee:
address = validate_address(employee['address'])
address_object.is_active = False
now_date = datetime.strptime(str(datetime.now().year) + '-' +
str(datetime.now().month) + '-' +
str(datetime.now().day), '%Y-%m-%d').date()
session.add(Address(is_active=True, street_address=address['street_address'], city=address['city'],
state=address['state'], zip=address['zip'], employee=employee_object,
start_date=now_date))
elif 'address' in employee and 'address_start_date' in employee:
address = validate_address(employee['address'])
address_object.is_active = False
start_date = datetime.strptime(employee['address_start_date'], '%Y-%m-%d').date()
session.add(Address(is_active=True, street_address=address['street_address'], city=address['city'],
state=address['state'], zip=address['zip'], employee=employee_object,
start_date=start_date))
except SQLAlchemyError:
session.rollback()
error_message = 'Error while modifying employee address'
logger.warning("Employees.py Patch - "
"Error while modifying the address (%s) for the following employee:"
"Employee Name: %s, Birth Date: %s, Start Date: %s." %
(address,
employee['fname'] + ' ' + employee['lname'],
employee['birth_date'],
employee['start_date']))
return {'error_message': error_message}, 500
# MODIFY SALARY
salary_object = None
try:
salary_object = None
if 'salary' in employee:
salary_object = get_active_salary(employee_object)
salary_object.is_active = False
session.add(Salary(is_active=True, amount=employee['salary'], employee=employee_object))
except SQLAlchemyError:
session.rollback()
error_message = 'Error while modifying employee salary'
logger.warning("Employees.py Patch - "
"Error while modifying the salary (new salary: %s) "
"for the following employee: "
"Employee Name: %s, Birth Date: %s, Start Date: %s." %
(salary_object,
employee['fname'] + ' ' + employee['lname'],
employee['birth_date'],
employee['start_date']))
return {'error_message': error_message}, 500
# MODIFY TITLE
title_object = None
try:
if 'role' or 'role_start_date' in employee:
title_object = get_active_title(employee_object)
if 'role_start_date' in employee and 'role' not in employee:
title_object.start_date = datetime.strptime(employee['role_start_date'], '%Y-%m-%d').date()
elif 'role' in employee and 'role_start_date' not in employee:
title_object.is_active = False
now_date = datetime.strptime(str(datetime.now().year) + '-' +
str(datetime.now().month) + '-' +
str(datetime.now().day), '%Y-%m-%d').date()
session.add(Title(is_active=True, name=employee['role'], start_date=now_date,
employee=employee_object))
elif 'role' in employee and 'role_start_date' in employee:
title_object.is_active = False
start_date = datetime.strptime(employee['role_start_date'], '%Y-%m-%d').date()
session.add(Title(is_active=True, name=employee['role'], start_date=start_date,
employee=employee_object))
except SQLAlchemyError:
session.rollback()
error_message = 'Error while modifying employee role & title'
logger.warning("Emplyees.py Patch - "
"Error while modifying the title (%s) for the following employee: "
"Employee Name: %s, Birth Date: %s, Start Date: %s." %
(title_object,
employee['fname'] + ' ' + employee['lname'],
employee['birth_date'],
employee['start_date']))
return {'error_message': error_message}, 500
# MODIFY DEPARTMENT
department_object = None
try:
if 'department' or 'department_start_date' in employee:
department_object = get_active_department(employee_object)
if 'department_start_date' in employee and 'department' not in employee:
department_object.start_date = datetime.strptime(employee['department_start_date'], '%Y-%m-%d').date()
elif 'department' in employee and 'department_start_date' not in employee:
department_object.is_active = False
now_date = datetime.strptime(str(datetime.now().year) + '-' +
str(datetime.now().month) + '-' +
str(datetime.now().day), '%Y-%m-%d').date()
session.add(Department(is_active=True, name=employee['department'], start_date=now_date,
employee=employee_object))
elif 'department' in employee and 'department_start_date' in employee:
department_object.is_active = False
start_date = datetime.strptime(employee['department_start_date'], '%Y-%m-%d').date()
session.add(Department(is_active=True, name=employee['department'], start_date=start_date,
employee=employee_object))
except SQLAlchemyError:
session.rollback()
error_message = 'Error while modifying employee department & team'
logger.warning("Employees.py Patch - "
"Error while modifying the department (%s) for the following employee:"
"Employee Name: %s, Birth Date: %s, Start Date: %s." %
(department_object,
employee['fname'] + ' ' + employee['lname'],
employee['birth_date'],
employee['start_date']))
return {'error_message': error_message}, 500
# COMMIT & CLOSE
session.commit()
session.close()
logger.warning('Successfully modified an employee. Old information: '
+ old_employee + " New information: " + new_employee)
return {'Magic': 'Magic, for patching things? Bipity Bop! You are now a frog!'
'(Not really, but the following employee has been changed!)', 'new_employee': employee}, 200
def get(employee_id=None, static_flag=False):
""" This is the GET function that will return one or more employee objects within the system.
:param employee_id:
:param static_flag:
:return: a set of Employee Objects
"""
if static_flag:
logger.warning("Get Employees - Loading static file.")
scriptdir = '/'.join(os.path.dirname(os.path.abspath(__file__)).split('/')[:-2])
sp_file = os.path.join(scriptdir, 'static/dummy.txt')
obj = json.load(open(sp_file))
if employee_id is not None and employee_id[0] < 3:
return obj["employee_array"][employee_id[0]-1]
return obj["employee_array"]
session = create_session()
employee_collection = []
info = "Get Employees - Found the following employees - "
if employee_id is None:
try:
if not session.query(Employee).first():
session.rollback()
logger.warning("Get Employees - No employees exist in the system")
return {'error message': 'No employees exist in the system'}, 500
all_employee_objects = session.query(Employee).all()
for employee_object in all_employee_objects:
children = get_all_children_objects(employee_object)
employee = EmployeeApiModel(is_active=employee_object.is_active,
employee_id=employee_object.id,
name=employee_object.first_name + ' ' + employee_object.last_name,
birth_date=employee_object.birth_date,
address=children['address'].to_str(),
department=children['department'].to_str(),
role=children['title'].to_str(),
team_start_date=children['department'].start_date,
start_date=employee_object.start_date,
salary=children['salary'].to_str())
employee_collection.append(employee)
except SQLAlchemyError:
session.rollback()
error_message = 'Error while retrieving all employees'
logger.warning("Employees.py Get - " + error_message)
return {'error_message': error_message}, 500
else:
for e_id in employee_id:
try:
if not session.query(exists().where(Employee.id == e_id)).scalar():
session.rollback()
error_message = 'An employee with the id of %s does not exist' % e_id
logger.warning("Get Employees - " + error_message)
return {'error message': error_message}, 500
employee_object = session.query(Employee).get(e_id)
children = get_all_children_objects(employee_object)
employee = EmployeeApiModel(is_active=employee_object.is_active,
employee_id=employee_object.id,
name=employee_object.first_name + ' ' + employee_object.last_name,
birth_date=employee_object.birth_date,
address=children['address'].to_str(),
department=children['department'].to_str(),
role=children['title'].to_str(),
team_start_date=children['department'].start_date,
start_date=employee_object.start_date,
salary=children['salary'].to_str())
employee_collection.append(employee)
info += "Employee ID: %s, Name: %s, Birth date: %s, Department: %s, Role: %s " % \
(employee_object.id,
employee_object.first_name + ' ' + employee_object.last_name,
employee_object.birth_date,
children['department'].to_str(),
children['title'].to_str())
except SQLAlchemyError:
session.rollback()
error_message = 'Error while retrieving employee %s' % employee_id
logger.warning("Employees.py Get - " + error_message)
return {'error_message': error_message}, 500
# CLOSE
session.close()
logger.warning(info)
return EmployeeResponse(employee_collection).to_dict()
def post(employee):
"""
:param employee:
:return:
"""
session = create_session()
# ADD EMPLOYEE
try:
# Check if Employee Already exists
if session.query(exists().where(and_(
Employee.first_name == employee['fname'],
Employee.last_name == employee['lname'],
Employee.birth_date == datetime.strptime(employee['birth_date'], '%Y-%m-%d').date(),
Employee.start_date == datetime.strptime(employee['start_date'], '%Y-%m-%d').date()))).scalar():
session.rollback()
logger.warning("The following employee was attempted to add with POST but already exists. "
"Please use PATCH to modify the employee's data or enter a new employee. "
"A new employee has a unique first name, last name, birth date, and start date. "
"Employee Name: %s, Birth Date: %s, Start Date: %s." %
(employee['fname'] + ' ' + employee['lname'],
employee['birth_date'],
employee['start_date']))
return {'error_message':
'This employee already exists in the system. Please use PATCH to modify them or enter a new '
'employee. A new employee has a unique first name, last name, birth date, and start date'}, 500
birthday = datetime.strptime(employee['birth_date'], '%Y-%m-%d').date() # e.g. 1993-12-17
start_date = datetime.strptime(employee['start_date'], '%Y-%m-%d').date() # e.g. 2017-03-28
new_employee = Employee(is_active=employee['is_active'], first_name=employee['fname'],
last_name=employee['lname'], birth_date=birthday, start_date=start_date)
session.add(new_employee)
except SQLAlchemyError:
session.rollback()
error_message = 'Error while importing employee base'
logger.warning("Employees.py Post - " + error_message +
". Unable to add the following employee: "
"Employee Name: %s, Birth Date: %s, Start Date: %s." %
(employee['fname'] + ' ' + employee['lname'],
employee['birth_date'],
employee['start_date']))
return {'error_message': error_message}, 500
# ADD USER
try:
session.add(User(username='******', password='******', employee=new_employee))
except SQLAlchemyError:
session.rollback()
error_message = 'Error while importing employee user security information'
logger.warning("Employees.py Post - " + error_message+
". Unable to add security information for the following employee: "
"Employee Name: %s, Birth Date: %s, Start Date: %s." %
(employee['fname'] + ' ' + employee['lname'],
employee['birth_date'],
employee['start_date']))
return {'error_message': error_message}, 500
# ADD ADDRESS
# Use regex to check that the format is "0200 StreetAddress St., City, State 11111"
try:
address = validate_address(employee['address'])
address_date = datetime.strptime(employee['start_date'], '%Y-%m-%d').date() # e.g. 2017-03-28
session.add(Address(is_active=True, street_address=address['street_address'], city=address['city'],
state=address['state'], zip=address['zip'], start_date=address_date, employee=new_employee))
except SQLAlchemyError:
session.rollback()
error_message = 'Error while importing employee address'
logger.warning("Employees.py Post - " + error_message+
". Unable to add the address for the following employee: "
"Employee Name: %s, Birth Date: %s, Start Date: %s." %
(employee['fname'] + ' ' + employee['lname'],
employee['birth_date'],
employee['start_date']))
return {'error_message': error_message}, 500
# ADD DEPARTMENT
try:
department_start_date = datetime.strptime(employee['start_date'], '%Y-%m-%d').date() # e.g. 2017-03-28
session.add(Department(is_active=True, start_date=department_start_date, name=employee['department'],
employee=new_employee))
except SQLAlchemyError:
session.rollback()
error_message = 'Error while importing employee department'
logger.warning("Employees.py Post - " + error_message+
". Unable to add the department and role for the following employee: "
"Employee Name: %s, Birth Date: %s, Start Date: %s." %
(employee['fname'] + ' ' + employee['lname'],
employee['birth_date'],
employee['start_date']))
return {'error_message': error_message}, 500
# ADD TITLE
# Note: This should be the same as the team_start_date for POST'ing a new employee
try:
session.add(Title(is_active=True, name=employee['role'], start_date=department_start_date,
employee=new_employee))
except SQLAlchemyError:
session.rollback()
error_message = 'Error while importing employee title'
logger.warning("Employees.py Post - " + error_message+
". Unable to add the position title for the following employee: "
"Employee Name: %s, Birth Date: %s, Start Date: %s." %
(employee['fname'] + ' ' + employee['lname'],
employee['birth_date'],
employee['start_date']))
return {'error_message': error_message}, 500
# ADD SALARY
try:
session.add(Salary(is_active=True, amount=randrange(50000, 100000, 1000), employee=new_employee))
except SQLAlchemyError:
session.rollback()
error_message = 'Error while importing employee salary'
logger.warning("Employees.py Post - " + error_message +
". Unable to add the salary for the following employee: "
"Employee Name: %s, Birth Date: %s, Start Date: %s." %
(employee['fname'] + ' ' + employee['lname'],
employee['birth_date'],
employee['start_date']))
return {'error_message': error_message}, 500
# COMMIT & CLOSE
session.commit()
session.close()
return {'Magic': 'Yes, actually magic #POST', 'employee': employee}, 200
def patch(employee, session=None):
"""
:param employee:
:return:
"""
if session is None:
session = create_session()
try:
# Check if Employee exists
if not session.query(exists().where(Employee.id == employee['employee_id'])).scalar():
error_message = 'This employee does not exist in the system yet. ' \
'Please use POST to add them as a new employee'
logger.warning("Employees.py Patch - "
"The following employee does not exist in the system" +
"Employee ID: {0}.".format(employee['employee_id']))
return {'error_message': error_message}, 400
employee_object = session.query(Employee).get(employee['employee_id'])
old_employee = 'Employee ID: %s, Name: %s, Birth Date: %s, Start Date: %s,' \
' Email: %s, Active Status: %s' \
% (employee_object.id,
employee_object.first_name + ' ' + employee_object.last_name,
employee_object.birth_date,
employee_object.start_date,
employee_object.email,
employee_object.is_active)
# MODIFY EMPLOYEE
if 'is_active' in employee:
employee_object.is_active = employee['is_active']
if 'fname' in employee:
employee_object.first_name = employee['fname']
if 'lname' in employee:
employee_object.last_name = employee['lname']
if 'email' in employee:
employee_object.email = employee['email']
if 'birth_date' in employee:
employee_object.birth_date = datetime.strptime(employee['birth_date'], '%Y-%m-%d').date()
if 'start_date' in employee:
employee_object.start_date = datetime.strptime(employee['start_date'], '%Y-%m-%d').date()
except SQLAlchemyError:
session.rollback()
error_message = 'Error while modifying employee base'
logger.warning("Employees.py Patch - "
"Error while modifying the employee %s", employee['employee_id'])
return {'error_message': error_message}, 400
# MODIFY ADDRESS
try:
if 'address' or 'address_start_date' in employee:
address_object = get_active_address(employee_object)
if 'address_start_date' in employee and 'address' not in employee:
address_object.start_date = datetime.strptime(employee['address_start_date'], '%Y-%m-%d').date()
elif 'address' in employee and 'address_start_date' not in employee:
address = validate_address(employee['address'])
address_object.is_active = False
now_date = datetime.strptime(str(datetime.now().year) + '-' +
str(datetime.now().month) + '-' +
str(datetime.now().day), '%Y-%m-%d').date()
session.add(Address(is_active=True, street_address=address['street_address'], city=address['city'],
state=address['state'], zip=address['zip'], employee=employee_object,
start_date=now_date))
elif 'address' in employee and 'address_start_date' in employee:
address = validate_address(employee['address'])
address_object.is_active = False
start_date = datetime.strptime(employee['address_start_date'], '%Y-%m-%d').date()
session.add(Address(is_active=True, street_address=address['street_address'], city=address['city'],
state=address['state'], zip=address['zip'], employee=employee_object,
start_date=start_date))
except SQLAlchemyError:
session.rollback()
error_message = 'Error while modifying employee address'
logger.warning("Employees.py Patch - "
"Error while modifying the address for the employee %s", employee['employee_id'])
return {'error_message': error_message}, 400
# MODIFY SALARY
try:
if 'salary' in employee:
salary_object = get_active_salary(employee_object)
salary_object.is_active = False
session.add(Salary(is_active=True, amount=employee['salary'], employee=employee_object))
except SQLAlchemyError:
session.rollback()
error_message = 'Error while modifying employee salary'
logger.warning("Employees.py Patch - "
"Error while modifying the salary for the employee %s", employee['employee_id'])
return {'error_message': error_message}, 400
# MODIFY TITLE
try:
if 'role' or 'role_start_date' in employee:
title_object = get_active_title(employee_object)
if 'role_start_date' in employee and 'role' not in employee:
title_object.start_date = datetime.strptime(employee['role_start_date'], '%Y-%m-%d').date()
elif 'role' in employee and 'role_start_date' not in employee:
title_object.is_active = False
now_date = datetime.strptime(str(datetime.now().year) + '-' +
str(datetime.now().month) + '-' +
str(datetime.now().day), '%Y-%m-%d').date()
session.add(Title(is_active=True, name=employee['role'], start_date=now_date,
employee=employee_object))
elif 'role' in employee and 'role_start_date' in employee:
title_object.is_active = False
start_date = datetime.strptime(employee['role_start_date'], '%Y-%m-%d').date()
session.add(Title(is_active=True, name=employee['role'], start_date=start_date,
employee=employee_object))
except SQLAlchemyError:
session.rollback()
error_message = 'Error while modifying employee role & title'
logger.warning("Emplyees.py Patch - "
"Error while modifying the role/title for the employee %s", employee['employee_id'])
return {'error_message': error_message}, 400
# MODIFY DEPARTMENT
try:
if 'department' or 'department_start_date' in employee:
department_object = get_active_department(employee_object)
if 'department_start_date' in employee and 'department' not in employee:
department_object.start_date = datetime.strptime(employee['department_start_date'], '%Y-%m-%d').date()
elif 'department' in employee and 'department_start_date' not in employee:
department_object.is_active = False
now_date = datetime.strptime(str(datetime.now().year) + '-' +
str(datetime.now().month) + '-' +
str(datetime.now().day), '%Y-%m-%d').date()
session.add(Department(is_active=True, name=employee['department'], start_date=now_date,
employee=employee_object))
elif 'department' in employee and 'department_start_date' in employee:
department_object.is_active = False
start_date = datetime.strptime(employee['department_start_date'], '%Y-%m-%d').date()
session.add(Department(is_active=True, name=employee['department'], start_date=start_date,
employee=employee_object))
except SQLAlchemyError:
session.rollback()
error_message = 'Error while modifying employee department & team'
logger.warning("Employees.py Patch - "
"Error while modifying the department for the employee %s", employee['employee_id'])
return {'error_message': error_message}, 400
new_employee = 'Employee ID: %s, Name: %s, Birth Date: %s, Start Date: %s,' \
' Email: %s, Active Status: %s' \
% (employee_object.id,
employee_object.first_name + ' ' + employee_object.last_name,
employee_object.birth_date,
employee_object.start_date,
employee_object.email,
employee_object.is_active)
# COMMIT & CLOSE
session.commit()
session.close()
logger.warning('Successfully modified an employee. Old information: '
+ old_employee + " New information: " + new_employee)
return {'new_employee': employee}, 200