/knexMigrationsAndSeeds

Primary LanguageJavaScript

gMemory practice pt.1

Objectives

  • [why?]
  • [walk through included files]
  • [install dependencies]
  • [create knex file]
  • [generate migration]
  • [build out migration]
  • [apply migration local database]
  • [check psql for table]
  • [generate seed]
  • [build out seed]
  • [apply seed local database]
  • [check psql for seeded table]
  • [build out database-connection]
  • [build queries]
  • [test each route & query using postman]
  • [create heroku app]
  • [add postgresql add-on to DB]
  • [push DB to Heroku]
  • [migrate table on heroku DB]
  • [seed data on heroku DB]

Steps

  • Create Database
createdb DBNAMEHERE
  • check for database
psql DBNAMEHERE
  • install knex and pg dependencies
npm i knex pg
  • generate knex file
knex init

  • connect db in knex file

    • development & production

  • create migration

knex migrate:make TABLENAMEHERE
  • run migration
knex migrate:latest
  • check database for table
psql DBNAME
heroes=# TABLE TABLENAMEHERE;
  • create seed
knex seed:make 01-hero
  • run seed
knex seed:run
  • Create Heroku app
heroku create APPNAME
  • Add PostgreSQL add-on to Heroku app
heroku addons:create heroku-postgresql
  • push to heroku remote
git push heroku BRANCHNAME
  • Migrate Table onto Heroku DB
heroku run knex migrate:latest
  • Seed Heroku DB with data
heroku run knex seed:run
  • check Heroku DB for table and seeded data
heroku pg:psql

Resources