Exemplo n.º 1
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
Exemplo n.º 2
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
Exemplo n.º 3
0
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]()
Exemplo n.º 4
0
    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
Exemplo n.º 5
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