SQL Storefront

A MySQL online store and product management application.

Features

• Integrated MySQL database
• Customer view
  • View all items
  • Purchase items
• Manager view
  • View all items
  • View low-stock items
  • Add stock to an item
  • Add a new item

Prerequisites

• MySQL
• Node.js

Getting Started

• Clone this repository to your machine.
• Run console.sql in your preferred MySQL program.
• Run npm install to install necessary Node packages.
• Run node bamazonCustomer.js for the customer view.
• Run node bamazonManager.js for the manager view.

Technologies Used

• Node/NPM (JavaScript environment/package manager)
• DataGrip (Database IDE)
• WebStorm (JavaScript IDE)
• MySQL (RDBMS)
• Inquirer.js (Command line interaction interface)

Screenshots

Customer view

• Initial prompt

• Checkout process, including error handling.

Manager view

• Initial prompt

• View all items

• View low quantity items

• Add stock of an item

• Add new item, part 1

• Add new item, part 2 + show updated all items view

Author

Mich Elliott - @mchlltt

Acknowledgements

My thanks to

• Node.js contributors and package creators
• Northwestern Coding Boot Camp