lesleyfon / bamazon

Bamazon

Created during Week 6 of UC Berkeley Coding Bootcamp. The goal was to create an Amazon-like store front using Node.js and MySQL.

Getting Started

• Clone repo.
• Run command in Terminal or Gitbash 'npm install'
• Run command depending which mode you would like to be on:
  • Customer - 'node bamazon.js'
  • Manager - 'node managerbamazon.js'
• Run 'ctrl + c' to exit each mode

What Each JavaScript Does

1. bamazon.js

   • Prints the products in the store.

   • Prompts customer which product they would like to purchase by ID number.

   • Asks for the quantity.

     • If there is a sufficient amount of the product in stock, it will return the total for that purchase.
     • However, if there is not enough of the product in stock, it will tell the user that there isn't enough of the product.
     • If the purchase goes through, it updates the stock quantity to reflect the purchase.
     • It will also update the product sales in the department table.

---

2. managerbamazon.js

   • Starts with a menu:

     • View Products for Sale
     • View Low Inventory
     • Add to Inventory
     • Add New Product
     • Quit

   • If the manager selects View Products for Sale, it lists all of the products in the store including all of their details.

   • If the manager selects View Low Inventory, it'll list all the products with less than five items in its StockQuantity column.

   • If the manager selects Add to Inventory, it allows the manager to select a product and add inventory.

   • If the manager selects Add New Product, it allows the manager to add a new product to the store.

   • If the manager selects End Session, it ends the session and doesn't go back to the menu.

---

Demo Videos

• bamazon.js

• managerbamazon.js

Technologies used

• Node.js
• Inquire NPM Package (https://www.npmjs.com/package/inquirer)
• MYSQL NPM Package (https://www.npmjs.com/package/mysql)

Built With

• Visual Studio code - Text Editor
• MySQLWorkbench
• Terminal/Gitbash

Authors

• Lesley Fonsi - JS/MySQL/Node.js - Lesley Fonsi