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 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 "Erro: ", e