NodeJS + MySQL = Bamazon!

A command line way to shop for goods/items. This project uses Node.js to faciliate user interaction and MySQL as the backend.

Prerequisites

After downloading/cloning this project, run npm install
Refer to schema.sql for database structure. sample_data.sql is included to get started with mock data

🤔 Check out and see what happens if you buy more than the stock quantity listed per item!

This command will list all the products that's stored in the database

This command will query items that have a stock quantity fewer than 5

This command will allow the manager to update the stock quantity of an item

This command will ask the manager a series of prompts to add a new item to the inventory

cli-table is used to make the tables "pretty": [https://www.npmjs.com/package/cli-table]
inquirer is used as a helper for the interactive command line user interface: [https://www.npmjs.com/package/inquirer]

Validate Entries: e.g. A SKU should only be able to take an integer, limit/scope Department from a stored array, etc...
Supervisor View: A third command/view to see projections/profits of the store