コード例 #1
0
    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
コード例 #2
0
    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
コード例 #3
0
    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