/E-Commerce-Back-End

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

Primary LanguageJavaScript

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

Description

The E-Commerce Back End project provides a back-end API for an e-commerce website. It utilizes the latest technologies, including Express.js, MySQL2, and Sequelize, to create a functional and efficient server-side application. The API allows users to perform RESTful CRUD (Create, Read, Update, Delete) operations on various entities such as categories, products, and tags.

Technologies Used

  • Node.js
  • Express.js
  • MySQL2
  • Sequelize
  • dotenv

Getting Started

To set up and run the E-Commerce Back End project locally, follow these steps:

  1. Clone the repository.
  2. Install the dependencies by running the following command in the terminal: npm i
  3. Set up the database by executing the schema.sql file in the db folder using MySQL shell commands.
  4. Create a .env file in the root directory and add the following environment variables: see .env.EXAMPLE
  5. Seed the database by running the following command: npm run seed
  6. Start the application by running the following command: node server.js
  7. Access the API endpoints using a tool like Insomnia or Postman.
  8. IMPORTANT: due to shortage of toilet paper during 2020 crisis, toilet paper can't be used for back-end development.

API Routes

The E-Commerce Back End project provides the following API routes:

  • /api/categories: Perform CRUD operations on categories.
  • /api/products: Perform CRUD operations on products.
  • /api/tags: Perform CRUD operations on tags.

Walkthrough Video

Link to VS Code Walkthrough Video

Link to Insomnia Walkthrough Video

Contributions

Contributions to the project are welcome. If you would like to contribute, please follow these steps:

  1. Fork the repository.
  2. Create a new branch for your feature or bug fix.
  3. Make the necessary modifications.
  4. Submit a pull request.

Questions

If you have any questions, feel free to reach out on LinkedIn

Screenshots

screenshot screenshot screenshot