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 _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 __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 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 __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 __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 __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 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 __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 __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)