Documentation for visiting database

[gemfarmer]

There should be documentation for visiting the database

• via command line using cf-ssh
  • login in to cloud foundry: cf login
    • set your ruby version to 2.3.1, rvm use ruby-2.3.1 (because we are on a later version than ruby-buildpack supports
    • run cf-ssh --verbose -f manifest.yml
  • https://docs.cloud.gov/getting-started/one-off-tasks/
• cloud.gov postgres client
  • the easiest way to do this is to login into cloud foundry: cf login, run cf env dolores-app and use the uri attribute produced there as the "Scheme" in https://pgweb.apps.cloud.gov/
  • add employees using this query template
    • INSERT INTO employees (id,created_at, updated_at, slack_username, started_on, time_zone, deleted_at, slack_channel_id) VALUES ([id], '2015-5-9T21:32:43.109879Z', '2015-5-9T21:32:43.109879Z', '[slack username]', '2015-05-02T00:00:00Z', 'Pacific Time (US & Canada)', NULL, NULL);