{"action":"created","comment":{"url":"https://api.github.com/repos/makersacademy/chitter-challenge/pulls/comments/253403071","pull_request_review_id":199504983,"id":253403071,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDI1MzQwMzA3MQ==","diff_hunk":"@@ -1,3 +1,4 @@\n CREATE DATABASE chitter;\n CREATE TABLE peeps(id SERIAL PRIMARY KEY, peeps VARCHAR(60));\n--- ALTER TABLE peeps ADD COLUMN title VARCHAR(60);\n\\ No newline at end of file\n+ALTER TABLE peeps ADD COLUMN timestamp timestamp with time zone;","path":"db/migrations/create_chitter_table.sql","position":3,"original_position":5,"commit_id":"295e3a6cb078919850e830495e763e45556aaa29","original_commit_id":"c42ec0d013f7f62e27f397b69e91b5651257d067","user":{"login":"JPProgrammingTime","id":41450070,"node_id":"MDQ6VXNlcjQxNDUwMDcw","avatar_url":"https://avatars2.githubusercontent.com/u/41450070?v=4","gravatar_id":"","url":"https://api.github.com/users/JPProgrammingTime","html_url":"https://github.com/JPProgrammingTime","followers_url":"https://api.github.com/users/JPProgrammingTime/followers","following_url":"https://api.github.com/users/JPProgrammingTime/following{/other_user}","gists_url":"https://api.github.com/users/JPProgrammingTime/gists{/gist_id}","starred_url":"https://api.github.com/users/JPProgrammingTime/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JPProgrammingTime/subscriptions","organizations_url":"https://api.github.com/users/JPProgrammingTime/orgs","repos_url":"https://api.github.com/users/JPProgrammingTime/repos","events_url":"https://api.github.com/users/JPProgrammingTime/events{/privacy}","received_events_url":"https://api.github.com/users/JPProgrammingTime/received_events","type":"User","site_admin":false},"body":"Nice, I did not think about the time zone. Mine is just the time of post, did not know you could do this. ","created_at":"2019-02-04T09:57:43Z","updated_at":"2019-02-04T09:57:44Z","html_url":"https://github.com/makersacademy/chitter-challenge/pull/1127#discussion_r253403071","pull_request_url":"https://api.github.com/repos/makersacademy/chitter-challenge/pulls/1127","author_association":"NONE","_links":{"self":{"href":"https://api.github.com/repos/makersacademy/chitter-challenge/pulls/comments/253403071"},"html":{"href":"https://github.com/makersacademy/chitter-challenge/pull/1127#discussion_r253403071"},"pull_request":{"href":"https://api.github.com/repos/makersacademy/chitter-challenge/pulls/1127"}}},"pull_request":{"url":"https://api.github.com/repos/makersacademy/chitter-challenge/pulls/1127","id":249910761,"node_id":"MDExOlB1bGxSZXF1ZXN0MjQ5OTEwNzYx","html_url":"https://github.com/makersacademy/chitter-challenge/pull/1127","diff_url":"https://github.com/makersacademy/chitter-challenge/pull/1127.diff","patch_url":"https://github.com/makersacademy/chitter-challenge/pull/1127.patch","issue_url":"https://api.github.com/repos/makersacademy/chitter-challenge/issues/1127","number":1127,"state":"open","locked":false,"title":"Completed STRAIGHT UP & ADVANCED challenges","user":{"login":"nkhil","id":2021600,"node_id":"MDQ6VXNlcjIwMjE2MDA=","avatar_url":"https://avatars0.githubusercontent.com/u/2021600?v=4","gravatar_id":"","url":"https://api.github.com/users/nkhil","html_url":"https://github.com/nkhil","followers_url":"https://api.github.com/users/nkhil/followers","following_url":"https://api.github.com/users/nkhil/following{/other_user}","gists_url":"https://api.github.com/users/nkhil/gists{/gist_id}","starred_url":"https://api.github.com/users/nkhil/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nkhil/subscriptions","organizations_url":"https://api.github.com/users/nkhil/orgs","repos_url":"https://api.github.com/users/nkhil/repos","events_url":"https://api.github.com/users/nkhil/events{/privacy}","received_events_url":"https://api.github.com/users/nkhil/received_events","type":"User","site_admin":false},"body":"Completed `STRAIGHT UP` and `ADVANCED` user stories. \r\n\r\n**Goal: I can refactor anything**\r\n\r\nPlease take a look at the following commits for this project:\r\n\r\n- refactor to setup DatabaseConnection object (e6d451e)\r\n- refactor user.rb to use DatabaseConnection (e6d451e)\r\n\r\nI've tried to DRY out my code as much as possible by creating a separate `DatabaseConnection` class to abstract out this responsibility. \r\n\r\nI have also refactored the code to make sure it doesn't exceed the 80 character limit by adding line breaks in the PSQL queries making it easier to read and comprehend. \r\n\r\nIn addition, also note the `formatted_date` and `formatted_time` instance methods in `Peep` that were refactored to display a more semantic time. ","created_at":"2019-02-03T22:57:53Z","updated_at":"2019-02-04T09:57:44Z","closed_at":null,"merged_at":null,"merge_commit_sha":"acddd020ed1a68976823d54df0290a3c235bc1f6","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/makersacademy/chitter-challenge/pulls/1127/commits","review_comments_url":"https://api.github.com/repos/makersacademy/chitter-challenge/pulls/1127/comments","review_comment_url":"https://api.github.com/repos/makersacademy/chitter-challenge/pulls/comments{/number}","comments_url":"https://api.github.com/repos/makersacademy/chitter-challenge/issues/1127/comments","statuses_url":"https://api.github.com/repos/makersacademy/chitter-challenge/statuses/295e3a6cb078919850e830495e763e45556aaa29","head":{"label":"nkhil:master","ref":"master","sha":"295e3a6cb078919850e830495e763e45556aaa29","user":{"login":"nkhil","id":2021600,"node_id":"MDQ6VXNlcjIwMjE2MDA=","avatar_url":"https://avatars0.githubusercontent.com/u/2021600?v=4","gravatar_id":"","url":"https://api.github.com/users/nkhil","html_url":"https://github.com/nkhil","followers_url":"https://api.github.com/users/nkhil/followers","following_url":"https://api.github.com/users/nkhil/following{/other_user}","gists_url":"https://api.github.com/users/nkhil/gists{/gist_id}","starred_url":"https://api.github.com/users/nkhil/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nkhil/subscriptions","organizations_url":"https://api.github.com/users/nkhil/orgs","repos_url":"https://api.github.com/users/nkhil/repos","events_url":"https://api.github.com/users/nkhil/events{/privacy}","received_events_url":"https://api.github.com/users/nkhil/received_events","type":"User","site_admin":false},"repo":{"id":168501714,"node_id":"MDEwOlJlcG9zaXRvcnkxNjg1MDE3MTQ=","name":"chitter-challenge","full_name":"nkhil/chitter-challenge","private":false,"owner":{"login":"nkhil","id":2021600,"node_id":"MDQ6VXNlcjIwMjE2MDA=","avatar_url":"https://avatars0.githubusercontent.com/u/2021600?v=4","gravatar_id":"","url":"https://api.github.com/users/nkhil","html_url":"https://github.com/nkhil","followers_url":"https://api.github.com/users/nkhil/followers","following_url":"https://api.github.com/users/nkhil/following{/other_user}","gists_url":"https://api.github.com/users/nkhil/gists{/gist_id}","starred_url":"https://api.github.com/users/nkhil/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nkhil/subscriptions","organizations_url":"https://api.github.com/users/nkhil/orgs","repos_url":"https://api.github.com/users/nkhil/repos","events_url":"https://api.github.com/users/nkhil/events{/privacy}","received_events_url":"https://api.github.com/users/nkhil/received_events","type":"User","site_admin":false},"html_url":"https://github.com/nkhil/chitter-challenge","description":"Makers week 4 weekend challenge: Build a twitter clone using Sinatra and Postgres","fork":true,"url":"https://api.github.com/repos/nkhil/chitter-challenge","forks_url":"https://api.github.com/repos/nkhil/chitter-challenge/forks","keys_url":"https://api.github.com/repos/nkhil/chitter-challenge/keys{/key_id}","collaborators_url":"https://api.github.com/repos/nkhil/chitter-challenge/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/nkhil/chitter-challenge/teams","hooks_url":"https://api.github.com/repos/nkhil/chitter-challenge/hooks","issue_events_url":"https://api.github.com/repos/nkhil/chitter-challenge/issues/events{/number}","events_url":"https://api.github.com/repos/nkhil/chitter-challenge/events","assignees_url":"https://api.github.com/repos/nkhil/chitter-challenge/assignees{/user}","branches_url":"https://api.github.com/repos/nkhil/chitter-challenge/branches{/branch}","tags_url":"https://api.github.com/repos/nkhil/chitter-challenge/tags","blobs_url":"https://api.github.com/repos/nkhil/chitter-challenge/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/nkhil/chitter-challenge/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/nkhil/chitter-challenge/git/refs{/sha}","trees_url":"https://api.github.com/repos/nkhil/chitter-challenge/git/trees{/sha}","statuses_url":"https://api.github.com/repos/nkhil/chitter-challenge/statuses/{sha}","languages_url":"https://api.github.com/repos/nkhil/chitter-challenge/languages","stargazers_url":"https://api.github.com/repos/nkhil/chitter-challenge/stargazers","contributors_url":"https://api.github.com/repos/nkhil/chitter-challenge/contributors","subscribers_url":"https://api.github.com/repos/nkhil/chitter-challenge/subscribers","subscription_url":"https://api.github.com/repos/nkhil/chitter-challenge/subscription","commits_url":"https://api.github.com/repos/nkhil/chitter-challenge/commits{/sha}","git_commits_url":"https://api.github.com/repos/nkhil/chitter-challenge/git/commits{/sha}","comments_url":"https://api.github.com/repos/nkhil/chitter-challenge/comments{/number}","issue_comment_url":"https://api.github.com/repos/nkhil/chitter-challenge/issues/comments{/number}","contents_url":"https://api.github.com/repos/nkhil/chitter-challenge/contents/{+path}","compare_url":"https://api.github.com/repos/nkhil/chitter-challenge/compare/{base}...{head}","merges_url":"https://api.github.com/repos/nkhil/chitter-challenge/merges","archive_url":"https://api.github.com/repos/nkhil/chitter-challenge/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/nkhil/chitter-challenge/downloads","issues_url":"https://api.github.com/repos/nkhil/chitter-challenge/issues{/number}","pulls_url":"https://api.github.com/repos/nkhil/chitter-challenge/pulls{/number}","milestones_url":"https://api.github.com/repos/nkhil/chitter-challenge/milestones{/number}","notifications_url":"https://api.github.com/repos/nkhil/chitter-challenge/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/nkhil/chitter-challenge/labels{/name}","releases_url":"https://api.github.com/repos/nkhil/chitter-challenge/releases{/id}","deployments_url":"https://api.github.com/repos/nkhil/chitter-challenge/deployments","created_at":"2019-01-31T09:51:29Z","updated_at":"2019-02-03T22:42:40Z","pushed_at":"2019-02-03T22:34:28Z","git_url":"git://github.com/nkhil/chitter-challenge.git","ssh_url":"git@github.com:nkhil/chitter-challenge.git","clone_url":"https://github.com/nkhil/chitter-challenge.git","svn_url":"https://github.com/nkhil/chitter-challenge","homepage":"","size":433,"stargazers_count":0,"watchers_count":0,"language":"Ruby","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":null,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"makersacademy:master","ref":"master","sha":"f3fb60ffaed1ab6dbea449c1a808d7a2f78a90c4","user":{"login":"makersacademy","id":3636186,"node_id":"MDEyOk9yZ2FuaXphdGlvbjM2MzYxODY=","avatar_url":"https://avatars2.githubusercontent.com/u/3636186?v=4","gravatar_id":"","url":"https://api.github.com/users/makersacademy","html_url":"https://github.com/makersacademy","followers_url":"https://api.github.com/users/makersacademy/followers","following_url":"https://api.github.com/users/makersacademy/following{/other_user}","gists_url":"https://api.github.com/users/makersacademy/gists{/gist_id}","starred_url":"https://api.github.com/users/makersacademy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/makersacademy/subscriptions","organizations_url":"https://api.github.com/users/makersacademy/orgs","repos_url":"https://api.github.com/users/makersacademy/repos","events_url":"https://api.github.com/users/makersacademy/events{/privacy}","received_events_url":"https://api.github.com/users/makersacademy/received_events","type":"Organization","site_admin":false},"repo":{"id":26954706,"node_id":"MDEwOlJlcG9zaXRvcnkyNjk1NDcwNg==","name":"chitter-challenge","full_name":"makersacademy/chitter-challenge","private":false,"owner":{"login":"makersacademy","id":3636186,"node_id":"MDEyOk9yZ2FuaXphdGlvbjM2MzYxODY=","avatar_url":"https://avatars2.githubusercontent.com/u/3636186?v=4","gravatar_id":"","url":"https://api.github.com/users/makersacademy","html_url":"https://github.com/makersacademy","followers_url":"https://api.github.com/users/makersacademy/followers","following_url":"https://api.github.com/users/makersacademy/following{/other_user}","gists_url":"https://api.github.com/users/makersacademy/gists{/gist_id}","starred_url":"https://api.github.com/users/makersacademy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/makersacademy/subscriptions","organizations_url":"https://api.github.com/users/makersacademy/orgs","repos_url":"https://api.github.com/users/makersacademy/repos","events_url":"https://api.github.com/users/makersacademy/events{/privacy}","received_events_url":"https://api.github.com/users/makersacademy/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/makersacademy/chitter-challenge","description":"Build a Twitter Clone!","fork":false,"url":"https://api.github.com/repos/makersacademy/chitter-challenge","forks_url":"https://api.github.com/repos/makersacademy/chitter-challenge/forks","keys_url":"https://api.github.com/repos/makersacademy/chitter-challenge/keys{/key_id}","collaborators_url":"https://api.github.com/repos/makersacademy/chitter-challenge/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/makersacademy/chitter-challenge/teams","hooks_url":"https://api.github.com/repos/makersacademy/chitter-challenge/hooks","issue_events_url":"https://api.github.com/repos/makersacademy/chitter-challenge/issues/events{/number}","events_url":"https://api.github.com/repos/makersacademy/chitter-challenge/events","assignees_url":"https://api.github.com/repos/makersacademy/chitter-challenge/assignees{/user}","branches_url":"https://api.github.com/repos/makersacademy/chitter-challenge/branches{/branch}","tags_url":"https://api.github.com/repos/makersacademy/chitter-challenge/tags","blobs_url":"https://api.github.com/repos/makersacademy/chitter-challenge/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/makersacademy/chitter-challenge/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/makersacademy/chitter-challenge/git/refs{/sha}","trees_url":"https://api.github.com/repos/makersacademy/chitter-challenge/git/trees{/sha}","statuses_url":"https://api.github.com/repos/makersacademy/chitter-challenge/statuses/{sha}","languages_url":"https://api.github.com/repos/makersacademy/chitter-challenge/languages","stargazers_url":"https://api.github.com/repos/makersacademy/chitter-challenge/stargazers","contributors_url":"https://api.github.com/repos/makersacademy/chitter-challenge/contributors","subscribers_url":"https://api.github.com/repos/makersacademy/chitter-challenge/subscribers","subscription_url":"https://api.github.com/repos/makersacademy/chitter-challenge/subscription","commits_url":"https://api.github.com/repos/makersacademy/chitter-challenge/commits{/sha}","git_commits_url":"https://api.github.com/repos/makersacademy/chitter-challenge/git/commits{/sha}","comments_url":"https://api.github.com/repos/makersacademy/chitter-challenge/comments{/number}","issue_comment_url":"https://api.github.com/repos/makersacademy/chitter-challenge/issues/comments{/number}","contents_url":"https://api.github.com/repos/makersacademy/chitter-challenge/contents/{+path}","compare_url":"https://api.github.com/repos/makersacademy/chitter-challenge/compare/{base}...{head}","merges_url":"https://api.github.com/repos/makersacademy/chitter-challenge/merges","archive_url":"https://api.github.com/repos/makersacademy/chitter-challenge/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/makersacademy/chitter-challenge/downloads","issues_url":"https://api.github.com/repos/makersacademy/chitter-challenge/issues{/number}","pulls_url":"https://api.github.com/repos/makersacademy/chitter-challenge/pulls{/number}","milestones_url":"https://api.github.com/repos/makersacademy/chitter-challenge/milestones{/number}","notifications_url":"https://api.github.com/repos/makersacademy/chitter-challenge/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/makersacademy/chitter-challenge/labels{/name}","releases_url":"https://api.github.com/repos/makersacademy/chitter-challenge/releases{/id}","deployments_url":"https://api.github.com/repos/makersacademy/chitter-challenge/deployments","created_at":"2014-11-21T09:53:31Z","updated_at":"2019-01-26T07:30:46Z","pushed_at":"2019-02-04T09:46:57Z","git_url":"git://github.com/makersacademy/chitter-challenge.git","ssh_url":"git@github.com:makersacademy/chitter-challenge.git","clone_url":"https://github.com/makersacademy/chitter-challenge.git","svn_url":"https://github.com/makersacademy/chitter-challenge","homepage":null,"size":399,"stargazers_count":8,"watchers_count":8,"language":"Ruby","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1128,"mirror_url":null,"archived":false,"open_issues_count":257,"license":null,"forks":1128,"open_issues":257,"watchers":8,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/makersacademy/chitter-challenge/pulls/1127"},"html":{"href":"https://github.com/makersacademy/chitter-challenge/pull/1127"},"issue":{"href":"https://api.github.com/repos/makersacademy/chitter-challenge/issues/1127"},"comments":{"href":"https://api.github.com/repos/makersacademy/chitter-challenge/issues/1127/comments"},"review_comments":{"href":"https://api.github.com/repos/makersacademy/chitter-challenge/pulls/1127/comments"},"review_comment":{"href":"https://api.github.com/repos/makersacademy/chitter-challenge/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/makersacademy/chitter-challenge/pulls/1127/commits"},"statuses":{"href":"https://api.github.com/repos/makersacademy/chitter-challenge/statuses/295e3a6cb078919850e830495e763e45556aaa29"}},"author_association":"NONE"}}
{"actor":{"display_login":"JPProgrammingTime"}}