def update(self, department):
session.query(Departments).filter(
Departments.dept_no == department['dept_no']).update(
{Departments.dept_name: department['dept_name']},
synchronize_session=False)
session.commit()
return department
def update(self, employee):
session.query(Employees).filter(
Employees.emp_no == employee['emp_no']).update(
{
Employees.first_name: employee['first_name'],
Employees.last_name: employee['last_name'],
Employees.dept_no: employee['dept_no'],
Employees.birth_date: employee['birth_date'],
Employees.hire_date: employee['hire_date']
},
synchronize_session=False)
session.commit()
return employee
def getAll(self):
results = session.query(Departments).all()
returnArray = []
for result in results:
resultAsDict = self.to_dict(result)
returnArray.append(resultAsDict)
return returnArray
def delete(self, emp_no):
session.query(Departments).filter(
Departments.dept_no == emp_no).delete()
session.commit()
def findByNo(self, dept_no):
results = session.query(Departments).filter(
Departments.dept_no == dept_no).all()
for result in results:
dept = self.to_dict(result)
return dept
def delete(self, emp_no):
session.query(Employees).filter(Employees.emp_no == emp_no).delete()
session.commit()
def findByNo(self, emp_no):
results = session.query(Employees).filter(
Employees.emp_no == emp_no).all()
for result in results:
emp = self.to_dict(result)
return emp