MySQL Database Review using Sequelize

Server and mySQL shell startup

npm install
start mysql server + mysql shell

Exercise 1

Create your database folder.
Create an index file inside your database folder.
In your shell, create a mysql database.
Set up Sequelize to establish a connection to the mysql database, and export the connection.

Exercise 2

Create a file to describe our Sequelize model schema.
Export your schema.

Exercise 3

Connect your database to your controller.
Build out your controller functionality in the server controller file.
Use an external tool such as Postman to test your database with GET, POST, PUT and DELETE requests.
Check that the database is being updated with each request in your mysql shell.

Exercise 4

Create a file with some data that fits your schema, and write a function to seed that data into the database.
Add this functionality as a setup script to your package.json and run it.