This app is the inclusion of the back end logic for an E-Commerce site by configuring a working Express.js API to use Sequelize (ORM) to interact with a MySQL database. The SQL database includes tables for products, categories, tags, and product tags.
- Make sure to have Node.js and MySQL installed before starting.
- Clone the repo and paste it into your CLI:
git clone git@github.com:tylerhance/E-Commerce-Back-End.git
- Go to your root directory and install the dependencies by running:
npm i
- To hook up the MySQL database in the CLI run:
mysql -u root -p
- Then
source db/schema.sql
- Type
quit
to return to the root directory.
- Source the schema.sql and seed the files using:
npm run seed
- To start the server in the command line run:
npm start
This app allows users to view, add, edit/update, and delete categories, products and tags accordingly.
- View the walk-through video for hooking up the DB and seeding data Here
- View the walk-through video for testing the API routes Here
- Node.js
- Express
- MySQL
- Sequelize
- dotenv
- nodemon
- Feel free to drop me a line at tyler.hance@gmail.com or visit my GitHub Profile to check out my other projects.