index.py

import mysql.connector
import os
from dotenv import load_dotenv
import utils
import time
import loggerUtil

load_dotenv()

USER, PASSWORD, HOST, AUTHPLUGIN = os.getenv('USER'), os.getenv('PASSWORD'), os.getenv('HOST'), os.getenv('AUTHPLUGIN')
CATALOGDB, ORDERSDB =  os.getenv('CATALOGDB'),  os.getenv('ORDERSDB'),

catalogDB = mysql.connector.connect(user=USER, password=PASSWORD, host=HOST, database=CATALOGDB, auth_plugin=AUTHPLUGIN)
catalogCursor = catalogDB.cursor()

orderdsDB = mysql.connector.connect(user=USER, password=PASSWORD, host=HOST, database=ORDERSDB, auth_plugin=AUTHPLUGIN)
ordersCursor = orderdsDB.cursor()

logger = loggerUtil.getLogger()

# System logic begins

os.system('clear')

print(utils.helloMessage)
time.sleep(1)
os.system('clear')

cart = []

while(True):
    logger.debug("Main manu accessed")
    
    os.system('clear')
    menuChoice = input(
        '1. Browse Catalog \n'
        '2. Check Cart\n'
        '3. Checkout\n'
        '9. Exit\n\n'
        '~> '
    )

    if(menuChoice=='9'):
        logger.debug("Program exit")
        exit()

    elif(menuChoice=='1'):
        while(True):
            logger.debug("Catalog menu accessed")
            
            os.system('clear')
            utils.printCatalog(catalogCursor, CATALOGDB)
        
            catalogChoice = input(
                '• To add item to cart, type \'Add <item_id>\' \n'
                '• To delete item from cart, type \'Delete <item_id>\' \n'
                '• To checkout, type \'Checkout\'\n'
                '• To return to main menu, type \'Return\'\n\n'
                '~> '
            ).split(' ')

            if(catalogChoice[0].lower()=='add'):
                add_status = utils.addToCart(catalogChoice[1], cart, catalogCursor, CATALOGDB)

                if(add_status==0):
                    logger.debug("Item with item_id %s added to the cart", catalogChoice[1])
                    print("Added to the cart")

                else:
                    logger.info("Item with item_id %s not found in catalog", catalogChoice[1])
                    print("Item not found in the catalog. Please check the item number")
                
                time.sleep(2)
            
            elif(catalogChoice[0].lower()=='delete'):
                delete_status = utils.deleteFromCart(int(catalogChoice[1]), cart)

                if delete_status == 0:
                    logger.debug("Item with item_id %s removed from the cart", catalogChoice[1])
                    print("Deleted")

                else:
                    logger.info("Item with item_id %s not found in the cart", catalogChoice[1])
                    print("Item not found in cart")
                
                time.sleep(2)
        
            elif(catalogChoice[0].lower()=='checkout'):
                logger.debug("Checkout performed")
                utils.checkout(cart, ordersCursor, orderdsDB, ORDERSDB)
                break
        
            elif(catalogChoice[0].lower()=='return'):
                logger.debug("Return to main menu")
                break

            elif(catalogChoice[0].lower()=='clear'):
                logger.debug("clear CLI screen")
                os.system('clear')
        
            else:
                logger.info("Invalid choice entered")
                print("Invalid choice. Please choose from the options above. \n")
                time.sleep(2)
        

    elif(menuChoice=='2'):
        logger.info("Cart printed")

        if len(cart)>0:
            for item in cart:
                item.print()
        
        else:
            print("Cart is empty")
        
        time.sleep(2)

    elif(menuChoice=='3'):
            logger.debug("Checkout performed")
            utils.checkout(cart, ordersCursor, orderdsDB, ORDERSDB)
            break
    
    else:
        logger.info("Invalid choice entered")
        print("Invalid choice. Please choose from the options above. \n")
        time.sleep(2)