def consultar(id):
with closing(con()) as connection, closing(connection.cursor()) as cursor:
cursor.execute(f"SELECT * FROM {model_name} WHERE id = ?", (int(id), ))
row = cursor.fetchone()
if row == None:
return None
return Professor.criar({"id": row[0], "nome": row[1]})
def consultar_por_nome(nome):
with closing(con()) as connection, closing(connection.cursor()) as cursor:
cursor.execute(f"SELECT id, nome, rg FROM {model_name} WHERE nome = ?", (nome,))
row = cursor.fetchone()
if row == None:
return None
return Professor.criar_com_id(row[0],row[1],row[2])
def criar(id, nome):
if localizar(id) != None:
raise ProfessorJaExiste()
log = Log(None)
criado = Professor(id, nome)
professores_db.append(criado)
log.finalizar(criado)
return criado
def listar():
with closing(con()) as connection, closing(connection.cursor()) as cursor:
cursor.execute(f"SELECT * FROM {model_name}")
rows = cursor.fetchall()
registros = []
for (id, nome) in rows:
registros.append(Professor.criar({"id": id, "nome": nome}))
return registros
def cria(id, nome):
if localizar(id) != None:
raise ProfessorJaExiste()
log = Log(None)
criado = Professor(id, nome)
criar_dao(criado)
log.finalizar(criado)
return listar()
def listar():
with closing(con()) as connection, closing(connection.cursor()) as cursor:
cursor.execute(f"SELECT id, nome, rg FROM {model_name}")
rows = cursor.fetchall()
registros = []
for (id, nome, rg) in rows:
professor = Professor.criar_com_id(id, nome, rg)
if professor != None:
registros.append(professor)
return registros
def remover(id):
dados_professor = localizar(id)
if dados_professor == None:
return 0
dao_remover(Professor.criar(dados_professor))
return 1
if localizar(id) == None:
return 0
dao_remover(id)
return 1
def atualizar(professor_data):
if localizar_por_nome(professor_data['nome']) != None:
professor = Professor.criar(professor_data)
dao_alterar(professor)
return localizar(professor.id)
return None
def criar(professor_data):
if localizar_por_nome(professor_data['nome']) == None:
professor = Professor.criar(professor_data)
return dao_cadastrar(professor).__dict__()
return None
def localizar(id):
cursor.execute(sql_localizar, (id, ))
linha = cursor.fetchone()
if linha == None:
return None
return Professor(linha[0], linha[1])
def listar():
cursor.execute(sql_listar)
resultado = []
for id, nome in cursor.fetchall():
resultado.append(Professor(id, nome))
return resultado
def atualizar(id, nome):
professor = Professor.criar({"id": id, "nome": nome})
dao_alterar(professor)
return localizar(id)
def criar(professor_data):
if localizar(professor_data['id']) == None:
professor = Professor.criar(professor_data)
return dao_cadastrar(professor)
return None
def __init__(self):
self.students = {}
#add to student dictionary
s = Student(1, "Carson", "Alexander", "09012005")
self.students[s.student_id] = s
s = Student(2, "Meredith", "Alonso", "09022002")
self.students[s.student_id] = s
s = Student(3, "Arturo", "Anand", "09032003")
self.students[s.student_id] = s
s = Student(4, "Gytis", "Barzdukas", "09012001")
self.students[s.student_id] = s
s = Student(5, "Peggy", "Justice", "09012001")
self.students[s.student_id] = s
s = Student(6, "Laura", "Norman", "09012003")
self.students[s.student_id] = s
s = Student(7, "Nino", "Olivetto", "09012005")
self.students[s.student_id] = s
self.professors = {}
#professor_id first_name last_name hire_date
p = Professor(1, "Kim", "Abercrombie", "1995-03-11")
self.professors[p.professor_id] = p
p = Professor(2, "Fadi", "Fakhouri", "2002-07-06")
self.professors[p.professor_id] = p
p = Professor(3, "Roger", "Harui", "1998-07-01")
self.professors[p.professor_id] = p
p = Professor(4, "Candace", "Kapoor", "2001-01-15")
self.professors[p.professor_id] = p
p = Professor(5, "Roger", "Zheng", "2004-02-12")
self.professors[p.professor_id] = p
self.courses = {}
#add to course dictionary
c = Course(1050, "Chemistry", 3, self.professors[1])
self.courses[c.course_id] = c
c = Course(4022, "Microeconomics", 3, self.professors[3])
self.courses[c.course_id] = c
c = Course(4041, "Macroeconomics", 3, self.professors[3])
self.courses[c.course_id] = c
c = Course(1045, "Calculus", 4, self.professors[4])
self.courses[c.course_id] = c
c = Course(3141, "Trigonometry", 4, self.professors[4])
self.courses[c.course_id] = c
c = Course(2021, "Composition", 3, self.professors[2])
self.courses[c.course_id] = c
c = Course(2042, "Literature", 4, self.professors[5])
self.courses[c.course_id] = c
self.enrollments = {}
#add enrolled students into courses
enroll_id = 11050 #combine student id + chemistry id
enrollment = Enrollment(enroll_id, self.students[1],
self.courses[1050])
self.enrollments[enroll_id] = enrollment
enroll_id = 14022 #combine student id + chemistry id
enrollment = Enrollment(enroll_id, self.students[1],
self.courses[4022])
self.enrollments[enroll_id] = enrollment
enroll_id = 14041 #combine student id + chemistry id
enrollment = Enrollment(enroll_id, self.students[1],
self.courses[4041])
self.enrollments[enroll_id] = enrollment
enroll_id = 21045 #combine student id + chemistry id
enrollment = Enrollment(enroll_id, self.students[2],
self.courses[1045])
self.enrollments[enroll_id] = enrollment
enroll_id = 23141 #combine student id + chemistry id
enrollment = Enrollment(enroll_id, self.students[2],
self.courses[3141])
self.enrollments[enroll_id] = enrollment
enroll_id = 22021 #combine student id + chemistry id
enrollment = Enrollment(enroll_id, self.students[2],
self.courses[4041])
self.enrollments[enroll_id] = enrollment
enroll_id = 31050 #combine student id + chemistry id
enrollment = Enrollment(enroll_id, self.students[3],
self.courses[1050])
self.enrollments[enroll_id] = enrollment
enroll_id = 41050 #combine student id + chemistry id
enrollment = Enrollment(enroll_id, self.students[4],
self.courses[1050])
self.enrollments[enroll_id] = enrollment
enroll_id = 44022 #combine student id + chemistry id
enrollment = Enrollment(enroll_id, self.students[4],
self.courses[4022])
self.enrollments[enroll_id] = enrollment
enroll_id = 54041 #combine student id + chemistry id
enrollment = Enrollment(enroll_id, self.students[5],
self.courses[2021])
self.enrollments[enroll_id] = enrollment
enroll_id = 61045 #combine student id + chemistry id
enrollment = Enrollment(enroll_id, self.students[6],
self.courses[1045])
self.enrollments[enroll_id] = enrollment
enroll_id = 73141 #combine student id + chemistry id
enrollment = Enrollment(enroll_id, self.students[7],
self.courses[3141])
self.enrollments[enroll_id] = enrollment