This application is the back end of an E-Commerce site that allows users to control their products, categories and tags. The user can view all the products associated with a category and tag, the categories together with their tags and the tags with all their associated products. Furthermore, users are able to create, update and delete products, categories and tags.
- node.js needs to be installed prior to use
- open terminal
- clone the repo:
https://github.com/NAli3107/E-Commerce-Shopping-Back-End - cd into new directory
- download JSON packages by entering
npm i - create
.envfile - to connect to the database run
mysql -u root -pand enter password from .env file - source the schema.sql
- seed the data by running
npm run seed - enter
npm start
This application will allow users to view, create, update, and delete categories, products, and tags.
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 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
THEN I am able to successfully create, update, and delete data in my database
Screenshot of Database:
Screenshot of Postman:
Email Address: Nadiraali188a@gmail.com
Linkedin Profile: LinkedIn
Github: Profile
Github: Repo