EcommBackEnd

Description

Ecommerce Back End software utilizing Object-Relational Mapping (ORM) software Sequelize to interact with a MySQL database. The software will connect to and seed a MySQL database. Its functionallity of create, read, update, and delete (CRUD) will be demonstrated through the command line. The user will be prompted with a list of options to choose from. The user may view, add, update or delete categories, products, and tags stored in the database.

Badge

https://img.shields.io/badge/license-GPL-blue.svg

Table of Contents

Video

  • Video
    Video of the application in use.

Installation

clone the project, while in the project folder run 'npm install'. Then run 'npm start' to run the project. Rename the .env.EXAMPLE file to .env and update the database name, user, and password to your mysql password. The database will be created when you run 'npm run seed'.

Usage

Using the command line, run 'npm run seed' to seed the databe, then 'npm start' to start the application. Use your prefered software to interact with the database. I used Insomnia Core to test the routes. The routes are as follows:

  • /api/categories
  • /api/products
  • /api/tags

License

GPL

Contributing

Fork the project. Afterwards, create a feature branch with the changes. When ready, push that branch back to github.com

Tests

There are no tests for this project.

Questions

Github Username: xclusive36
Github Profile: Github Profile
Any additional questions, please reach out to me by email:
Email: Email

Sources

  • mysql2
    Package used to interact with mysql in node.

  • dotenv Package used to hide the mysql password.

  • sequelize Package used to interact with mysql in node.

  • express Package used to create the server.