/ecommerce_backend_jh

This was created to create a backend for an e-commerce website utilizing MySQL.

Primary LanguageJavaScriptMIT LicenseMIT

Jordan-Heidlage-ECOMMERCE_BACKEND

Most recent commit GitHub code size in bytes

Description

This application was created to establish a Back-end for an e-commerce website utilizing the latest technologies to remain competitive. This project utilizes MySQL, npm libraries, and insomnia to perform CRUD operations to the database. To allow the user to utilize the following functions on Categories, Products, and Tags:

  • GET all
  • GET 1 by ID
  • CREATE
  • UPDATE
  • DELETE by ID

Table of Contents

License

License: MIT

Installation

After downloading this file, run command "npm i" in your terminal to install the npm libaries.

Usage

Upon downloading the file, use the following commands:

  • mysql -u root -p
  • "enter password"
  • source db/schema.sql
  • quit
  • npm run seed
  • npm start

Upon completion of these in the terminal, you can use insomnia to perform CRUD operations to the models using the appropriate routes. Images Below:

  • 1
  • 2
  • 3

Here's a video walkthrough on how to use it: https://drive.google.com/file/d/1Pi5KlrGD_QrBSJYlYuZQiJpuh_gi5Zri/view

Credits