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