Enrique246/e-commerce-backend

Management of product data for e-commerce site.

E-Commerce Back-end

Description

• What was your motivation?
  • Learning to build a back-end structure for a e-commerce app.
• Why did you build this project?
  • To understand how SQL and Node.js relate and work togather.

Summary

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

• What did you learn?
  • MySQL, Server & Sequelize connection
  • CRUD routing
  • Mapping and returning elements from a database
  • Insomnia functions

Languages Required:

• Node.js
• JavaScript
• Sequalize
• MySQL

Usage

Please watch the next videos for usage details:

• Server (Video)

• Get single product/PUT/POST/DELETE (Video)

• Technical Acceptance/Create Schema.sql/Get routes (Video)

Resources

• https://developer.mozilla.org/en-US/docs/Learn/JavaScript/Asynchronous/Async_await
• https://sequelize.org/master/manual/assocs.html
• https://sequelize.org/master/manual/validations-and-constraints.html#-code-allownull--code--interaction-with-other-validators
• Class activities

Credits

• Enrique Del Castillo Chávez

Tests

• Application invoke passed
• Connection server with sequelize passed
• API GET route passed
• Each route is displayed in formatted JSON passed
• API POST, PUT and DELETE passed
• CREATE, UPDATE AND DELETE DATA passed