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,)
import sqlite3
from django.urls import reverse
from django.shortcuts import render, redirect
from django.contrib.auth.decorators import login_required
from hrapp.models import Employee, Computer, TrainingProgram, Department
from ..connection import Connection
from datetime import date
employee = Employee()
employee.computers = []
employee.training_programs = []
def create_employee(cursor, row):
_row = sqlite3.Row(cursor, row)
employee.id = _row["employee_id"]
employee.first_name = _row["first_name"]
employee.last_name = _row["last_name"]
return employee
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
