def listar_todos(self): lista_squads = [] lista_tuplas_squads = self.squad_dao.listar_todos() for s in lista_tuplas_squads: s1 = Squad() s1.id = s[0] s1.nome = s[1] s1.descricao = s[2] s1.numpessoas = s[3] lista_tuplas_backend = self.backend_dao.buscar_por_squad(s1.id) i = 0 for b in range(len(lista_tuplas_backend)): if lista_tuplas_backend[i][0] != None: s1.backend.append(lista_tuplas_backend[i][0]) i += 1 lista_tuplas_frontend = self.frontend_dao.buscar_por_squad(s1.id) i = 0 for f in range(len(lista_tuplas_frontend)): if lista_tuplas_frontend[i][0] != None: s1.frontend.append(lista_tuplas_frontend[i][0]) i += 1 lista_tuplas_sgbd = self.sgbd_dao.buscar_por_squad(s1.id) i = 0 for sg in range(len(lista_tuplas_sgbd)): if lista_tuplas_sgbd[i][0] != None: s1.sgbd.append(lista_tuplas_sgbd[i][0]) i += 1 lista_squads.append(s1) return lista_squads
def salvar(): squad = Squad() squad.id = int(request.args['id']) squad.nome = request.args['nome'] squad.descricao = request.args['descricao'] squad.numpessoas = request.args['numpessoas'] backend = request.args['backend0'] if backend != '': squad.backend.append(backend) backend1 = request.args['backend1'] if backend1 != '': squad.backend.append(backend1) frontend = request.args['frontend0'] if frontend != '': squad.frontend.append(request.args['frontend0']) frontend1 = request.args['frontend1'] if frontend1 != '': squad.frontend.append(request.args['frontend1']) sgbd = request.args['sgbd'] if sgbd != '': squad.sgbd.append(request.args['sgbd']) if squad.id == 0: squad_controller.salvar(squad) else: squad_controller.alterar(squad) return redirect('/listar')
def buscar_por_id(self, id): s = self.squad_dao.buscar_por_id(id) s1 = Squad() s1.id = s[0] s1.nome = s[1] s1.descricao = s[2] s1.numpessoas = s[3] lista_tuplas_backend = self.backend_dao.buscar_por_squad(s1.id) i = 0 for b in range(len(lista_tuplas_backend)): s1.backend.append(lista_tuplas_backend[i]) i += 1 lista_tuplas_frontend = self.frontend_dao.buscar_por_squad(s1.id) i = 0 for f in range(len(lista_tuplas_frontend)): s1.frontend.append(lista_tuplas_frontend[i]) i += 1 lista_tuplas_sgbd = self.sgbd_dao.buscar_por_squad(s1.id) i = 0 for sg in range(len(lista_tuplas_sgbd)): s1.sgbd.append(lista_tuplas_sgbd[i]) i += 1 return s1