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)
