/Amazing-SQL-Backend-for-Your-E-commerce-Site

This application represents the backend of an e-commerce site built with MySQL, Sequalize, and Express.

Primary LanguageJavaScriptMIT LicenseMIT

Amazing SQL Backend for Your E-commerce Site

License

This product is open source and licensed under the MIT License License: MIT

Description

This application represents the backend of an e-commerce site built with MySQL, Sequalize, and Express. Feel free to use this implementation in your application!

Table of Contents

  1. License
  2. Description
  3. Application
  4. Video
  5. Installation
  6. Contributing
  7. Connect

Application

The application was built with MySQL and as such requires a MySQL database to connect to. The application will run locally on port 3001 unless otherwise specified.

Video

This video shows the each route being executed in Insomnia and you can see the tables being updated in the MySQL Workbench.

2023-05-27.13-06-48.mp4

Installation

You must create a .env file and store your db authentication information in order to connect to your db some commands to be aware of:

This will install the necessassary node dependencies

npm i

You can initialize the database from the db directory by using the mysql cli to source the schema

mysql -u "(your user name here)" -p
"(enter your password)"

once you are within the mysql cli enter the following commands

source schema.sql
quit

Then the db can be seeded from the main directory

node seeds/index.js

Contributing

This is an open source project.

Connect

You can find more of my work at: Joecode22