Skip to content
An Amazon-like application that takes orders from customers and depletes stock from the store's inventory using a MySQL database and Node.js.
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
database.sql
package-lock.json
package.json

README.md

mysql-inventory-tracker

A Node Amazon-like application that takes orders from customers and depletes stock from the store's inventory using a MySQL database.

Technologies Used:

MySQL Inventory Demo

Full Video Demo: https://share.getcloudapp.com/E0ulYRpO

Commands

Customer View:

$ node bamazonCustomer.js

Manager View:

$ node bamazonManager.js

Installation

  • Clone GitHub repo.
  • Create a local database called bamazon (or any name you want). I used MySQL Workbench to handle the MySQL locally.
  • Import database.sql file from root folder and import. Check out the MySQL Workbench Table Data Export and Import Wizard for instructions.
  • Make sure YOURROOTPASSWORD and DATABASENAME in the mysql.createConnection method match your local database's credentials on both bamazonCustomer.js and bamazonManager.js:
// Create MySQL Connection
const connection = mysql.createConnection({
    host: "localhost",
    port: 3306,
    user: "root",
    password: YOURROOTPASSWORD,
    database: DATABASENAME
});
  • Install npm dependencies:
$ npm install
  • Enjoy!
You can’t perform that action at this time.