Skip to content

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

Notifications You must be signed in to change notification settings

jpd61/e-commerce-backend

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

Twitter: jpdewoody

Description

🔍 A mysql database and application backend for an e-commerce site. Built using MySQL2, Express, Sequelize and dotenv.

💻 Below is the gif showing the functionality of the application:

DB Setup and Start

GET All

GET All by ID

POST PUT DELETE Products and Tags

POST PUT DELETE Categories

🎥 The full movie file showing functionality of the application can be found in the animations directory

User Story

AS A manager at an internet retail company
I WANT a back end for my e-commerce website that uses the latest technologies
SO THAT my company can compete with other e-commerce companies

Acceptance Criteria

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 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
THEN I am able to successfully create, update, and delete data in my database

Table of Contents

Installation

💾

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

Testing

✏️

No testing is currently set up

Contributing

:octocat: Joseph DeWoody

Questions

✉️ Contact me with any questions: email , GitHub