Bamazon is a command-line application for an Amazon-like storefront. It utilizes Node.js & MySQL to process customer orders, update inventory, and track individual product sales and total profits (by department). At the manager level, users can check low inventory, add to inventories, and add new products. At the supervisor level, users can view products, overhead costs, and total profits by department. They can also create a new department.
- Git
- GitHub
- JavaScript
- SQL
- MySQL Workbench
- Node.js
- Node packages:
- MySQL
- Inquirer
- CLI Table
- Make sure Node.js and MySQL are installed on your computer.
- Make sure you have a MySQL client, such as MySQL Workbench, installed that will allow you to administer/access the database.
- Open MySQL Workbench (or any MySQL client you prefer) and run the bamazon_db.sql code to create the database, as well as the "products" and "departments" tables.
- Open your computer's Command Line Interpreter (CLI) and navigate to the folder/directory where you would like to save and run this application.
- Run
git clone https://github.com/jenross/bamazon.git
. - Navigate to the directory for the project (
cd Bamazon
). - Open the project's JavaScript files in your code editor and add the password you are using for your MySQL client to link to the database (line 17 on each file).
- Run
npm install
to download all of the required node modules.
Run node bamazonCustomer.js
in your CLI/Terminal.
Run node bamazonManager.js
in your CLI/Terminal.
Run node bamazonSupervisor.js
in your CLI/Terminal.