My goal is to build the back end for an e-commerce site by taking a working Express.js API and configuring it to use Sequeliz
e to interact with a MySQL
database. Since this project will not be deployed, please check out the full walkthrough video posted below to view its functionality.
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
๐ฅ Full video -> https://watch.screencastify.com/v/WFlq1UPr2zJiCSBo8x3c
Clone the starter code.
npm init
npm install mysql2
npm install sequelize
npm install dotenv
Run the following command at the root of your project and answer the prompted questions:
mysql -u root -p
Enter PW when promted
source db/schema.sql
quit
npm run seed
npm start
bcrypt
dotenv
express
mysql2
sequelize
This project is licensed under the MIT License - see the LICENSE file for details.