def __getClientOrders(self): searchMenu = CUI('Client Orders') self.currentMenu = searchMenu try: client_id = int(input('Enter client_id: ')) if not (isinstance(client_id, int) and client_id > 0): raise Exception('Invalid input') startTime = time.time() allRecords = self.searchController.getAllClientOrders(client_id) endTime = time.time() searchMenu.setError('\nElapsed time: ' + str(endTime - startTime)[:9] + 's' '\nRows num: ' + str(len(allRecords))) searchMenu.addField('<Order id> | transaction date | taxes_sum') for record in allRecords: searchMenu.addField(f"<{record[0]}> {record[1]} {record[2]}") except Exception as err: searchMenu.setError(str(err)) searchMenu.run('Return to prev menu')
def __getCategoryProducts(self): searchMenu = CUI('Cayegory Products') self.currentMenu = searchMenu try: category_id = int(input('Enter category_id: ')) if not (isinstance(category_id, int) and category_id > 0): raise Exception('Invalid input') startTime = time.time() allRecords = self.searchController.getAllCategoryProducts( category_id) endTime = time.time() searchMenu.setError('\nElapsed time: ' + str(endTime - startTime)[:9] + 's' '\nRows num: ' + str(len(allRecords))) searchMenu.addField( '<Product id> | Product name | Product cost | Manufacturer') for record in allRecords: searchMenu.addField( f"<{record[0]}> {record[1]} {record[2]} {record[3]}") except Exception as err: searchMenu.setError(str(err)) searchMenu.run('Return to prev menu')
def __getItems(self): itemsMenu = CUI(self.instance.__name__ + 's') self.itemsCurrentMenu[0] = itemsMenu try: if self.page < math.ceil( self.Controller.getCount() / self.per_page): itemsMenu.addField( 'NEXT', lambda: self.__changePageParams( self.page + 1, self.per_page)) if self.page > 1: itemsMenu.addField( 'PREV', lambda: self.__changePageParams( self.page - 1, self.per_page)) entities = self.Controller.getRange(self.page, self.per_page) for entity in entities: if 'name' in self.Controller.getModelKeys(): itemsMenu.addField(f"<{entity.id}> {entity.name}", lambda id=entity.id: self.__getItem(id)) else: itemsMenu.addField(f"<{entity.id}>", lambda id=entity.id: self.__getItem(id)) except Exception as err: itemsMenu.setError(str(err)) itemsMenu.run('Return to main menu')
def __init__(self): self.currentMenu = [None, None] self.page = 1 self.per_page = 10 self.CUI = CUI("Product model menu") self.productController = ProductController() self.CUI.addField('Add Product', lambda: self.__addProduct()) self.CUI.addField('Generate rows', lambda: self.__generateRows()) self.CUI.addField('Products', lambda: self.__getProducts())
def __init__(self): self.currentMenu = [None, None] self.page = 1 self.per_page = 10 self.CUI = CUI("Client model menu") self.clientController = ClientController() self.CUI.addField('Add Client', lambda: self.__addClient()) self.CUI.addField('Generate rows', lambda: self.__generateRows()) self.CUI.addField('Clients', lambda: self.__getClients())
def __init__(self): self.page = 1 self.per_page = 10 self.currentMenu = [None, None] self.CUI = CUI("Category model menu") self.categoryController = CategoryController() self.CUI.addField('Add Category', lambda: self.__addCategory()) self.CUI.addField('Generate rows', lambda: self.__generateRows()) self.CUI.addField('Categorys', lambda: self.__getCategorys())
def __init__(self): self.currentMenu = [None, None] self.page = 1 self.per_page = 10 self.CUI = CUI("Order model menu") self.orderController = OrderController() self.CUI.addField('Add Order', lambda: self.__addOrder()) self.CUI.addField('Generate rows', lambda: self.__generateRows()) self.CUI.addField('Orders', lambda: self.__getOrders())
def __init__(self, instance): self.instance = instance self.page = 1 self.itemsCurrentMenu = [None, None] self.per_page = 10 self.CUI = CUI(f"{self.instance.__name__} model menu") self.Controller = ModelController(instance) self.CUI.addField(f'Add {self.instance.__name__}', lambda: self.__addItem()) self.CUI.addField(f'{self.instance.__name__}s', lambda: self.__getItems())
def __init__(self): self.currentMenu = None self.page = 1 self.per_page = 10 self.min = None self.max = None self.CUI = CUI("Search menu") self.searchController = SearchController() self.CUI.addField('Search products cost by cost range', lambda: self.__getProductsByCostRange()) self.CUI.addField('Search all client orders', lambda: self.__getClientOrders()) self.CUI.addField('Search all category products', lambda: self.__getCategoryProducts())
def __getItem(self, id: int): itemMenu = CUI(f'{self.instance.__name__} menu') self.itemsCurrentMenu[1] = itemMenu try: item = self.Controller.getById(id) for (key, value ) in self.Controller.getModelEntityMappedKeys(item).items(): itemMenu.addField(str(key) + ' : ' + str(value)) itemMenu.addField('DELETE', lambda: self.__deleteItem(item.id)) itemMenu.addField('UPDATE', lambda: self.__updateItem(item)) itemMenu.addField('Return to prev menu', lambda: self.__supportCUIFunc()) except Exception as err: itemMenu.setError(str(err)) itemMenu.run(False)
def __getOrder(self, id: int): orderMenu = CUI('Order menu') self.currentMenu[1] = orderMenu try: order: Order = self.orderController.getById(id) values = order.getValues().split(',') keys = order.getKeys().split(',') for i in range(len(keys)): orderMenu.addField(keys[i] + ' : ' + values[i]) orderMenu.addField('DELETE', lambda: self.__deleteOrder(order.id)) orderMenu.addField('UPDATE', lambda: self.__updateOrder(order.id)) orderMenu.addField('Return to prev menu', lambda: self.__supportCUIFunc()) except Exception as err: orderMenu.setError(str(err)) orderMenu.run(False)
def __getClient(self, id: int): clientMenu = CUI('Client menu') self.currentMenu[1] = clientMenu try: client: Client = self.clientController.getById(id) values = client.getValues().split(',') keys = client.getKeys().split(',') for i in range(len(keys)): clientMenu.addField(keys[i] + ' : ' + values[i]) clientMenu.addField('DELETE', lambda: self.__deleteClient(client.id)) clientMenu.addField('UPDATE', lambda: self.__updateClient(client.id)) clientMenu.addField('Return to prev menu', lambda: self.__supportCUIFunc()) except Exception as err: clientMenu.setError(str(err)) clientMenu.run(False)
def __getProductsByCostRange(self): searchMenu = CUI('Products') self.currentMenu = searchMenu try: if self.min is None or self.max is None: self.min = int(input('Enter min value: ')) self.max = int(input('Enter max value: ')) if not (isinstance(self.min, int) and isinstance(self.max, int) and self.max > 0 and self.min > 0 and self.max >= self.min): raise Exception('Invalid input') startTime = time.time() allRecords = self.searchController.getProductsByCostRange( self.min, self.max) endTime = time.time() searchMenu.setError('\nElapsed time: ' + str(endTime - startTime)[:9] + 's' '\nRows num: ' + str(len(allRecords))) if self.page < math.ceil(len(allRecords) / self.per_page): searchMenu.addField( 'NEXT', lambda: self.__changePageParams( self.page + 1, self.per_page)) if self.page > 1: searchMenu.addField( 'PREV', lambda: self.__changePageParams( self.page - 1, self.per_page)) searchMenu.addField( '<ID> | Product name | Product cost | Category name') for record in self.searchController.getProductsByCostRange( self.min, self.max, self.page, self.per_page): searchMenu.addField( f"<{record[0]}> {record[1]} {record[2]} {record[3]}") except Exception as err: searchMenu.setError(str(err)) searchMenu.addField('Return to prev menu', lambda: self.__exitMenu()) searchMenu.run(False)
def __getClients(self): clientsMenu = CUI('Clients') self.currentMenu[0] = clientsMenu try: if self.page < math.ceil( self.clientController.getCount() / self.per_page): clientsMenu.addField( 'NEXT', lambda: self.__changePageParams( self.page + 1, self.per_page)) if self.page > 1: clientsMenu.addField( 'PREV', lambda: self.__changePageParams( self.page - 1, self.per_page)) clients = self.clientController.getAll(self.page, self.per_page) for client in clients: clientsMenu.addField(f"<{client.id}> {client.name}", lambda id=client.id: self.__getClient(id)) except Exception as err: clientsMenu.setError(str(err)) clientsMenu.run('Return to main menu')
def __getOrders(self): ordersMenu = CUI('Order') self.currentMenu[0] = ordersMenu try: if self.page < math.ceil( self.orderController.getCount() / self.per_page): ordersMenu.addField( 'NEXT', lambda: self.__changePageParams( self.page + 1, self.per_page)) if self.page > 1: ordersMenu.addField( 'PREV', lambda: self.__changePageParams( self.page - 1, self.per_page)) orders = self.orderController.getAll(self.page, self.per_page) for order in orders: ordersMenu.addField(f"<{order.id}> {order.transaction_date}", lambda id=order.id: self.__getOrder(id)) except Exception as err: ordersMenu.setError(str(err)) ordersMenu.run('Return to main menu')
def __fillEntityMenu(self, *args): self.currentMenu = CUI(f'{self.instance.__name__} fill menu') try: if len(args) > 0 and isinstance(args[0], self.instance): item = args[0] for (key, value) in self.Controller.getModelEntityMappedKeys( item).items(): self.currentMenu.addField( f'{key}: <{value}>', lambda key=key, value=value: self. __supportFillItemFunc(key, value, item)) elif len(args) > 0 and isinstance(args[0], dict): mapped = args[0] for key in self.Controller.getModelKeys(): mapped[key] = None self.currentMenu.addField( f'{key}', lambda key=key: self.__supportFillFunc(key, mapped)) else: raise Exception('Invalid arguments') except Exception as err: self.currentMenu.setError(str(err)) self.currentMenu.run('Save and Return')
from db import session from entityView import EntityView from CUI.cui import CUI from models.client import Client from models.order import Order from models.category import Category from models.product import Product if __name__ == '__main__': cui = CUI('lab3') cui.addField('Clients', lambda: EntityView(Client).run()) cui.addField('Orders', lambda: EntityView(Order).run()) cui.addField('Categories', lambda: EntityView(Category).run()) cui.addField('Product', lambda: EntityView(Product).run()) cui.run() session.close()
from views.clientView import ClientView from views.orderView import OrderView from views.categoryView import CategoryView from views.productView import ProductView from views.searchView import SearchView from CUI.cui import CUI if __name__ == '__main__': main = CUI() main.addField('Products', lambda: ProductView().run()) main.addField('Categories', lambda: CategoryView().run()) main.addField('Orders', lambda: OrderView().run()) main.addField('Clients', lambda: ClientView().run()) main.addField('Search', lambda: SearchView().run()) main.run()