This is a MySQL2 built data base and back end application for an Ecommerce Website. This application uses MySql2, Express, Sequelize and DotEnv, aswell as Insomnia for testing endpoints.
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
npm init
npm install mysql2
npm install sequelize
npm install dotenv
Accsess the root file of this project using node and initialize MYSQL by entering mysql -u root -p
, and enter the password when prompted.
After MySQL starts, enter the following commands -
source db/schema.sql;
quit
npm run seed
npm start
Once you start server via npm start, you may open the api endpoints via Insomnia to use the POST/ PUT / DELETE/ GET functions in Insomnia