{"action":"created","comment":{"url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/pulls/comments/108009139","pull_request_review_id":29020606,"id":108009139,"diff_hunk":"@@ -142,7 +136,7 @@ app.listen(PORT, function() {\n \n //////// ** DATABASE LOADER ** ////////\n ////////////////////////////////////////\n-// NOTE:\n+// NOTE: This function loads the data from the articles and inserts them into a table.  This represents steps 3 and 4 and represents the update stage of CRUD.  This function queries the articles in the Database, parses the data into rows starting at row zero.  It then reads the file data in the JSON file and parses it. The client can then insert new article elements into the table following the contructor template below.","path":"starter-code/server.js","position":88,"original_position":88,"commit_id":"341bf4987c0f864affb2226f8b35b5fccbf3ff1c","original_commit_id":"341bf4987c0f864affb2226f8b35b5fccbf3ff1c","user":{"login":"Bl41r","id":18507197,"avatar_url":"https://avatars0.githubusercontent.com/u/18507197?v=3","gravatar_id":"","url":"https://api.github.com/users/Bl41r","html_url":"https://github.com/Bl41r","followers_url":"https://api.github.com/users/Bl41r/followers","following_url":"https://api.github.com/users/Bl41r/following{/other_user}","gists_url":"https://api.github.com/users/Bl41r/gists{/gist_id}","starred_url":"https://api.github.com/users/Bl41r/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Bl41r/subscriptions","organizations_url":"https://api.github.com/users/Bl41r/orgs","repos_url":"https://api.github.com/users/Bl41r/repos","events_url":"https://api.github.com/users/Bl41r/events{/privacy}","received_events_url":"https://api.github.com/users/Bl41r/received_events","type":"User","site_admin":false},"body":"Although...if the data is not there it creates, so I guess this is technically right","created_at":"2017-03-24T22:13:27Z","updated_at":"2017-03-24T22:13:27Z","html_url":"https://github.com/codefellows-seattle-301d18/08-sql-intro/pull/18#discussion_r108009139","pull_request_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/pulls/18","_links":{"self":{"href":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/pulls/comments/108009139"},"html":{"href":"https://github.com/codefellows-seattle-301d18/08-sql-intro/pull/18#discussion_r108009139"},"pull_request":{"href":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/pulls/18"}}},"pull_request":{"url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/pulls/18","id":112505602,"html_url":"https://github.com/codefellows-seattle-301d18/08-sql-intro/pull/18","diff_url":"https://github.com/codefellows-seattle-301d18/08-sql-intro/pull/18.diff","patch_url":"https://github.com/codefellows-seattle-301d18/08-sql-intro/pull/18.patch","issue_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/issues/18","number":18,"state":"open","locked":false,"title":"Isakdrive kaylanav","user":{"login":"Kdasay16","id":24254047,"avatar_url":"https://avatars0.githubusercontent.com/u/24254047?v=3","gravatar_id":"","url":"https://api.github.com/users/Kdasay16","html_url":"https://github.com/Kdasay16","followers_url":"https://api.github.com/users/Kdasay16/followers","following_url":"https://api.github.com/users/Kdasay16/following{/other_user}","gists_url":"https://api.github.com/users/Kdasay16/gists{/gist_id}","starred_url":"https://api.github.com/users/Kdasay16/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kdasay16/subscriptions","organizations_url":"https://api.github.com/users/Kdasay16/orgs","repos_url":"https://api.github.com/users/Kdasay16/repos","events_url":"https://api.github.com/users/Kdasay16/events{/privacy}","received_events_url":"https://api.github.com/users/Kdasay16/received_events","type":"User","site_admin":false},"body":"#### Single-line Summary\r\n**Today, Isak and Kayla paired together. It took about 2.5hours**\r\n\r\n#### Reflect and summarize on your process for each `TODO` item :  \r\n  1. First, we started on the code writing.\r\n  2. Next, we worked our way down the notes.\r\n  3. We also created a table in SQL \r\n\r\n#### Checklist (before submitting, fill in each set of square brackets with an 'x')\r\n- [x] We have titled the Pull Request similar to our branch name (ex: 'brian-rick'). \r\n- [x] This PR includes commits from both myself and my partner; e.g. We followed good pair programming practices by switching driver/navigator roles.\r\n- [x] There is no extraneous, unrelated code included in this PR.\r\n- [x] We have summarized our `TODO:` process above.\r\n","created_at":"2017-03-24T17:25:31Z","updated_at":"2017-03-24T22:13:27Z","closed_at":null,"merged_at":null,"merge_commit_sha":"5768a1dc8d3d46fbb422b34939110081b47aecd6","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/pulls/18/commits","review_comments_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/pulls/18/comments","review_comment_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/pulls/comments{/number}","comments_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/issues/18/comments","statuses_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/statuses/341bf4987c0f864affb2226f8b35b5fccbf3ff1c","head":{"label":"Kdasay16:IsakdriveKaylanav","ref":"IsakdriveKaylanav","sha":"341bf4987c0f864affb2226f8b35b5fccbf3ff1c","user":{"login":"Kdasay16","id":24254047,"avatar_url":"https://avatars0.githubusercontent.com/u/24254047?v=3","gravatar_id":"","url":"https://api.github.com/users/Kdasay16","html_url":"https://github.com/Kdasay16","followers_url":"https://api.github.com/users/Kdasay16/followers","following_url":"https://api.github.com/users/Kdasay16/following{/other_user}","gists_url":"https://api.github.com/users/Kdasay16/gists{/gist_id}","starred_url":"https://api.github.com/users/Kdasay16/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kdasay16/subscriptions","organizations_url":"https://api.github.com/users/Kdasay16/orgs","repos_url":"https://api.github.com/users/Kdasay16/repos","events_url":"https://api.github.com/users/Kdasay16/events{/privacy}","received_events_url":"https://api.github.com/users/Kdasay16/received_events","type":"User","site_admin":false},"repo":{"id":86007359,"name":"08-sql-intro","full_name":"Kdasay16/08-sql-intro","owner":{"login":"Kdasay16","id":24254047,"avatar_url":"https://avatars0.githubusercontent.com/u/24254047?v=3","gravatar_id":"","url":"https://api.github.com/users/Kdasay16","html_url":"https://github.com/Kdasay16","followers_url":"https://api.github.com/users/Kdasay16/followers","following_url":"https://api.github.com/users/Kdasay16/following{/other_user}","gists_url":"https://api.github.com/users/Kdasay16/gists{/gist_id}","starred_url":"https://api.github.com/users/Kdasay16/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kdasay16/subscriptions","organizations_url":"https://api.github.com/users/Kdasay16/orgs","repos_url":"https://api.github.com/users/Kdasay16/repos","events_url":"https://api.github.com/users/Kdasay16/events{/privacy}","received_events_url":"https://api.github.com/users/Kdasay16/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/Kdasay16/08-sql-intro","description":"Let's level-up the Model layer of our blog app by using SQL!","fork":true,"url":"https://api.github.com/repos/Kdasay16/08-sql-intro","forks_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/forks","keys_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/teams","hooks_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/hooks","issue_events_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/issues/events{/number}","events_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/events","assignees_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/assignees{/user}","branches_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/branches{/branch}","tags_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/tags","blobs_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/git/refs{/sha}","trees_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/statuses/{sha}","languages_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/languages","stargazers_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/stargazers","contributors_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/contributors","subscribers_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/subscribers","subscription_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/subscription","commits_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/commits{/sha}","git_commits_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/git/commits{/sha}","comments_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/comments{/number}","issue_comment_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/issues/comments{/number}","contents_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/contents/{+path}","compare_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/merges","archive_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/downloads","issues_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/issues{/number}","pulls_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/pulls{/number}","milestones_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/milestones{/number}","notifications_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/labels{/name}","releases_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/releases{/id}","deployments_url":"https://api.github.com/repos/Kdasay16/08-sql-intro/deployments","created_at":"2017-03-23T23:30:18Z","updated_at":"2017-03-23T23:30:19Z","pushed_at":"2017-03-24T17:22:52Z","git_url":"git://github.com/Kdasay16/08-sql-intro.git","ssh_url":"git@github.com:Kdasay16/08-sql-intro.git","clone_url":"https://github.com/Kdasay16/08-sql-intro.git","svn_url":"https://github.com/Kdasay16/08-sql-intro","homepage":null,"size":638,"stargazers_count":0,"watchers_count":0,"language":"JavaScript","has_issues":false,"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":"codefellows-seattle-301d18:master","ref":"master","sha":"fb3ec9f4386f62d3de97c396bbfe4dda3370a63f","user":{"login":"codefellows-seattle-301d18","id":26014495,"avatar_url":"https://avatars1.githubusercontent.com/u/26014495?v=3","gravatar_id":"","url":"https://api.github.com/users/codefellows-seattle-301d18","html_url":"https://github.com/codefellows-seattle-301d18","followers_url":"https://api.github.com/users/codefellows-seattle-301d18/followers","following_url":"https://api.github.com/users/codefellows-seattle-301d18/following{/other_user}","gists_url":"https://api.github.com/users/codefellows-seattle-301d18/gists{/gist_id}","starred_url":"https://api.github.com/users/codefellows-seattle-301d18/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/codefellows-seattle-301d18/subscriptions","organizations_url":"https://api.github.com/users/codefellows-seattle-301d18/orgs","repos_url":"https://api.github.com/users/codefellows-seattle-301d18/repos","events_url":"https://api.github.com/users/codefellows-seattle-301d18/events{/privacy}","received_events_url":"https://api.github.com/users/codefellows-seattle-301d18/received_events","type":"Organization","site_admin":false},"repo":{"id":85513592,"name":"08-sql-intro","full_name":"codefellows-seattle-301d18/08-sql-intro","owner":{"login":"codefellows-seattle-301d18","id":26014495,"avatar_url":"https://avatars1.githubusercontent.com/u/26014495?v=3","gravatar_id":"","url":"https://api.github.com/users/codefellows-seattle-301d18","html_url":"https://github.com/codefellows-seattle-301d18","followers_url":"https://api.github.com/users/codefellows-seattle-301d18/followers","following_url":"https://api.github.com/users/codefellows-seattle-301d18/following{/other_user}","gists_url":"https://api.github.com/users/codefellows-seattle-301d18/gists{/gist_id}","starred_url":"https://api.github.com/users/codefellows-seattle-301d18/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/codefellows-seattle-301d18/subscriptions","organizations_url":"https://api.github.com/users/codefellows-seattle-301d18/orgs","repos_url":"https://api.github.com/users/codefellows-seattle-301d18/repos","events_url":"https://api.github.com/users/codefellows-seattle-301d18/events{/privacy}","received_events_url":"https://api.github.com/users/codefellows-seattle-301d18/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/codefellows-seattle-301d18/08-sql-intro","description":"Let's level-up the Model layer of our blog app by using SQL!","fork":false,"url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro","forks_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/forks","keys_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/keys{/key_id}","collaborators_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/teams","hooks_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/hooks","issue_events_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/issues/events{/number}","events_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/events","assignees_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/assignees{/user}","branches_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/branches{/branch}","tags_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/tags","blobs_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/git/refs{/sha}","trees_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/git/trees{/sha}","statuses_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/statuses/{sha}","languages_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/languages","stargazers_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/stargazers","contributors_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/contributors","subscribers_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/subscribers","subscription_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/subscription","commits_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/commits{/sha}","git_commits_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/git/commits{/sha}","comments_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/comments{/number}","issue_comment_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/issues/comments{/number}","contents_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/contents/{+path}","compare_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/compare/{base}...{head}","merges_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/merges","archive_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/downloads","issues_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/issues{/number}","pulls_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/pulls{/number}","milestones_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/milestones{/number}","notifications_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/labels{/name}","releases_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/releases{/id}","deployments_url":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/deployments","created_at":"2017-03-19T22:29:33Z","updated_at":"2017-03-23T23:27:33Z","pushed_at":"2017-03-24T20:59:43Z","git_url":"git://github.com/codefellows-seattle-301d18/08-sql-intro.git","ssh_url":"git@github.com:codefellows-seattle-301d18/08-sql-intro.git","clone_url":"https://github.com/codefellows-seattle-301d18/08-sql-intro.git","svn_url":"https://github.com/codefellows-seattle-301d18/08-sql-intro","homepage":null,"size":636,"stargazers_count":0,"watchers_count":0,"language":"JavaScript","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":12,"mirror_url":null,"open_issues_count":14,"forks":12,"open_issues":14,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/pulls/18"},"html":{"href":"https://github.com/codefellows-seattle-301d18/08-sql-intro/pull/18"},"issue":{"href":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/issues/18"},"comments":{"href":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/issues/18/comments"},"review_comments":{"href":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/pulls/18/comments"},"review_comment":{"href":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/pulls/18/commits"},"statuses":{"href":"https://api.github.com/repos/codefellows-seattle-301d18/08-sql-intro/statuses/341bf4987c0f864affb2226f8b35b5fccbf3ff1c"}}}}
{"actor":{"display_login":"Bl41r"}}