class SquadController:
def __init__(self):
self.sd = SquadDao()
def select_all(self):
lista = self.sd.select_all()
retorno = []
for i in lista:
squad = Squad(i[0],i[1],i[2],i[3],i[4],i[5])
retorno.append(squad)
return retorno
def select_byId(self, id):
s = self.sd.select_byId(id)
squad = Squad(s[0],s[1],s[2],s[3],s[4],s[5])
return squad
def insert(self, squad : Squad):
self.sd.insert(squad)
def update(self, squad : Squad):
self.sd.update(squad)
def delete(self,id):
self.sd.delete(id)
class SquadController:
def __init__(self):
self.sd = SquadDao()
self.sc = SGBDController()
self.bc = BackController()
self.fc = FrontController()
def select_all(self):
lista = self.sd.select_all()
retorno = []
for i in lista:
squad = Squad(i[0], i[1], i[2], i[3])
if i[4] != None:
squad.id_linguagemFront = i[4]
squad.linguagemFront = self.fc.select_byId(i[4])
if i[5] != None:
squad.id_linguagemBack = i[5]
squad.linguagemBack = self.bc.select_byId(i[5])
if i[6] != None:
squad.id_sgbd = i[6]
squad.sgbd = self.sc.select_byId(i[6])
retorno.append(squad)
return retorno
def select_byId(self, id):
s = self.sd.select_byId(id)
squad = Squad(s[0], s[1], s[2], s[3])
if s[4] != None:
squad.linguagemFront = self.fc.select_byId(s[4])
if s[5] != None:
squad.linguagemBack = self.bc.select_byId(s[5])
if s[6] != None:
squad.sgbd = self.sc.select_byId(s[6])
return squad
def insert(self, squad: Squad):
self.sd.insert(squad)
def update(self, squad: Squad):
self.fc.update(squad.linguagemFront)
self.bc.update(squad.linguagemBack)
self.sc.update(squad.sgbd)
self.sd.update(squad)
def delete(self, squad: Squad):
self.fc.delete(squad.id_linguagemFront)
self.bc.delete(squad.id_linguagemBack)
self.sc.delete(squad.id_sgbd)
self.sd.delete(squad.id)