Use Knex and configure for deployment

[ap2322]

PIVOT from sequelize to knex to connect to our database.

• https://devhints.io/knex
• http://knexjs.org/

This branch is successfully deployed to Heroku. To run knex commands use heroku run. For example, to {drop,create,migrate,seed} the heroku database perform the following commands:

heroku pg:reset DATABASE 
// (confirm the reset of the db)
heroku run knex migrate:latest
heroku run knex seed:run

Locally to reset your database:

1. get into psql in the terminal to drop the database

   psql -U postgres
   DROP DATABASE tweet_311_denver_service_dev;
   DROP DATABASE tweet_311_denver_service_test;

2. Before exiting psql, create your dbs:

   CREATE DATABASE tweet_311_denver_service_dev;
   CREATE DATABASE tweet_311_denver_service_test;
   exit

3. Run your knex migrations for dev (default) and test --env test in your terminal (not within psql)

   knex migrate:latest 
   knex seed:run
   knex migrate:latest --env test
   knex seed:run --env test

• Adds .travis.yml for CI

• Configures ports for deployment and local host

• Reconnects knex to our routes. Could use a refactor to follow a model template

• [x] tests still pass, no tests added. Run npx lab to see if tests pass.

• [ ] Closes #5