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
