def create_employee(cursor, row): _row = sqlite3.Row(cursor, row) employee = Employee() employee.id = _row['id'] employee.first_name = _row['first_name'] employee.last_name = _row['last_name'] employee.dept_name = _row['dept_name'] if _row['model'] is not None: employee.computer = _row['manufacturer'] + ' ' + _row['model'] else: employee.computer = "Not Assigned" employee.start_date = _row['start_date'] employee.is_supervisor = _row['is_supervisor'] if _row["training"] is not None: employee.training = _row["training"] else: employee.training = "Not Assigned" employee.trainings = [] return (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 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 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 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, d.department, e.department_id 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_thing = row['department'] 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'], False, form_data['department'])) return redirect(reverse('hrapp:employee_list'))
def get_department(department_name): with sqlite3.connect(Connection.db_path) as conn: conn.row_factory = sqlite3.Row db_cursor = conn.cursor() db_cursor.execute( """ SELECT d.name, d.budget, e.first_name, e.last_name, e.is_supervisor FROM hrapp_department AS d LEFT JOIN hrapp_employee AS e ON e.department_id = d.id WHERE d.name = ? """, (department_name, )) response = db_cursor.fetchall() for row in response: if row == response[0]: department = Department() department.employees = [] department.name = row['name'] department.budget = row['budget'] if not row['first_name'] == None: employee = Employee() employee.first_name = row['first_name'] employee.last_name = row['last_name'] employee.is_supervisor = row['is_supervisor'] department.employees.append(employee) else: employee = Employee() employee.first_name = row['first_name'] employee.last_name = row['last_name'] employee.is_supervisor = row['is_supervisor'] department.employees.append(employee) print(department.employees) 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"] 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_department(cursor, row): _row = sqlite3.Row(cursor, row) department = Department() department.id = _row["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_id = _row["department_id_id"] employee.is_supervisor = _row["is_supervisor"] # 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 employee_list(request): if request.method == 'GET': with sqlite3.connect( "/Users/joeshep/workspace/python/bangazon-workforce-boilerplate/bangazonworkforcemgt/db.sqlite3" ) 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 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 = row['department'] 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() db_cursor.execute(""" SELECT e.id, e.first_name, e.last_name, e.start_date, e.is_supervisor, d.name FROM hrapp_employee e JOIN hrapp_department d ON e.department_id = d.id ORDER BY e.first_name """) 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_name = row['name'] all_employees.append(employee) db_cursor.execute(""" select d.id, d.name from hrapp_department d """) all_departments = db_cursor.fetchall() template = 'employees/employees_list.html' context = { 'employees': all_employees, 'all_departments': all_departments } 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_list'))