This is the back end for an e-commerce applicaiton made with Express.js API and Sequelize to communicate with a MySQL database.

• Made-With
• Install
• Notes
• Video
• Screenshots
• Liscense
• Credits
• Questions

• Sequelize
• Express.js
• Node.js
• ES6
• MySQL

Additional Insomnia

To install dependencies, run "npm i" or "npm install" in the command line. The user must also create a .env file and add their local MySQL login information to access the database.

• Once dependencies have been installed the user must create a .env file and enter thier login information for MySQL to access the database.
• Access the databse by logging into MySQL in the command line and run 'SOURCE db/schema.sql;' followed by 'USE ecommerce_db;'
• Once that is complete quit out of MySQL and seed the database by running 'npm run seed' in the command line.
• When you are ready to access the database run 'npm start' and you will see the message 'Now Listening' in the console.
• To interact with the database use Insomnia to test CRUD opperations for Category, Product and Tag models. You are able to GET, PUT, POST and DELETE for each model.
• The routes for each model are:
  • http://localhost:3001/api/categories
  • http://localhost:3001/api/products
  • http://localhost:3001/api/tags

https://watch.screencastify.com/v/2huEHnC8x0rAeyVs9fzV

GET category by Id

GET all tags

POST product

PUT product

This project is liscensed under the MIT liscense.

Made by Nina Siegel

For questions, open a new issue.

To see more of my work visit https://github.com/nmsiegel1/