{"action":"opened","number":3,"pull_request":{"url":"https://api.github.com/repos/MLsandbox/MLsandbox/pulls/3","id":146612947,"html_url":"https://github.com/MLsandbox/MLsandbox/pull/3","diff_url":"https://github.com/MLsandbox/MLsandbox/pull/3.diff","patch_url":"https://github.com/MLsandbox/MLsandbox/pull/3.patch","issue_url":"https://api.github.com/repos/MLsandbox/MLsandbox/issues/3","number":3,"state":"open","locked":false,"title":"AWS RDS PostgreSQL DB setup","user":{"login":"thismax","id":6326036,"avatar_url":"https://avatars0.githubusercontent.com/u/6326036?v=4","gravatar_id":"","url":"https://api.github.com/users/thismax","html_url":"https://github.com/thismax","followers_url":"https://api.github.com/users/thismax/followers","following_url":"https://api.github.com/users/thismax/following{/other_user}","gists_url":"https://api.github.com/users/thismax/gists{/gist_id}","starred_url":"https://api.github.com/users/thismax/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thismax/subscriptions","organizations_url":"https://api.github.com/users/thismax/orgs","repos_url":"https://api.github.com/users/thismax/repos","events_url":"https://api.github.com/users/thismax/events{/privacy}","received_events_url":"https://api.github.com/users/thismax/received_events","type":"User","site_admin":false},"body":"From root directory, run `touch db/aws.js` in a terminal window.  In your newly created `aws.js` file, add the following:\r\n\r\n```\r\nmodule.exports = {\r\n  name: '<INSTANCENAME>',\r\n  username: '<USERNAME>', \r\n  password: '<PASSWORD>',\r\n  host: '<ENDPOINT>',\r\n  port: <PORT>,\r\n};\r\n```\r\nTo query the database using termial, you'll need postgres and psql:\r\n\r\n- `brew install postrgres`\r\n- `psql --host=<HOST> --port=<POST> --username <USERNAME> --password --dbname=<DBNAME>`\r\n- with psql running, `\\dt` to view list of relations\r\n- with psql running, `SELECT * FROM <SCHEMA>.<NAME>` to view a specific model.","created_at":"2017-10-14T17:36:10Z","updated_at":"2017-10-14T17:36:10Z","closed_at":null,"merged_at":null,"merge_commit_sha":null,"assignee":null,"assignees":[],"requested_reviewers":[],"milestone":null,"commits_url":"https://api.github.com/repos/MLsandbox/MLsandbox/pulls/3/commits","review_comments_url":"https://api.github.com/repos/MLsandbox/MLsandbox/pulls/3/comments","review_comment_url":"https://api.github.com/repos/MLsandbox/MLsandbox/pulls/comments{/number}","comments_url":"https://api.github.com/repos/MLsandbox/MLsandbox/issues/3/comments","statuses_url":"https://api.github.com/repos/MLsandbox/MLsandbox/statuses/8a95b362945cd36645e5d7c223802dc60de17a38","head":{"label":"thismax:master","ref":"master","sha":"8a95b362945cd36645e5d7c223802dc60de17a38","user":{"login":"thismax","id":6326036,"avatar_url":"https://avatars0.githubusercontent.com/u/6326036?v=4","gravatar_id":"","url":"https://api.github.com/users/thismax","html_url":"https://github.com/thismax","followers_url":"https://api.github.com/users/thismax/followers","following_url":"https://api.github.com/users/thismax/following{/other_user}","gists_url":"https://api.github.com/users/thismax/gists{/gist_id}","starred_url":"https://api.github.com/users/thismax/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thismax/subscriptions","organizations_url":"https://api.github.com/users/thismax/orgs","repos_url":"https://api.github.com/users/thismax/repos","events_url":"https://api.github.com/users/thismax/events{/privacy}","received_events_url":"https://api.github.com/users/thismax/received_events","type":"User","site_admin":false},"repo":{"id":106744303,"name":"MLsandbox","full_name":"thismax/MLsandbox","owner":{"login":"thismax","id":6326036,"avatar_url":"https://avatars0.githubusercontent.com/u/6326036?v=4","gravatar_id":"","url":"https://api.github.com/users/thismax","html_url":"https://github.com/thismax","followers_url":"https://api.github.com/users/thismax/followers","following_url":"https://api.github.com/users/thismax/following{/other_user}","gists_url":"https://api.github.com/users/thismax/gists{/gist_id}","starred_url":"https://api.github.com/users/thismax/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thismax/subscriptions","organizations_url":"https://api.github.com/users/thismax/orgs","repos_url":"https://api.github.com/users/thismax/repos","events_url":"https://api.github.com/users/thismax/events{/privacy}","received_events_url":"https://api.github.com/users/thismax/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/thismax/MLsandbox","description":"an educational machine-learning sandbox","fork":true,"url":"https://api.github.com/repos/thismax/MLsandbox","forks_url":"https://api.github.com/repos/thismax/MLsandbox/forks","keys_url":"https://api.github.com/repos/thismax/MLsandbox/keys{/key_id}","collaborators_url":"https://api.github.com/repos/thismax/MLsandbox/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/thismax/MLsandbox/teams","hooks_url":"https://api.github.com/repos/thismax/MLsandbox/hooks","issue_events_url":"https://api.github.com/repos/thismax/MLsandbox/issues/events{/number}","events_url":"https://api.github.com/repos/thismax/MLsandbox/events","assignees_url":"https://api.github.com/repos/thismax/MLsandbox/assignees{/user}","branches_url":"https://api.github.com/repos/thismax/MLsandbox/branches{/branch}","tags_url":"https://api.github.com/repos/thismax/MLsandbox/tags","blobs_url":"https://api.github.com/repos/thismax/MLsandbox/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/thismax/MLsandbox/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/thismax/MLsandbox/git/refs{/sha}","trees_url":"https://api.github.com/repos/thismax/MLsandbox/git/trees{/sha}","statuses_url":"https://api.github.com/repos/thismax/MLsandbox/statuses/{sha}","languages_url":"https://api.github.com/repos/thismax/MLsandbox/languages","stargazers_url":"https://api.github.com/repos/thismax/MLsandbox/stargazers","contributors_url":"https://api.github.com/repos/thismax/MLsandbox/contributors","subscribers_url":"https://api.github.com/repos/thismax/MLsandbox/subscribers","subscription_url":"https://api.github.com/repos/thismax/MLsandbox/subscription","commits_url":"https://api.github.com/repos/thismax/MLsandbox/commits{/sha}","git_commits_url":"https://api.github.com/repos/thismax/MLsandbox/git/commits{/sha}","comments_url":"https://api.github.com/repos/thismax/MLsandbox/comments{/number}","issue_comment_url":"https://api.github.com/repos/thismax/MLsandbox/issues/comments{/number}","contents_url":"https://api.github.com/repos/thismax/MLsandbox/contents/{+path}","compare_url":"https://api.github.com/repos/thismax/MLsandbox/compare/{base}...{head}","merges_url":"https://api.github.com/repos/thismax/MLsandbox/merges","archive_url":"https://api.github.com/repos/thismax/MLsandbox/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/thismax/MLsandbox/downloads","issues_url":"https://api.github.com/repos/thismax/MLsandbox/issues{/number}","pulls_url":"https://api.github.com/repos/thismax/MLsandbox/pulls{/number}","milestones_url":"https://api.github.com/repos/thismax/MLsandbox/milestones{/number}","notifications_url":"https://api.github.com/repos/thismax/MLsandbox/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/thismax/MLsandbox/labels{/name}","releases_url":"https://api.github.com/repos/thismax/MLsandbox/releases{/id}","deployments_url":"https://api.github.com/repos/thismax/MLsandbox/deployments","created_at":"2017-10-12T20:54:57Z","updated_at":"2017-10-13T02:53:17Z","pushed_at":"2017-10-14T17:23:42Z","git_url":"git://github.com/thismax/MLsandbox.git","ssh_url":"git@github.com:thismax/MLsandbox.git","clone_url":"https://github.com/thismax/MLsandbox.git","svn_url":"https://github.com/thismax/MLsandbox","homepage":null,"size":23,"stargazers_count":0,"watchers_count":0,"language":"JavaScript","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"MLsandbox:master","ref":"master","sha":"c772bf926774ce77420a50961ff670a2f6528a9e","user":{"login":"MLsandbox","id":32720774,"avatar_url":"https://avatars0.githubusercontent.com/u/32720774?v=4","gravatar_id":"","url":"https://api.github.com/users/MLsandbox","html_url":"https://github.com/MLsandbox","followers_url":"https://api.github.com/users/MLsandbox/followers","following_url":"https://api.github.com/users/MLsandbox/following{/other_user}","gists_url":"https://api.github.com/users/MLsandbox/gists{/gist_id}","starred_url":"https://api.github.com/users/MLsandbox/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MLsandbox/subscriptions","organizations_url":"https://api.github.com/users/MLsandbox/orgs","repos_url":"https://api.github.com/users/MLsandbox/repos","events_url":"https://api.github.com/users/MLsandbox/events{/privacy}","received_events_url":"https://api.github.com/users/MLsandbox/received_events","type":"Organization","site_admin":false},"repo":{"id":106744258,"name":"MLsandbox","full_name":"MLsandbox/MLsandbox","owner":{"login":"MLsandbox","id":32720774,"avatar_url":"https://avatars0.githubusercontent.com/u/32720774?v=4","gravatar_id":"","url":"https://api.github.com/users/MLsandbox","html_url":"https://github.com/MLsandbox","followers_url":"https://api.github.com/users/MLsandbox/followers","following_url":"https://api.github.com/users/MLsandbox/following{/other_user}","gists_url":"https://api.github.com/users/MLsandbox/gists{/gist_id}","starred_url":"https://api.github.com/users/MLsandbox/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MLsandbox/subscriptions","organizations_url":"https://api.github.com/users/MLsandbox/orgs","repos_url":"https://api.github.com/users/MLsandbox/repos","events_url":"https://api.github.com/users/MLsandbox/events{/privacy}","received_events_url":"https://api.github.com/users/MLsandbox/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/MLsandbox/MLsandbox","description":"an educational machine-learning sandbox","fork":false,"url":"https://api.github.com/repos/MLsandbox/MLsandbox","forks_url":"https://api.github.com/repos/MLsandbox/MLsandbox/forks","keys_url":"https://api.github.com/repos/MLsandbox/MLsandbox/keys{/key_id}","collaborators_url":"https://api.github.com/repos/MLsandbox/MLsandbox/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/MLsandbox/MLsandbox/teams","hooks_url":"https://api.github.com/repos/MLsandbox/MLsandbox/hooks","issue_events_url":"https://api.github.com/repos/MLsandbox/MLsandbox/issues/events{/number}","events_url":"https://api.github.com/repos/MLsandbox/MLsandbox/events","assignees_url":"https://api.github.com/repos/MLsandbox/MLsandbox/assignees{/user}","branches_url":"https://api.github.com/repos/MLsandbox/MLsandbox/branches{/branch}","tags_url":"https://api.github.com/repos/MLsandbox/MLsandbox/tags","blobs_url":"https://api.github.com/repos/MLsandbox/MLsandbox/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/MLsandbox/MLsandbox/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/MLsandbox/MLsandbox/git/refs{/sha}","trees_url":"https://api.github.com/repos/MLsandbox/MLsandbox/git/trees{/sha}","statuses_url":"https://api.github.com/repos/MLsandbox/MLsandbox/statuses/{sha}","languages_url":"https://api.github.com/repos/MLsandbox/MLsandbox/languages","stargazers_url":"https://api.github.com/repos/MLsandbox/MLsandbox/stargazers","contributors_url":"https://api.github.com/repos/MLsandbox/MLsandbox/contributors","subscribers_url":"https://api.github.com/repos/MLsandbox/MLsandbox/subscribers","subscription_url":"https://api.github.com/repos/MLsandbox/MLsandbox/subscription","commits_url":"https://api.github.com/repos/MLsandbox/MLsandbox/commits{/sha}","git_commits_url":"https://api.github.com/repos/MLsandbox/MLsandbox/git/commits{/sha}","comments_url":"https://api.github.com/repos/MLsandbox/MLsandbox/comments{/number}","issue_comment_url":"https://api.github.com/repos/MLsandbox/MLsandbox/issues/comments{/number}","contents_url":"https://api.github.com/repos/MLsandbox/MLsandbox/contents/{+path}","compare_url":"https://api.github.com/repos/MLsandbox/MLsandbox/compare/{base}...{head}","merges_url":"https://api.github.com/repos/MLsandbox/MLsandbox/merges","archive_url":"https://api.github.com/repos/MLsandbox/MLsandbox/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/MLsandbox/MLsandbox/downloads","issues_url":"https://api.github.com/repos/MLsandbox/MLsandbox/issues{/number}","pulls_url":"https://api.github.com/repos/MLsandbox/MLsandbox/pulls{/number}","milestones_url":"https://api.github.com/repos/MLsandbox/MLsandbox/milestones{/number}","notifications_url":"https://api.github.com/repos/MLsandbox/MLsandbox/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/MLsandbox/MLsandbox/labels{/name}","releases_url":"https://api.github.com/repos/MLsandbox/MLsandbox/releases{/id}","deployments_url":"https://api.github.com/repos/MLsandbox/MLsandbox/deployments","created_at":"2017-10-12T20:54:28Z","updated_at":"2017-10-13T02:53:51Z","pushed_at":"2017-10-13T02:53:50Z","git_url":"git://github.com/MLsandbox/MLsandbox.git","ssh_url":"git@github.com:MLsandbox/MLsandbox.git","clone_url":"https://github.com/MLsandbox/MLsandbox.git","svn_url":"https://github.com/MLsandbox/MLsandbox","homepage":null,"size":24,"stargazers_count":0,"watchers_count":0,"language":"JavaScript","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":2,"mirror_url":null,"open_issues_count":1,"forks":2,"open_issues":1,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/MLsandbox/MLsandbox/pulls/3"},"html":{"href":"https://github.com/MLsandbox/MLsandbox/pull/3"},"issue":{"href":"https://api.github.com/repos/MLsandbox/MLsandbox/issues/3"},"comments":{"href":"https://api.github.com/repos/MLsandbox/MLsandbox/issues/3/comments"},"review_comments":{"href":"https://api.github.com/repos/MLsandbox/MLsandbox/pulls/3/comments"},"review_comment":{"href":"https://api.github.com/repos/MLsandbox/MLsandbox/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/MLsandbox/MLsandbox/pulls/3/commits"},"statuses":{"href":"https://api.github.com/repos/MLsandbox/MLsandbox/statuses/8a95b362945cd36645e5d7c223802dc60de17a38"}},"author_association":"CONTRIBUTOR","merged":false,"mergeable":null,"rebaseable":null,"mergeable_state":"unknown","merged_by":null,"comments":0,"review_comments":0,"maintainer_can_modify":true,"commits":4,"additions":343,"deletions":200,"changed_files":4}}
{"actor":{"display_login":"thismax"}}