{"action":"closed","number":15,"pull_request":{"url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/pulls/15","id":90330787,"html_url":"https://github.com/RaphaelNash/CUNY-DATA-607-2-Group-Project/pull/15","diff_url":"https://github.com/RaphaelNash/CUNY-DATA-607-2-Group-Project/pull/15.diff","patch_url":"https://github.com/RaphaelNash/CUNY-DATA-607-2-Group-Project/pull/15.patch","issue_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/issues/15","number":15,"state":"closed","locked":false,"title":"Final (?) db updates","user":{"login":"tmuse987","id":20003748,"avatar_url":"https://avatars.githubusercontent.com/u/20003748?v=3","gravatar_id":"","url":"https://api.github.com/users/tmuse987","html_url":"https://github.com/tmuse987","followers_url":"https://api.github.com/users/tmuse987/followers","following_url":"https://api.github.com/users/tmuse987/following{/other_user}","gists_url":"https://api.github.com/users/tmuse987/gists{/gist_id}","starred_url":"https://api.github.com/users/tmuse987/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tmuse987/subscriptions","organizations_url":"https://api.github.com/users/tmuse987/orgs","repos_url":"https://api.github.com/users/tmuse987/repos","events_url":"https://api.github.com/users/tmuse987/events{/privacy}","received_events_url":"https://api.github.com/users/tmuse987/received_events","type":"User","site_admin":false},"body":"Two sql scripts, which will create two equivalent db's, one for wordcount and one for wordcountsuper, so we have separate instances to run the two r scripts and not conflict.\r\n\r\nUpdated the wordcount and wordcountsuper to read/write to db as needed.    \r\n\r\nDB_Layer updated as needed to make it work with more final versions of r scripts.\r\n\r\nNOTENOTENOTE, will need to update db_layer for your own db userid/password","created_at":"2016-10-21T06:47:33Z","updated_at":"2016-10-21T16:18:15Z","closed_at":"2016-10-21T16:18:15Z","merged_at":"2016-10-21T16:18:15Z","merge_commit_sha":"49191013337464edb04c75ec423d4dab182f7cf2","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/pulls/15/commits","review_comments_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/pulls/15/comments","review_comment_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/pulls/comments{/number}","comments_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/issues/15/comments","statuses_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/statuses/49191013337464edb04c75ec423d4dab182f7cf2","head":{"label":"tmuse987:master","ref":"master","sha":"49191013337464edb04c75ec423d4dab182f7cf2","user":{"login":"tmuse987","id":20003748,"avatar_url":"https://avatars.githubusercontent.com/u/20003748?v=3","gravatar_id":"","url":"https://api.github.com/users/tmuse987","html_url":"https://github.com/tmuse987","followers_url":"https://api.github.com/users/tmuse987/followers","following_url":"https://api.github.com/users/tmuse987/following{/other_user}","gists_url":"https://api.github.com/users/tmuse987/gists{/gist_id}","starred_url":"https://api.github.com/users/tmuse987/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tmuse987/subscriptions","organizations_url":"https://api.github.com/users/tmuse987/orgs","repos_url":"https://api.github.com/users/tmuse987/repos","events_url":"https://api.github.com/users/tmuse987/events{/privacy}","received_events_url":"https://api.github.com/users/tmuse987/received_events","type":"User","site_admin":false},"repo":{"id":71212193,"name":"CUNY-DATA-607-2-Group-Project","full_name":"tmuse987/CUNY-DATA-607-2-Group-Project","owner":{"login":"tmuse987","id":20003748,"avatar_url":"https://avatars.githubusercontent.com/u/20003748?v=3","gravatar_id":"","url":"https://api.github.com/users/tmuse987","html_url":"https://github.com/tmuse987","followers_url":"https://api.github.com/users/tmuse987/followers","following_url":"https://api.github.com/users/tmuse987/following{/other_user}","gists_url":"https://api.github.com/users/tmuse987/gists{/gist_id}","starred_url":"https://api.github.com/users/tmuse987/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tmuse987/subscriptions","organizations_url":"https://api.github.com/users/tmuse987/orgs","repos_url":"https://api.github.com/users/tmuse987/repos","events_url":"https://api.github.com/users/tmuse987/events{/privacy}","received_events_url":"https://api.github.com/users/tmuse987/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/tmuse987/CUNY-DATA-607-2-Group-Project","description":null,"fork":true,"url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project","forks_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/forks","keys_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/keys{/key_id}","collaborators_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/teams","hooks_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/hooks","issue_events_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/issues/events{/number}","events_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/events","assignees_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/assignees{/user}","branches_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/branches{/branch}","tags_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/tags","blobs_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/git/refs{/sha}","trees_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/git/trees{/sha}","statuses_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/statuses/{sha}","languages_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/languages","stargazers_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/stargazers","contributors_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/contributors","subscribers_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/subscribers","subscription_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/subscription","commits_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/commits{/sha}","git_commits_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/git/commits{/sha}","comments_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/comments{/number}","issue_comment_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/issues/comments{/number}","contents_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/contents/{+path}","compare_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/compare/{base}...{head}","merges_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/merges","archive_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/downloads","issues_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/issues{/number}","pulls_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/pulls{/number}","milestones_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/milestones{/number}","notifications_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/labels{/name}","releases_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/releases{/id}","deployments_url":"https://api.github.com/repos/tmuse987/CUNY-DATA-607-2-Group-Project/deployments","created_at":"2016-10-18T05:29:55Z","updated_at":"2016-10-18T05:29:56Z","pushed_at":"2016-10-21T06:42:12Z","git_url":"git://github.com/tmuse987/CUNY-DATA-607-2-Group-Project.git","ssh_url":"git@github.com:tmuse987/CUNY-DATA-607-2-Group-Project.git","clone_url":"https://github.com/tmuse987/CUNY-DATA-607-2-Group-Project.git","svn_url":"https://github.com/tmuse987/CUNY-DATA-607-2-Group-Project","homepage":null,"size":17,"stargazers_count":0,"watchers_count":0,"language":"R","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":1,"forks":0,"open_issues":1,"watchers":0,"default_branch":"master"}},"base":{"label":"RaphaelNash:master","ref":"master","sha":"5e097d6ec91a37a2c35a801327d5c3e36ff6fa5e","user":{"login":"RaphaelNash","id":8764338,"avatar_url":"https://avatars.githubusercontent.com/u/8764338?v=3","gravatar_id":"","url":"https://api.github.com/users/RaphaelNash","html_url":"https://github.com/RaphaelNash","followers_url":"https://api.github.com/users/RaphaelNash/followers","following_url":"https://api.github.com/users/RaphaelNash/following{/other_user}","gists_url":"https://api.github.com/users/RaphaelNash/gists{/gist_id}","starred_url":"https://api.github.com/users/RaphaelNash/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RaphaelNash/subscriptions","organizations_url":"https://api.github.com/users/RaphaelNash/orgs","repos_url":"https://api.github.com/users/RaphaelNash/repos","events_url":"https://api.github.com/users/RaphaelNash/events{/privacy}","received_events_url":"https://api.github.com/users/RaphaelNash/received_events","type":"User","site_admin":false},"repo":{"id":70368127,"name":"CUNY-DATA-607-2-Group-Project","full_name":"RaphaelNash/CUNY-DATA-607-2-Group-Project","owner":{"login":"RaphaelNash","id":8764338,"avatar_url":"https://avatars.githubusercontent.com/u/8764338?v=3","gravatar_id":"","url":"https://api.github.com/users/RaphaelNash","html_url":"https://github.com/RaphaelNash","followers_url":"https://api.github.com/users/RaphaelNash/followers","following_url":"https://api.github.com/users/RaphaelNash/following{/other_user}","gists_url":"https://api.github.com/users/RaphaelNash/gists{/gist_id}","starred_url":"https://api.github.com/users/RaphaelNash/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RaphaelNash/subscriptions","organizations_url":"https://api.github.com/users/RaphaelNash/orgs","repos_url":"https://api.github.com/users/RaphaelNash/repos","events_url":"https://api.github.com/users/RaphaelNash/events{/privacy}","received_events_url":"https://api.github.com/users/RaphaelNash/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/RaphaelNash/CUNY-DATA-607-2-Group-Project","description":null,"fork":false,"url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project","forks_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/forks","keys_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/keys{/key_id}","collaborators_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/teams","hooks_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/hooks","issue_events_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/issues/events{/number}","events_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/events","assignees_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/assignees{/user}","branches_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/branches{/branch}","tags_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/tags","blobs_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/git/refs{/sha}","trees_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/git/trees{/sha}","statuses_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/statuses/{sha}","languages_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/languages","stargazers_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/stargazers","contributors_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/contributors","subscribers_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/subscribers","subscription_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/subscription","commits_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/commits{/sha}","git_commits_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/git/commits{/sha}","comments_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/comments{/number}","issue_comment_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/issues/comments{/number}","contents_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/contents/{+path}","compare_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/compare/{base}...{head}","merges_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/merges","archive_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/downloads","issues_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/issues{/number}","pulls_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/pulls{/number}","milestones_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/milestones{/number}","notifications_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/labels{/name}","releases_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/releases{/id}","deployments_url":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/deployments","created_at":"2016-10-09T01:42:11Z","updated_at":"2016-10-20T03:25:46Z","pushed_at":"2016-10-21T16:18:15Z","git_url":"git://github.com/RaphaelNash/CUNY-DATA-607-2-Group-Project.git","ssh_url":"git@github.com:RaphaelNash/CUNY-DATA-607-2-Group-Project.git","clone_url":"https://github.com/RaphaelNash/CUNY-DATA-607-2-Group-Project.git","svn_url":"https://github.com/RaphaelNash/CUNY-DATA-607-2-Group-Project","homepage":null,"size":2533,"stargazers_count":0,"watchers_count":0,"language":"HTML","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":6,"mirror_url":null,"open_issues_count":1,"forks":6,"open_issues":1,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/pulls/15"},"html":{"href":"https://github.com/RaphaelNash/CUNY-DATA-607-2-Group-Project/pull/15"},"issue":{"href":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/issues/15"},"comments":{"href":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/issues/15/comments"},"review_comments":{"href":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/pulls/15/comments"},"review_comment":{"href":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/pulls/15/commits"},"statuses":{"href":"https://api.github.com/repos/RaphaelNash/CUNY-DATA-607-2-Group-Project/statuses/49191013337464edb04c75ec423d4dab182f7cf2"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"login":"RaphaelNash","id":8764338,"avatar_url":"https://avatars.githubusercontent.com/u/8764338?v=3","gravatar_id":"","url":"https://api.github.com/users/RaphaelNash","html_url":"https://github.com/RaphaelNash","followers_url":"https://api.github.com/users/RaphaelNash/followers","following_url":"https://api.github.com/users/RaphaelNash/following{/other_user}","gists_url":"https://api.github.com/users/RaphaelNash/gists{/gist_id}","starred_url":"https://api.github.com/users/RaphaelNash/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RaphaelNash/subscriptions","organizations_url":"https://api.github.com/users/RaphaelNash/orgs","repos_url":"https://api.github.com/users/RaphaelNash/repos","events_url":"https://api.github.com/users/RaphaelNash/events{/privacy}","received_events_url":"https://api.github.com/users/RaphaelNash/received_events","type":"User","site_admin":false},"comments":0,"review_comments":0,"commits":1,"additions":1069,"deletions":0,"changed_files":5}}
{"actor":{"display_login":"RaphaelNash"}}