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_list_employees(cursor, row): _row = sqlite3.Row(cursor, row) department = Department() department.id = _row["id"] department.name = _row["name"] department.budget = _row["budget"] department.employees = [] employee = Employee() employee.department_id = _row["department_id"] employee.first_name = _row["first_name"] employee.last_name = _row["last_name"] department_employees = {} for (department, employee) in department: if department.id not in department_employees: department_employees[department.id] = department department_employees[department.id].employees.append(employee) else: department_employees[department.id].employees.append(employee) return ( department, employee, )
def get_employee(employee_id): with sqlite3.connect(Connection.db_path) as conn: db_cursor = conn.cursor() db_cursor.execute( """ SELECT e.id, e.first_name, e.last_name, e.start_date, e.is_supervisor, d.id, d.name FROM hrapp_employee AS e JOIN hrapp_department AS d ON e.department_id = d.Id WHERE e.id = ? """, (employee_id, )) response = db_cursor.fetchone() print(response) employee = Employee() employee.id = response[0] employee.first_name = response[1] employee.last_name = response[2] employee.start_date = response[3] employee.is_supervisor = response[4] employee.department_id = response[5] employee.department_name = response[6] 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.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 get_employees(employee_id): with sqlite3.connect(Connection.db_path) as conn: conn.row_factory = sqlite3.Row db_cursor = conn.cursor() db_cursor.execute(""" select e.id employee_id, e.first_name, e.last_name, e.start_date, e.is_supervisor, e.department_id from hrapp_employee e WHERE e.id = ? """, (employee_id,)) row = db_cursor.fetchall() print('thee dataset', row) employee = Employee() employee.id = row[0]['employee_id'] employee.first_name = row[0]['first_name'] employee.last_name = row[0]['last_name'] employee.start_date = row[0]['start_date'] employee.is_supervisor = row[0]['is_supervisor'] employee.department_id = row[0]['department_id'] return employee
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() db_cursor.execute(""" SELECT e.id, e.first_name, e.last_name, e.start_date, e.is_supervisor, e.department_id FROM hrapp_employee e """) 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'] employee.department_id = row['department_id'] all_employees.append(employee) template = 'employees/employees_list.html' context = {'employees': all_employees} return render(request, template, context)
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, e.department_id, d.name FROM hrapp_employee e JOIN hrapp_department d ON e.department_id = d.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'] employee.department_id = row['department_id'] employee.department.name = row['name'] all_employees.append(employee) template = 'employees/employees_list.html' context = {'all_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, is_supervisor, department_id ) VALUES (?, ?, ?, ?, ?) """, (form_data['first_name'], form_data['last_name'], form_data['start_date'], form_data['is_supervisor'], form_data['department_id'])) return redirect(reverse('hrapp:employee'))
def create_department(cursor, row): _row = sqlite3.Row(cursor, row) department = Department() department.id = _row["id"] department.name = _row["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"] employee.department_id = _row["department_id"] return (department, employee)
def all_departments(department_id): with sqlite3.connect(Connection.db_path) as conn: conn.row_factory = sqlite3.Row db_cursor = conn.cursor() db_cursor.execute( """ SELECT d.id, d.dept_name, d.budget, e.id, e.first_name, e.last_name, e.department_id FROM hrapp_department d LEFT JOIN hrapp_employee e ON d.id = e.department_id where d.id = ? """, (department_id, )) data = db_cursor.fetchall() department_list = [] employee_list = [] for row in data: if (len(department_list) == 0): department = Department() department.id = row['department_id'] department.name = row['dept_name'] department.budget = row['budget'] department_list.append(department) employee = Employee() employee.id = row['id'] employee.first_name = row['first_name'] employee.last_name = row['last_name'] employee.department_id = row['department_id'] employee_list.append(employee) department_obj = {} department_obj["department"] = department_list[0] department_obj["employees"] = employee_list return department_obj
def create_departmant(cursor, row): _row = sqlite3.Row(cursor, row) department = Department() department.id = _row['id'] department.department_name = _row['department_name'] department.department_budget = _row['department_budget'] department.employees = [] 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"] employee.department_id = _row["department_id"] return ( department, employee, )