E-Commerce style database created by implementingobject relational mapping paradigms. Written w/ Sequelize, Express.js, Node, JavaScript, MySql
Installation requires downloading or cloning the repository to your local machine. Cd into the project directory in your terminal / command line and run npm install. Upon completing the npm install login to your mysql server, and source the database sql file using SOURCE db/schema.sql;. You can complete your mysql interaction after running USE ecommerce_db . Leave mysql by entering exit; . SEED the database simply by running npm run seed Get the server up and running by entering node server
install-Demo.mp4
Using postman or insomnia, to hit the endpointpoints defined in the routes folder, you have access to the following features at the endpoints listed below. Note - Create, read, update and delete features are included at all endpoints.
insomniaDemo.mp4
-
Category Routes -
http://localhost:3001/api/categories -
Product Routes -
http://localhost:3001/api/products -
Tag Routes -
http://localhost:3001/api/tags-
Get all Category Data:
http://localhost:3001/api/categories -
Get Category Data by ID:
http://localhost:3001/api/categories/YOU_SPECIFY_ID_NUMBER -
Create New Category Data by sending json object to:
http://localhost:3001/api/categories/ -
json Object in the following form{"category_name": "gardentools"} -
Update an existing Category Data by sending json object to a specified ID:
http://localhost:3001/api/categories/YOU_SPECIFY_ID_NUMBER -
json Object in the following form{"category_name": "gardentools"}
-
-
Delete Category Data by ID:
http://localhost:3001/api/categories/YOU_SPECIFY_ID_NUMBER
Fork, critique or contact
Testing performmed in insomnia
visit my github Reach out w/ Additional Questions. ianclark.creative@gmail.com
2021 - MIT MIT Info