Click to view video walkthrough
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 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
During this challenge I have showcased the following
-
Creation of the database through MySQL shell commands
-
Database seeding through node scripts
-
Creating, reading, updating, and deleting of data through sequelize
-
Storage and usage of environment variables with dotenv
-
Creation and utilization of sequelize models and relationships
-
Incorporating of sequelize through express routes
To use this application, clone the repo and within the terminal type the following commands:
npm install
Once you have the dependencies installed, create the database using the schema file in the db folder using MySQL workbench or the MySQL shell.
Create the .env file with your credentials following the .env.EXAMPLE structure
Seed the database using the following command:
npm run seed
You're now ready to run the application using:
npm run start
Follow the instructions in the terminal and enjoy.
-
JavaScript
-
Node.js
-
Express.js
-
MySQL
-
Sequelize