A mysql database and application backend for an e-commerce site that encompasses using MySQL2, Express, Sequelize and dotenv.
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
Node, Express, Mysql2, Sequelize, Dotenv
๐พ
npm install
-
First user must clone the repo, create a
.env
file with associated passwords. -
Sign into
mysql
account by runningmysql -u root -p
at the terminal, enter your password when prompted, then runsource db/schema.sql
, quitmysql
with\q
. -
At terminal, run
npm run seeds
to populate seeds data, thennpm start
to start up server.
no contributions at this time
Please contact me using the following links:
Github Jessiferizzo
โ๏ธ My Email
MIT licensing, our great instructors and TAs, graders, and classmates
Read more about MIT here:
MIT
Copyright (c) 2022