Skip to content
No description, website, or topics provided.
JavaScript TSQL
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.gitignore
README.md
bamazonCustomer.js
bamazonManager.js
bamazonSchema.sql
bamazonSeeds.sql
package-lock.json
package.json

README.md

bamazon Node App

Built by Beau Simpson

This app was built using the following:

  • JavaScript
  • Node.js
  • Node modules
    • Inquirer
    • MySql
    • console.table
  • MySql Database

To use the app the user must first:

  • Install the required Node packages:

    • npm install
  • Use MySql and the following files to create database

    • bamazonSchema.sql
    • bamazonSeeds.sql
  • Enter MySql user password in bamazonCustomer.js file so that connection can be made to MySql Server

Customer View

Enter node bamazonCustomer.js to run program

Once entered, the screen will display:

Image of bamazon customer first example

Once Id has been selected, it will ask how many units to be purchased: Image of bamazon customer second example

After number of units to purchase has been entered; the terminal will:

  • Display how many units have been purchased
  • Display how much the customer owes
  • Ask if customer would like to continue, which resets or exits the program

Image of bamazon customer third example

If amount of units to be purchased that is more than what is in stock:

  • It will display "Insufficient Quantity"
  • Ask if customer would like to continue, which resets or exits the program

Image of bamazon customer third example

Manager View

Enter node bamazonManager.js to run program

The Terminal will display and ask manager to:

  • Select from a list of menu options:

    • View Products for Sale

    • View Low Inventory

    • Add to Inventory

    • Add New Product

Example of terminal display:

Image of bamazon manager list of options example

View Products for Sale

  • This option will list all the products available for sale
  • Ask if manager would like to continue, which resets or exits the program

Example of View Products for Sale: Image of bamazon manager view products for sale example

View Low Inventory

  • If no products have low inventory, displays message "No Items with low inventory"
  • This option will list all products with an inventory of less than 5 unites
  • Ask if manager would like to continue, which resets or exits the program

Example of View Low Inventory - No items with low inventory: Image of bamazon manager view low inventory example

Example of View Low Inventory - list of products with low inventory: Image of bamazon manager view low inventory example

Add to Inventory

  • Lists all products, so one may be chosen to add inventory to:

Example of Add to Inventory - List of Products Image of bamazon manager add to inventory example

  • Asks how many units of selected product to be added to inventory

Example of Add to Inventory - How many units to be added: Image of bamazon manager add to inventory example

  • Displays confirmation of item being updated
    • Ask if manager would like to continue, which resets or exits the program

Example of Add to Inventory - Inventory update confirmation: Image of bamazon manager add to inventory example

Add New Product

  1. Asks for the name of new product to be added:

Example of Add New Products - Name of new product: Image of bamazon manager add to inventory example

  1. Asks for the department of the new product:

Example of Add New Products - New product department: Image of bamazon manager add to inventory example

  1. Asks for the price of the new product:

Example of Add New Products - New product price: Image of bamazon manager add to inventory example

  1. Asks for the starting stock quantity of the new product:

Example of Add New Products - New product starting quantity: Image of bamazon manager add to inventory example

  1. Displays confirmation of new product being added:
    • Asks if manager would like to continue, which resets or exits the program

Example of Add New Products - New product confirmation: Image of bamazon manager add to inventory example

You can’t perform that action at this time.