Node CRUD Heroku

README.md

express and knex

From project root directory:

$ express --hbs --git

$ npm install

• Installs boilerplate dependencies

$ npm install --save pg knex method-override

$ npm install --save-dev nodemon

• Adds nodemon start script in package.json

$ git init

$ touch knexfile.js

• Setup knexfile.js config

const path = require('path');

module.exports = {
  development: {
    client: 'pg',
    connection: 'postgres://localhost/[ DATABASE NAME ]',
    migrations: {
      directory: path.join(__dirname, 'db', 'migrations')
    },
    seeds: {
      directory: path.join(__dirname, 'db', 'seeds')
    }
  },
  production: {
    client: 'pg',
    connection: process.env.DATABASE_URL,
    migrations: {
      directory: path.join(__dirname, 'db', 'migrations')
    },
    seeds: {
      directory: path.join(__dirname, 'db', 'seeds')
    }
  }
};

$ mkdir db

$ touch db/knex.js

• Add knex start script in package.json

"scripts":
    "knex": "./node_modules/.bin/knex"

• Setup knex.js config

const env = process.env.NODE_ENV || 'development';
const config = require('../knexfile.js')[env];
const knex = require('knex')(config);

module.exports = knex;

$ createdb [database name]

$ psql [database name]

• In new shell tab to confirm database creation

knex migrations

$ npm run knex migrate:make [table name]

• Edit migration file to create table

// EXAMPLE TABLE
'use strict';

exports.up = function(knex, Promise) {
    return knex.schema.createTable('events', (table) => {
      table.increments();   // creates incrementing ID
      table.string('title').notNullable();
      table.text('description').defaultTo('');
      table.dateTime('start_time').notNullable();
      table.dateTime('end_time').notNullable();
      table.integer('venue_id');
    })
};

exports.down = function(knex, Promise) {
    return knex.schema.dropTable('events')
};

$ npm run knex migrate:latest

• Creates the table in the database

$ npm run knex seed:make 1_[table name]

• Edit the seed file to insert data, make sure to delete the data before inserting data

// EXAMPLE SEED

exports.seed = function(knex, Promise) {
// Deletes ALL existing entries
  return knex('events').del()
    .then(function () {
      return knex.raw("SET datestyle = ymd;")
    }).then(function () {
      // Inserts seed entries
      return knex('events').insert([
        {
          id: 1,
          title: 'Rock concert',
          description: 'Rock n roll all night and party every day!!!!!',
          over_21: true,
          start_time: '2018-04-22 18:00:00',
          end_time: '2018-04-22 20:00:00',
          venue_id: 1
        },
      ]);
    }).then(() => {
      return knex.raw(
        "SELECT setval('events_id_seq', (SELECT MAX(id) FROM events));"
      )
    });
};

$ npm run knex seed:run

• Seeds the table with your data

setting routes

• Set route with a method and attach a named function

• Code function to return a simple message

  • test

• Build html template to render and have function render that template

  • test

• Hard-code variables in function to pass through to template

  • test

• Refactor function to include logic and dynamic variables

  • test

HEROKU deployment

• Add a production key to knexfile.js

  • Set connection: process.env.DATABASE_URL
  • Everything else should be the same as development

• Set a ternary in db/knex.js

  • const env = process.env.NODE_ENV || 'development';

$ heroku create [app name]

• To rename: $ heroku apps:rename [new name]

$ git commit -m 'prep for deployment'

$ git push heroku master

$ heroku open opens your heroku-deployed app

$ heroku logs for finding errors

$ heroku config

• Use heroku config:set VAR_NAME=value to add environment variables to deployed site

$ heroku addons:create heroku-postgresql

• Creates a postgres server on heroku

$ heroku run bash

• Opens up a console on heroku server for your app
• Run migrations and seed your db as you would locally