Command line application that simulates an inventory management system, allowing users to add, remove, and track items with ease. It features customer purchase functionality, manager capabilities for adding inventory and products, and supervisor access for viewing sales and department management.
- Ensure you have Node, MySQL server, and MySQL workbench installed; links in the Technology section.
- Open the
connection.jsfile and add the connection values for your local MySQL server. - Clone the repository to your local machine.
git clone https://github.com/DavidLapadula/StoreFrontSQL.git
cd storefrontsql- Open a terminal in the root directory and run:
npm install
- Use the
schema.sqlandseeds.sqlto populated the database. They can be modified if you wish. - Open a terminal in the root directory and run the file associated to the role you would like to perform. The options are:
node bamazonCustomer.js
node bamazonManager.js
node bamazonSupervisor.js
Customer: user can use item IDs to make purchases, prompts them to retry if the ID is incorrect, informs them if the order exceeds stock, and, if valid, processes the order, updates the database, and displays the order information.
Manager: user can perform various duties to check stock and change inventory, including viewing products for sale, viewing low inventory, adding to inventory, and adding new products.
Supervisor: user can perform all the duties of a supervisor, including viewing product sales by department, creating new departments, and viewing the highest-grossing department.
