Cmoconnor0823/Bamazon_Database

An app to demonstrate the use of MySql in the context of a store inventory program

Bamazon_Database

Description

An app to demonstrate the use of the Inquirer and MySql npm's in the context of a store inventory program.

Set up

In order to run this application you will need to run the npm install command, in the file destination in console log. This should install the npm mySql and the npm Inquirer.

To run the customer interface please follow the steps below:

• clone into the repo using this link: https://github.com/Cmoconnor0823/Bamazon_Database.git
• cd bamazon
• npm install
• node bamazonCustomer.js

Customer Interface

When the customer interface application is run, first the user will be welcomed to the site, and the presented with a current inventory of items, listed in raw detail the bamazon_db.sql file. The user is then prompted with a question asking them to select a item's id # and then how many of the item the user would like to order. The application will then verify the user's order and deduct the remaining total from the database. Finally the user is prompted to see if they would like to order another item, and if so the program will continue and if not the program will thank the user then end.

Bamazon Demo

Click the link below to view a short video demonstrating the application in action.

• This link will open a video showing the application in action in Git Bash.

• This link will open a video the MySql Database live updating the inventory per user order.

Technology

This page was built with the following NPM Modules, and technologies:

• mySQL

• Inquirer

• mySQL Workbench

• Git Bash

• Visual Studio Code

• JavaScript

For comments/ concerns contact the project Author: Caitlin O'Connor
At: Cmoconnor0823@gmail.com