e-commerce

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

Table of Contents

• Introduction
• User Story
• Acceptance Criteria
• Installation
• Create db
• Run Server
• Seed Database
• Walkthrough videos
• Dependencies & Technologies
• Author

Introduction

The application contained within is a database and functional e-commerce backend using Express.js API and Sequelize. This application using Insomnia/Postman will allow users to view, create, update, and delete categories, products, and tags for a product catalog.

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 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

Installation

Install the packages/dependencies by hitting following command on your terminal console:

npm i
npm i mysql2
npm i sequelize
npm i express
npm i dotenv 

Create db:

env	e-commerce database

Run Server

Seed Database

Walkthrough videos

Showcasing of Category application running in Insomnia:

• YouTube Video: DemoVideo

Showcasing of Tags application running in Insomnia:

• YouTube Video: DemoVideo

Showcasing of Products application running in Insomnia:

• YouTube Video: DemoVideo

Dependencies & Technologies

🙋 Author

Written by Tatyana Yarushin student in full stack web development in the Coding Bootcamp course at Carleton University

I hope you found something interesting! 📜

❓ For any additional information or questions find me at:

• Email: tatyana.yarushin@gmail.com

• Github: TatyanaYarush