Bamazon_MySQL is a CLI app that works on three levels:
-
A MySQL database called "bamazon" that has a table called "products"
.png)
-
A Customer view, accessed by the terminal command node bamazonCustomer.js
- this shows a customer view of a failure to purchase due to an insufficient supply
.png)
- and a customer view of a successful purchase
.png)
- this shows a customer view of a failure to purchase due to an insufficient supply
-
A Manager view, accessed by the terminal command node bamazonManager.js
- this shows a managerial view with four different options and operations
.png)
- the first option shows all available inventory in the database
.png)
- the second option displays low inventory, more specifically all product items below 100 units
.png)
- the third managerial option allows a manager to add more units to a low inventory product
.png)
- the last managerial option allows the manager to add a new product, with the CLI prompting the manager specific questions about the product
- this shows a managerial view with four different options and operations
.png)
.png)
.png)
.png)
.png)
.png)
.png)