def buscar_por_id(self, id): comando_sql_buscar_id = f"""SELECT s.nome, bd.nome, bd.id, f.nome, f.id, l.nome, l.id, s.id FROM squads as s JOIN banco as bd ON s.fk_bd = bd.id JOIN framework as f ON s.fk_framework = f.id JOIN linguagens as l ON s.fk_linguagem = l.id WHERE s.id = {id}""" l = super().buscar_por_id(comando_sql_buscar_id) bd = BD(l[1], l[2]) frame = Framework(l[3], l[4]) ling = Linguagem(l[5], l[6]) squad = HB(l[0], bd.__dict__(), frame.__dict__(), ling.__dict__(), l[7]) return squad.__dict__()
def listar(self, id=None): lista_squad = [] comando_sql_listar = """SELECT s.nome, bd.nome, bd.id, f.nome, f.id, l.nome, l.id, s.id FROM squads as s JOIN banco as bd ON s.fk_bd = bd.id JOIN framework as f ON s.fk_framework = f.id JOIN linguagens as l ON s.fk_linguagem = l.id""" tupla_cads = super().listar(comando_sql_listar) for l in tupla_cads: bd = BD(l[1], l[2]) frame = Framework(l[3], l[4]) ling = Linguagem(l[5], l[6]) squad = HB(l[0], bd.__dict__(), frame.__dict__(), ling.__dict__(), l[4]) lista_squad.append(squad.__dict__()) return lista_squad