def consultar_por_nome(nome):
with closing(con()) as connection, closing(connection.cursor()) as cursor:
cursor.execute(
f"SELECT id, nome, id_professor FROM {model_name} WHERE nome = ?",
(nome, ))
row = cursor.fetchone()
if row == None:
return None
return Disciplina.criar_com_id(row[0], row[1], row[2])
def consultar_alunos(disciplina):
with closing(con()) as connection, closing(connection.cursor()) as cursor:
cursor.execute(
f"SELECT id, disciplina_id, aluno_id FROM {model_name} WHERE nome = ?",
(disciplina, ))
row = cursor.fetchone()
if row == None:
return None
return Disciplina.criar_com_id(row[0], row[1], row[2])
def listar():
with closing(con()) as connection, closing(connection.cursor()) as cursor:
cursor.execute(f"SELECT id, nome, id_professor FROM {model_name}")
rows = cursor.fetchall()
registros = []
for (id, nome, id_professor) in rows:
disciplina = Disciplina.criar_com_id(id, nome, id_professor)
if disciplina != None:
registros.append(disciplina)
return registros