def AddJob(self, **kargs): session = db.get_orm_session('default') Jobs = Job() #import pdb; pdb.set_trace() Jobs.job_id = kargs['job_id'] Jobs.job_title = kargs['job_title'] Jobs.min_salary= kargs['min_salary'] Jobs.max_salary= kargs['max_salary'] session.add(Jobs) session.commit()
def AddEmployee(self, **kargs): session = db.get_orm_session('default') Employee = Employee() Employee.Employee_Id = kargs['employee_id'] Employee.First_Name = kargs['first_name'] Employee.Last_Name = kargs['last_name'] Employee.Email = kargs['email'] Employee.Phone_Number = kargs['phone_number'] Employee.Hire_Date = kargs['hire_date'] Employee.Job_Id = kargs['job_id'] Employee.Salary = kargs['salary'] Employee.Manager_Id = kargs['manager_id'] Employee.Department_Id = kargs['department_id'] session.add(Employee) session.commit()
def GetJobList(self): session = db.get_orm_session('default') result_list = session.query(Job).all() #import pdb; pdb.set_trace() return result_list
def GetJob(self , job_id): session = db.get_orm_session('default') result_list = session.query(Job).filter(Job.job_id == job_id ).first() #import pdb;pdb.set_trace() return result_list