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 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 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