Skip to content

An Amazon-like storefront app built with Node and MySQL.

Notifications You must be signed in to change notification settings

kawboyer/bamazon

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

The Bamazon mySQL app

The Bamazon app is an Amazon-like storefront. The app uses mySQL to take in orders from customers and deplete stock from the store's inventory. The store is populated with ten mock data products (inspired by a search on silly products sold online).

A description of how the app works:

  1. The app displays a table with all of the items available for sale, including item id's, product names department names and prices.

  2. Secondly, the app prompts the users to answer two questions:

  • What is the ID of the product that you would like to buy?
  • How many units of the product would you like to buy?
  1. The app repeats back the user input, and informs the current stock quantity of the requested item id.

  2. Lastly, if the store has enough of the product to meet the customer's request, it will update the SQL database to reflect the remaining quantity, and show the customer the total cost of their purchase.

  3. However, if the store does not have enough of the product to meet the customers request, the purchase will not go through.

The app uses the following npm packages:

  • mySQL
  • inquirer
  • cli-table

Screenshots illustrating the functionality of the app:


Screenshot illustrating the table and user input (points 1 and 2).


Screenshot illustrating the response if the item is in stock (points 3 and 4).


Screenshot illustrating the table and user input (points 1 and 2).


Screenshot illustrating the response if the item is NOT in stock (3 and 5).

About

An Amazon-like storefront app built with Node and MySQL.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published