Bamazon is a command line application that uses the SQL database. There are two command options, customer or manager. The customer can buy products from the store, while the manager has four different options.
When run the customer will see a list of products available to buy and then be asked to select a product by it's id number. Then they will be asked how many of the product they would like to buy. Once they select, it will show the total amount of which product they bought and the cost of the total sale. The products database will update to reflect inventory change.
When run the manager will have four options:
- View products for sale
- View low inventory
- Add to inventory
- Add new product
This shows all products
This shows all items with low inventory (below 15 units)
This allows the manager to add new inventory to a selected product
This allows the manager to add a new item into the table
- Javascript
- NodeJS
- MySQL
- npm packages:
- mysql
- prompt
- colors