def create_department(cursor, row): _row = sqlite3.Row(cursor, row) department = Department() department.id = _row["department_id"] department.dept_name = _row["dept_name"] department.budget = _row["budget"] # Note: You are adding a blank employees list to the department object # This list will be populated later (see below) department.employees = [] employee = Employee() employee.id = _row["employee_id"] employee.first_name = _row["first_name"] employee.Last_name = _row["last_name"] employee.department_id = _row["department_id"] # Return a tuple containing the department and the # employee built from the data in the current row of # the data set return ( department, employee, )
def create_employee(cursor, row): _row = sqlite3.Row(cursor, row) employee = Employee() employee.id = _row["employee_id"] employee.first_name = _row["first_name"] employee.last_name = _row["last_name"] employee.start_date = _row["start_date"] employee.department_id = _row["department_id"] employee.is_supervisor = _row["is_supervisor"] department = Department() department.id = _row["department_id"] department.dept_name = _row["dept_name"] computer = Computer() computer.manufacturer = _row["manufacturer"] computer.make = _row["make"] computer.id = _row["computer_id"] # training_program = TrainingProgram() # training_program.title = _row["title"] employee.department = department employee.computer = computer # employee.training_program = training_program return employee
def create_employee(cursor, row): _row = sqlite3.Row(cursor, row) employee = Employee() employee.id = _row['employee_id'] employee.first_name = _row['first_name'] employee.last_name = _row['last_name'] employee.start_date = _row['start_date'] employee.is_supervisor = _row['is_supervisor'] employee.department_id = _row['department_id'] department = Department() department.dept_name = _row['dept_name'] department.id = _row['department_id'] computer = Computer() computer.make = _row['computer_make'] computer.id = _row['computer_id'] employee.employeecomputer_id = _row['employeecomputer_id'] employee.employee_computer_id = _row['employee_computer_id'] employee.training_programs = [] training_program = Training_program() training_program.name = _row['training_program_name'] training_program.id = _row['training_program_id'] return (employee, training_program,)
def create_employee_with_department(cursor, row): _row = sqlite3.Row(cursor, row) department = Department() department.id = _row["dept_id"] department.dept_name = _row["dept_name"] employee.department = department return department
def create_department(cursor, row): _row = sqlite3.Row(cursor, row) department = Department() department.id = _row["id"] department.dept_name = _row["dept_name"] department.budget = _row["budget"] return department
def employee_list(request): if request.method == 'GET': with sqlite3.connect(Connection.db_path) as conn: conn.row_factory = sqlite3.Row db_cursor = conn.cursor() # TODO: Add to query: e.department, db_cursor.execute(""" SELECT e.id, e.first_name, e.last_name, e.start_date, e.is_supervisor, d.dept_name FROM hrapp_employee e LEFT JOIN hrapp_department d ON d.id = e.department_id """) all_employees = [] dataset = db_cursor.fetchall() for row in dataset: employee = Employee() employee.id = row['id'] employee.first_name = row['first_name'] employee.last_name = row['last_name'] employee.start_date = row['start_date'] employee.is_supervisor = row['is_supervisor'] department = Department() department.dept_name = row['dept_name'] employee.department = department all_employees.append(employee) template = 'employees/employees_list.html' context = {'employees': all_employees} return render(request, template, context) elif request.method == 'POST': form_data = request.POST with sqlite3.connect(Connection.db_path) as conn: db_cursor = conn.cursor() db_cursor.execute( """ INSERT INTO hrapp_employee (first_name, last_name, start_date, department_id, is_supervisor) VALUES (?, ?, ?, ?, 0) """, (form_data['first_name'], form_data['last_name'], form_data['start_date'], form_data['department'])) return redirect(reverse('hrapp:employees'))
def create_department(cursor, row): _row = sqlite3.Row(cursor, row) department = Department() department.id = _row["id"] department.dept_name = _row["dept_name"] department.budget = _row["budget"] department.employees = [] employee = Employee() employee.first_name = _row["first_name"] employee.last_name = _row["last_name"] employee.is_supervisor = _row["is_supervisor"] employee.start_date = _row["start_date"] return (department, employee,)
def create_employee_list(cursor, row): _row = sqlite3.Row(cursor, row) department = Department() department.id = _row["id"] department.dept_name = _row["dept_name"] department.budget = _row["budget"] department.employees = [] employee = Employee() employee.id = _row["id"] employee.first_name = _row["first_name"] employee.last_name = _row["last_name"] return ( department, employee, )
def employee_form(request): if request.method == 'GET': with sqlite3.connect(Connection.db_path) as conn: conn.row_factory = sqlite3.Row db_cursor = conn.cursor() # TODO: Add to query: e.department, db_cursor.execute(""" select id, dept_name from hrapp_department """) all_departments = [] dataset = db_cursor.fetchall() for row in dataset: department = Department() department.id = row['id'] department.dept_name = row['dept_name'] all_departments.append(department) template = 'employees/form.html' context = {'all_departments': all_departments} return render(request, template, context)