def salvar():
squads = Squads()
squads.id = int(request.args['id'])
squads.nome = request.args['nome']
squads.descricao = request.args['descricao']
squads.numeroPessoas = request.args['numeroPessoas']
back = LinguagemBackend()
back.id = int(request.args['id_backend'])
back.nome = request.args['linguagemBackend']
front = FrameworkFrontend()
front.id = int(request.args['id_front'])
front.nome = request.args['frameworkFrontend']
sgbds = Sgbds()
sgbds.id = int(request.args['id_sgbds'])
sgbds.nome = request.args['sgbds']
squads.linguagemBackend = back
squads.frameworkFrontend = front
squads.sgbds = sgbds
if squads.id == 0:
squads_controller.salvar(squads)
else:
squads_controller.alterar(squads)
return redirect('/listar')
def __init__(self):
self.id = 0
self.name_squad = ''
self.descricao = ''
self.numero_pessoas = 0
self.lingbackend = BackEnd()
self.lingfrontend = FrontEnd()
self.lingsgbds = Sgbds()
def __init__(self):
self.id = 0
self.nome = ''
self.descricao = ''
self.numeroPessoas = 0
self.linguagemBackEnd = LinguagemBackEnd()
self.frameworkFrontEnd =FrameworkFrontEnd()
self.sgbds = Sgbds()
def salvar_sgbds():
if request.method == 'POST':
sgbd = Sgbds()
sgbd.nome = request.form['nome']
try:
sgbd.id = int(request.form['id'])
except ValueError:
sgbd.id = None
if sgbd.id == 0 or sgbd.id is None:
sg.adicionar(sgbd)
else:
sg.alterar(sgbd)
return redirect('/listar_sgbds')
def cadastrar_sgbds():
classe = Sgbds()
caminho = '/salvar_sgbds'
if 'id' in request.args:
id = request.args['id']
classe = sg.buscar(id)
return render_template('cadastro2.html', classe=classe, caminho=caminho)
def cadastrar():
squads = Squads()
squads.linguagemBackend = LinguagemBackend()
squads.frameworkFrontend = FrameworkFrontend()
squads.sgbds = Sgbds()
if 'id' in request.args:
id = request.args['id']
squads = squads_controller.buscar_por_id(id)
return render_template('cadastrar.html', titulo_app=nome, squads=squads)
def alterar(self, squad:Squad):
backend = LinguagemBackEnd()
backend.nome = squad.linguagemBackEnd.nome
backend.id = squad.linguagemBackEnd.id
if backend.nome == "":
backend_class = self.backend_c.buscar(backend.id)
backend.nome = backend_class.nome
self.backend_c.alterar(backend)
frontend = FrameworkFrontEnd()
frontend.nome = squad.frameworkFrontEnd.nome
frontend.id = squad.frameworkFrontEnd.id
if frontend.nome == "":
frontend_class = self.frontend_c.buscar(squad.frameworkFrontEnd.id)
frontend.nome = frontend_class.nome
self.frontend_c.alterar(frontend)
sgbds = Sgbds()
sgbds.nome = squad.sgbds.nome
sgbds.id = squad.sgbds.id
if sgbds.nome == "":
sgbds_class = self.sgbds_c.buscar(squad.sgbds.id)
sgbds.nome = sgbds_class.nome
self.sgbds_c.alterar(sgbds)
id = squad.id
nome = squad.nome
descricao = squad.descricao
numeroPessoas = squad.numeroPessoas
self.squad_db.alterar(id, nome, descricao, numeroPessoas, backend.id, frontend.id, sgbds.id)
def adicionar(self, squad:Squad):
backend = LinguagemBackEnd()
backend.nome = squad.linguagemBackEnd.nome
if squad.linguagemBackEnd.id == 0 or squad.linguagemBackEnd.id is None:
squad.linguagemBackEnd.id = self.backend_c.adicionar(backend)
else:
backend_class = self.backend_c.buscar(squad.linguagemBackEnd.id)
squad.linguagemBackEnd.nome = backend_class.nome
frontend = FrameworkFrontEnd()
frontend.nome = squad.frameworkFrontEnd.nome
if squad.frameworkFrontEnd.id == 0 or squad.frameworkFrontEnd.id is None:
squad.frameworkFrontEnd.id = self.frontend_c.adicionar(frontend)
else:
frontend_class = self.frontend_c.buscar(squad.frameworkFrontEnd.id)
squad.frameworkFrontEnd.nome = frontend_class.nome
sgbds = Sgbds()
sgbds.nome = squad.sgbds.nome
if squad.sgbds.id == 0 or squad.sgbds.id is None:
squad.sgbds.id = self.sgbds_c.adicionar(sgbds)
else:
sgbds_class = self.sgbds_c.buscar(squad.sgbds.id)
squad.sgbds.nome = sgbds_class.nome
nome = squad.nome
descricao = squad.descricao
numeroPessoas = squad.numeroPessoas
linguagemBackEnd = int(squad.linguagemBackEnd.id)
frameworkFrontEnd = int(squad.frameworkFrontEnd.id)
sgbd = int(squad.sgbds.id)
self.squad_db.adicionar(nome, descricao, numeroPessoas, linguagemBackEnd, frameworkFrontEnd, sgbd)
def conversor(self, lista_tuplas):
lista_sgbds = []
if type(lista_tuplas[0]) == tuple:
for sgbd_tuple in lista_tuplas:
sgbd = Sgbds()
sgbd.id = sgbd_tuple[0]
sgbd.nome = sgbd_tuple[1]
lista_sgbds.append(sgbd)
else:
sgbd = Sgbds()
sgbd.id = lista_tuplas[0]
sgbd.nome = lista_tuplas[1]
lista_sgbds = sgbd
return lista_sgbds
def buscar_por_id(self, id):
p = self.dao.buscar_por_id(id)
squads = Squads()
squads.id = p[0]
squads.nome = p[1]
squads.descricao = p[2]
squads.numeroPessoas = p[3]
squads.linguagemBackend = LinguagemBackend()
squads.linguagemBackend.id = p[4]
squads.linguagemBackend.nome = p[5]
squads.frameworkFrontend = FrameworkFrontend()
squads.frameworkFrontend.id = p[6]
squads.frameworkFrontend.nome = p[7]
squads.sgbds = Sgbds()
squads.sgbds.id = p[8]
squads.sgbds.nome = p[9]
return squads
def listar_todos(self):
lista_times = []
lista_tuplas = self.dao.listar_todos()
for p in lista_tuplas:
squads = Squads()
squads.id = p[0]
squads.nome = p[1]
squads.descricao = p[2]
squads.numeroPessoas = p[3]
squads.linguagemBackend = LinguagemBackend()
squads.linguagemBackend.id = p[4]
squads.linguagemBackend.nome = p[5]
squads.frameworkFrontend = FrameworkFrontend()
squads.frameworkFrontend.id = p[6]
squads.frameworkFrontend.nome = p[7]
squads.sgbds = Sgbds()
squads.sgbds.id = p[8]
squads.sgbds.nome = p[9]
lista_times.append(squads)
return lista_times