def get(self):
try:
service = session.query(ServiceTable, Client, Product).join(
Client, Product).filter(ServiceTable.id == 1).first()
if service is None:
return None
else:
c = ClientClass(service.Client.name, service.Client.cpf,
service.Client.segment)
c.id = service.Client.id
p = ProductClass(service.Product.name,
service.Product.description,
service.Product.image)
p.id = service.Product.id
s = ServiceClass(service.Service.request_date,
service.Service.cancel_date)
s.id = service.Service.id
s.client = c
s.product = p
return s
except Exception as e:
print "Deu erro: " % e
def get(self):
try:
service = session.query(
ServiceModel,Client,Product)\
.join(Client,Product)\
.filter(ServiceModel.id==self.service.id).first()
if service is None:
return None
c = ClientClass(service.Client.name,
service.Client.cpf,
service.Client.segment)
c.id = service.Client.id
p = ProductClass(service.Product.name,
service.Product.description,
service.Product.image)
p.id = service.Product.id
s = ServiceClass(service.Service.request_date,service.Service.cancel_date)
s.id = service.Service.id
s.client = c
s.product = p
return s
except Exception as e:
print "Algum erro aconteceu: %s"%e
def InstallService(self):
service = ServiceClass()
service._id = self._id
sd = ServiceDao(service)
service = sd.get()
print "Sera instalado o Produto ( %s ) para o Client ( %s )"%(service._product._name,service._client._name)
docker = DockerOps()
res = docker.createContainer(service._id,service._product._image)
def InstallService(self):
service = ServiceClass()
service._id = self._id
sd = ServiceDao(service)
service = sd.get()
print "Sera instalado o Produto ( %s ) para o Client ( %s )" % (
service._product._name, service._client._name)
docker = DockerOps()
res = docker.createContainer(service._id, service._product._image)
def InstallService(self):
try:
service = ServiceClass()
service.id = self.id
servicedao = ServiceDAO(service)
service = servicedao.get()
print "ID: %s Data de Contratacao: %s"%(service.id,service.request_date)
print "Instalando o servico para o cliente; %s"%service.client.name
print "Servico a ser instalado: %s"%service.product.name
docker = DockerOps()
res = docker.createContainer(service.id,service.product.image)
except Exception as e:
print "Erro: %s"%e
def installService(self):
try:
service = ServiceClass()
service.id = self.id
servicedao = ServiceDAO(service)
service = servicedao.get()
print "ID: %s Data de Contratacao: %s"%(service.id,service.request_date)
print "Instalando o servico para o client: %s"%service.client.name
print "Servico a ser instalado: %s"%service.product.name
docker = DockerOps()
res = docker.createContainer(service.id,service.product.image)
print "Servico instalado com sucesso"
except Exception as e:
print "Ocorreu um erro: %s"%e
def switch(x):
cli = Client()
prod = Product()
serv = Service()
dict_options = {
1: cli.add_client,
2: prod.add_product,
3: serv.add_service
}
dict_options[x]()
def get(self):
try:
service = session.query(ServiceTable,Client,Product).join(Client,Product).filter(ServiceTable.id==self._service._id).first()
if service is None:
return None
else:
c = ClientClass(service.Client.name,service.Client.cpf,service.Client.segment)
c._id = service.Client.id
p = ProductClass(service.Product.name,service.Product.description,service.Product.image)
p._id = service.Product.id
s = ServiceClass(service.Service.request_date,service.Service.cancel_date)
s._id = service.Service.id
s._client = c
s._product = p
return s
except Exception as e:
print "Deu erro: ",e
def applyForCreditCard(user_dict):
# create a service object from user_dict and add it to the requests database
request = Service(user_dict["customer"].customer_id,
user_dict["customer"].name, user_dict["savings"].balance,
user_dict["customer"].creditScore, "CreditCard")
# approve or decline based on if they have credit score over 600
decision = request.approve_or_decline_creditCard()
# if approved add to serviceHistory
if decision == True:
request.write_service_to_history()
# if declined add it to the request db
else:
request.write_request_to_db()
def applyForLoan(user_dict):
# create a service object from user_dict
request = Service(user_dict["customer"].customer_id,
user_dict["customer"].name, user_dict["savings"].balance,
user_dict["customer"].creditScore, "Loan")
# approve or decline based on if they have over 50,000 in savings
decision = request.approve_or_decline_loan()
# if approved add to serviceHistory
if decision == True:
request.write_service_to_history()
# if declined add it to the requests database
else:
request.write_request_to_db()
def get(self):
try:
service = (
session.query(ServiceModel, Client, Product)
.join(Client, Product)
.filter(ServiceModel.id == self.service.id)
.first()
)
if service is None:
return None
c = ClientClass(service.Client.name, service.Client.cpf, service.Client.segment)
c.id = service.Client.id
p = ProductClass(service.Product.name, service.Product.description, service.Product.image)
p.id = service.Product.id
s = ServiceClass(service.Service.request_date, service.Service.cancel_date)
s.id = service.Service.id
s.client = c
s.product = p
return s
except Exception as e:
print "Algum erro aconteceu: %s" % e
def admin_add_service():
# key_list = ["ServiceName",
# "DataBaseString",
# "Url",
# "Port"]
#
form: dict = request.form
#
# for item in key_list:
# if not form.keys().__contains__(item):
# return f"{item} not exist in the body"
service_name = form[ServiceModelVN.ServiceName]
database_string = form[ServiceModelVN.DataBaseString]
service_url = form[ServiceModelVN.Url]
service_port = form[ServiceModelVN.Port]
return Service.add(service_name, service_url, database_string,
service_port)
def admin_service_index():
# todo : get all services
# TODO :CHECK ADMIN
return Service.get_all()
def admin_service_delete(service_id):
return Service.delete(service_id)
def admin_update_service(service_id):
form = request.form
return Service.update(service_id, form["NewData"])
def system_get_service_configs(service_name):
# todo : check internal request
return Service.get(service_name=service_name)
