Development of the back end for an e-commerce site using Express.js API, configured to use sequelize to interact with a MySQL database.
- Express.js
- MySQL
- Sequelize
To get started clone this repository using
git clone [email protected]:tringuyen1086/e-commerce-backend-pro.git
Both Node.js and MySQL must be installed on your computer.
Install dependencies
npm install
npm install express sequelize mysql2
Open up MySQL shell and input
source db/schema.sql
and
use ecommerce_db
Then quit MySQL shell and input the following in your terminal
npm run seed
to start running application simply input
npm start
Open up Insomnia core to GET, POST, PUT and DELETE from different routes.
AS A manager at an internet retail company
I WANT a back end for my e-commerce website that uses the latest technologies
SO THAT my company can compete with other e-commerce companies
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
Demo - Creating the schema from the MySQL shell & Seeding the database from the command line & Starting the application's server here
e-commerce-backend-pro-Demo.mp4
Demo - GET routes for all categories, all products, and all tags being tested in Insomnia here
e-commerce-backend-pro-GET-All.mp4
Demo - Get routes for a single category, a single product, and a single tag being tested in Insomnia here
e-commerce-backend-pro-GET-One.mp4
Demo - POST, PUT, and DELETE routes for categories, products, and tags being tested in Insomnia here