Пример #1
0
class CtrlClient(object):
    """docstring for CtrlClient."""

    def __init__(self):
        super(CtrlClient, self).__init__()
        self.__conn = None
        self.__client = None
        self.__clients = []
        self.__items = []
        self.__loadClients()

    def __loadClients(self):
        try:
            self.__conn = Conn()
            flag, clients = self.__conn._selectAll(table="client")
            if not flag:
                self.__setClients()
            self.__items = clients
        except Exception as e:
            self.__setClients()

    def __setClients(self):
        name = "name text"
        email = "email text"
        points = "points integer"
        try:
            self.__conn = Conn()
            if not self.__conn._createTable(name, points, email, table="client"):
                self.__loadClients()
        except Exception as e:
            print(e)

    def getClients(self):
        if self.__items == None:
            self.__loadClients()
        for client in self.__items:
            self.__setClient(client)
        return self.__clients

    def getClient(self, *args):
        logger.debug(f'Arguments "{args}"')
        try:
            self.__conn = Conn()
            flag, client = self.__conn._selectEach(f'{args[0]}', f'{args[1]}', table="client")
            logger.debug(f'Return===>Client "{client}" / Flag "{flag}"')
            self.__client = Client(*client)
            logger.debug(f'Client===>ObjClient "{self.__client}"')
            return flag, self.__client
        except Exception as e:
            print("Exception GetClient", e)
            return flag, None


    def __setClient(self, client):
        item = Client(*client)
        self.__clients.append(item)
Пример #2
0
class CtrlProduct(object):
    """docstring for CtrlProduct."""

    def __init__(self):
        super(CtrlProduct, self).__init__()
        self.__conn = None
        self.__products = []
        self.__items = []
        self.__loadProducts()

    def __loadProducts(self):
        try:
            self.__conn = Conn()
            flag, products = self.__conn._selectAll(table="product")
            if not flag:
                self.__setProducts()
            self.__items = products
        except Exception as e:
            self.__setProducts()

    def __setProducts(self):
        name = "name text"
        description = "description text"
        price = "price real"
        image = "image text"
        try:
            self.__conn = Conn()
            if not self.__conn._createTable(name, description, price, image, table="product"):
                self.__loadProducts()
        except Exception as e:
            print(e)

    def getProduct(self, name):
        try:
            self.__conn = Conn()
            flag, product = self.__conn._selectEach("name", name, table="product")
            product = Product(*product)
            return flag, product
        except Exception as e:
            print(e)
            return flag

    def getProducts(self):
        if self.__items == None:
            self.__loadProducts()
        for product in self.__items:
            self.__setProduct(product)
        return self.__products

    def __setProduct(self, product):
        item = Product(*product)
        self.__products.append(item)
Пример #3
0
class CtrlSale(object):
    """docstring for CtrlSale."""
    def __init__(self):
        super(CtrlSale, self).__init__()
        self._id = None
        self.__con = None
        self.__sale = None
        self._sales = []
        self.__loadSales()
        self.__status = False
        self.__ctrlProduct = CtrlProduct()
        self.__ctrlClient = CtrlClient()

    def _setShop(self, *args):
        self.__sale = Sale(*args)
        return self.__sale

    def _getClient(self, name):
        _, client = self.__ctrlClient.getClient('name', name)
        return client

    def _getProducts(self, sale):
        products = []
        qtd = []
        for item in sale:
            _, product = self.__ctrlProduct.getProduct(item[2])
            qtd.append(item[3])
            products.append(product)
        return products, qtd

    def __loadSales(self):
        try:
            self.__conn = Conn()
            flag, sales = self.__conn._selectAll(table="sale")
            if not flag:
                self.__setSales()
            self._sales = sales
            self._id = self._sales[-1][0] + 1
            print(self._id)
        except Exception as e:
            print("EXCEPTION LOAD_SALES", e)
            self.__setSales()

    def _getSale(self, id):
        try:
            self.__conn = Conn()
            flag, sale = self.__conn._selectAllWhere("id", id, table="sale")
            return flag, sale
        except Exception as e:
            print(e)
            return flag

    def __setSales(self):
        id = "id integer"
        client = "client text"
        product = "product text"
        quantity = "quantity integer"
        value = "value real"
        try:
            self.__conn = Conn()
            if not self.__conn._createTable(
                    id, client, product, quantity, value, table="sale"):
                self.__loadSales()
        except Exception as e:
            print("SET SALES", e)

    def __insertSale(self, *args):
        logger.debug(f'Return===>SALE "{args}"')
        try:
            self.__conn = Conn()
            self.__conn._insertItem(args[0], args[1], table="sale")
        except Exception as e:
            print("INSERT_SALE============>", e)

    def _setSale(self, sale):
        fields = "id,client,product,quantity,value"
        sale = json.loads(sale)
        if self._id == None:
            self.__loadSales()

        for i, _ in enumerate(sale['userBasket']):

            values = f"'{self._id}','{sale['userLogged']}','{sale['userBasket'][str(i)]['item']}','{sale['userBasket'][str(i)]['qtd']}','{sale['userBasket'][str(i)]['price']}'"

            try:
                self.__insertSale(fields, values)
                self.__status = True
            except Exception as e:
                self.__status = False
                print("INSERT_STATUS ============>", e)
        return self.__status

    def __repr__(self):
        return self.content