def consultar_por_nome(nome): with closing(con()) as connection, closing(connection.cursor()) as cursor: cursor.execute(f"SELECT id, nome, matricula FROM {model_name} WHERE nome = ?", (nome,)) row = cursor.fetchone() if row == None: return None return Aluno.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, matricula FROM {model_name}") rows = cursor.fetchall() registros = [] for (id, nome, matricula) in rows: aluno = Aluno.criar_com_id(id, nome, matricula) if aluno != None: registros.append(aluno) return registros