pamelac21/e-commerce

SQL - Refactor - Configuring Express.js API to use Sequelize to interact with a MySQL database.

Object-Relational Mapping (ORM): E-Commerce Back End 👋

Description

My goal is to build the back end for an e-commerce site by taking a working Express.js API and configuring it to use Sequelize to interact with a MySQL database. Since this project will not be deployed, please check out the full walkthrough video posted below to view its functionality.

Table of Contents

• Installation
• Usage
• Demo
• Tech Used
• Contact
• License
• Contributing

GIVEN a functional Express.js API
WHEN I add my database name, MySQL username, and MySQL password to an environment variable file
THEN I am able to connect to a database using Sequelize
WHEN I enter schema and seed commands
THEN a development database is created and is seeded with test data
WHEN I enter the command to invoke the application
THEN my server is started and the Sequelize models are synced to the MySQL database
WHEN I open API GET routes in Insomnia Core for categories, products, or tags
THEN the data for each of these routes is displayed in a formatted JSON
WHEN I test API POST, PUT, and DELETE routes in Insomnia Core
THEN I am able to successfully create, update, and delete data in my database

Demo

🎥 Full video -> https://watch.screencastify.com/v/WFlq1UPr2zJiCSBo8x3c

Getting Started

Clone the starter code.

npm init

npm install mysql2

npm install sequelize

npm install dotenv

Usage

Run the following command at the root of your project and answer the prompted questions:

mysql -u root -p

Enter PW when promted

source db/schema.sql

quit

npm run seed

npm start

Tech Used

bcrypt dotenv express mysql2 sequelize

Contact

GitHub

email

License

This project is licensed under the MIT License - see the LICENSE file for details.