Phase2Project - Inventory App

Create an app that interfaces psql db with frontend.

Workflow

Setup

Create an app that interfaces psql db with frontend.

npm init -- creates package.json

npm intall knex -- installs knex dependency to interface with pg db

npm install express -- install express.js lib

npm install pg -- installs pg interface for knex and psql

cat package.json -- verify dependecies have been added

npm install knex --save -- creates knexfile.js -- make sure knexfile.js has development environment info.

npx knex init -- create 'knexfile.js'

  module.exports = {

        development: {
            client: 'postgresql',
            connection: {
            database: 'YOUR DB HERE',
            user:     '------',
            password: '------'
            },
            pool: {
            min: 2,
            max: 10
            },
            migrations: {
            tableName: 'knex_migrations'
            }
        }

        };

cp knexfile.js example.knexfile.js - copies generic knexfile.js template to example.knefile.js

module.exports = {

  development: {
    client: 'postgresql',
    connection: {
      database: 'your database',
      user:     'your username',
      password: 'your password'
    },
    pool: {
      min: 2,
      max: 10
    },
    migrations: {
      tableName: 'knex_migrations'
    }
  }

};

ADD KNEXFILE.JS to .gitignore

node_modules
.DS_Store
knexfile.js

CREATE MIGRATIONS

npx knex migrate:make 'MIGRATION_FILE_NAME.js' //Create your migration file//

npx knex migrate:up //Use your migration file//

CREATE YOUR SEED DATA

npx knex seed:make 'SEED_FILE_NAME.js' //CREATES SEED FILE//

npx knex seed:run || npx knex seed: run --specific 'FILENEAME.js' //RUNS SEED DATA//