/mysql-review

Primary LanguageJavaScript

MySQL Review

A quick review of connecting a MySQL database to our Express server

Usage

npm install
npm run start

This repo is recommended to be used with MySQL 5.7.

Documentation

  • MySQL: MySQL Github documentation
  • Sequelize: Sequelize documentation

Step 1

  • Create database ReviewDB within MySQL
  • Establish connection to database in database/index.js

Step 2

  • Create a schema in database/schema.sql to describe our tasks table
  • Run schema file in terminal

Step 3

  • Create a seeding function in database/seed.js to populate table with at least 5 records
  • Run seed file in terminal

Step 4

  • Create dbHelper functions in database/dbHelpers.js
  • Create controller functions in server/controllers.js
  • Use dbHelper functions within your controller functions

Step 5

  • Test for working functionality via Postman

OPTIONAL STEP

Refactor the following files to utilize Sequelize ORM:

  • database/index.js
  • database/dbHelpers.js
  • server/controllers.js

NOTE: You may need to create an additional database/model.js to allow Sequelize to define our tasks table model