{"action":"created","comment":{"url":"https://api.github.com/repos/codex-academy/Nelisa/pulls/comments/59518013","id":59518013,"diff_hunk":"@@ -1,26 +1,31 @@\n ---\n layout: default\n-title: Database setup\n+title: Data beyond a CSV\n ---\n \n-# Database basics\n+# Data beyond a CSV\n \n > Nelisa needs a more effective way of storing weekly sales data and profits.\n \n Create a database for Nelisa to store Products, Categories, Sales and Purchases.\n \n+Add Categories to the database using a [SQL script](http://database.projectcodex.co/steps/running_sql_scripts.html).\n+\n+Import weekly sales & purchases files into [MySQL using NodeJS](https://www.npmjs.com/package/mysql), using [bulk insert](http://database.projectcodex.co/steps/mysql_bulk_insert_using_nodejs).\n+\n Add support for showing the Products, Categories, Sales and Purchases from the database in a web browser.\n \n-Import weekly sales and purchases files into the database.\n+Learn more about databases [here](http://database.projectcodex.co)","path":"4_Database_setup.md","position":21,"original_position":21,"commit_id":"233bb3e876f79a63d583b7a96b559e85e723c82d","original_commit_id":"233bb3e876f79a63d583b7a96b559e85e723c82d","user":{"login":"SteveBarnett","id":1239497,"avatar_url":"https://avatars.githubusercontent.com/u/1239497?v=3","gravatar_id":"","url":"https://api.github.com/users/SteveBarnett","html_url":"https://github.com/SteveBarnett","followers_url":"https://api.github.com/users/SteveBarnett/followers","following_url":"https://api.github.com/users/SteveBarnett/following{/other_user}","gists_url":"https://api.github.com/users/SteveBarnett/gists{/gist_id}","starred_url":"https://api.github.com/users/SteveBarnett/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SteveBarnett/subscriptions","organizations_url":"https://api.github.com/users/SteveBarnett/orgs","repos_url":"https://api.github.com/users/SteveBarnett/repos","events_url":"https://api.github.com/users/SteveBarnett/events{/privacy}","received_events_url":"https://api.github.com/users/SteveBarnett/received_events","type":"User","site_admin":false},"body":"Link text that's clearer is more gooder, or:\r\n\r\n```\r\n[database.projectcodex.co](http://database.projectcodex.co)\r\n```","created_at":"2016-04-13T09:24:44Z","updated_at":"2016-04-13T09:24:44Z","html_url":"https://github.com/codex-academy/Nelisa/pull/3#discussion_r59518013","pull_request_url":"https://api.github.com/repos/codex-academy/Nelisa/pulls/3","_links":{"self":{"href":"https://api.github.com/repos/codex-academy/Nelisa/pulls/comments/59518013"},"html":{"href":"https://github.com/codex-academy/Nelisa/pull/3#discussion_r59518013"},"pull_request":{"href":"https://api.github.com/repos/codex-academy/Nelisa/pulls/3"}}},"pull_request":{"url":"https://api.github.com/repos/codex-academy/Nelisa/pulls/3","id":66224880,"html_url":"https://github.com/codex-academy/Nelisa/pull/3","diff_url":"https://github.com/codex-academy/Nelisa/pull/3.diff","patch_url":"https://github.com/codex-academy/Nelisa/pull/3.patch","issue_url":"https://api.github.com/repos/codex-academy/Nelisa/issues/3","number":3,"state":"open","locked":false,"title":"Add bulk database upload details","user":{"login":"avermeulen","id":34037,"avatar_url":"https://avatars.githubusercontent.com/u/34037?v=3","gravatar_id":"","url":"https://api.github.com/users/avermeulen","html_url":"https://github.com/avermeulen","followers_url":"https://api.github.com/users/avermeulen/followers","following_url":"https://api.github.com/users/avermeulen/following{/other_user}","gists_url":"https://api.github.com/users/avermeulen/gists{/gist_id}","starred_url":"https://api.github.com/users/avermeulen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/avermeulen/subscriptions","organizations_url":"https://api.github.com/users/avermeulen/orgs","repos_url":"https://api.github.com/users/avermeulen/repos","events_url":"https://api.github.com/users/avermeulen/events{/privacy}","received_events_url":"https://api.github.com/users/avermeulen/received_events","type":"User","site_admin":false},"body":"@SteveBarnett Please take a look and merge if you are happy.\r\n\r\nI made things clearer on using the bulk sql import.","created_at":"2016-04-12T20:44:52Z","updated_at":"2016-04-13T09:24:44Z","closed_at":null,"merged_at":null,"merge_commit_sha":"f33934f10f8f12a19ee88cb93849f5dfa166ac07","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/codex-academy/Nelisa/pulls/3/commits","review_comments_url":"https://api.github.com/repos/codex-academy/Nelisa/pulls/3/comments","review_comment_url":"https://api.github.com/repos/codex-academy/Nelisa/pulls/comments{/number}","comments_url":"https://api.github.com/repos/codex-academy/Nelisa/issues/3/comments","statuses_url":"https://api.github.com/repos/codex-academy/Nelisa/statuses/233bb3e876f79a63d583b7a96b559e85e723c82d","head":{"label":"codex-academy:AddBulkDatabaseUploadDetails","ref":"AddBulkDatabaseUploadDetails","sha":"233bb3e876f79a63d583b7a96b559e85e723c82d","user":{"login":"codex-academy","id":7427964,"avatar_url":"https://avatars.githubusercontent.com/u/7427964?v=3","gravatar_id":"","url":"https://api.github.com/users/codex-academy","html_url":"https://github.com/codex-academy","followers_url":"https://api.github.com/users/codex-academy/followers","following_url":"https://api.github.com/users/codex-academy/following{/other_user}","gists_url":"https://api.github.com/users/codex-academy/gists{/gist_id}","starred_url":"https://api.github.com/users/codex-academy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/codex-academy/subscriptions","organizations_url":"https://api.github.com/users/codex-academy/orgs","repos_url":"https://api.github.com/users/codex-academy/repos","events_url":"https://api.github.com/users/codex-academy/events{/privacy}","received_events_url":"https://api.github.com/users/codex-academy/received_events","type":"Organization","site_admin":false},"repo":{"id":52592342,"name":"Nelisa","full_name":"codex-academy/Nelisa","owner":{"login":"codex-academy","id":7427964,"avatar_url":"https://avatars.githubusercontent.com/u/7427964?v=3","gravatar_id":"","url":"https://api.github.com/users/codex-academy","html_url":"https://github.com/codex-academy","followers_url":"https://api.github.com/users/codex-academy/followers","following_url":"https://api.github.com/users/codex-academy/following{/other_user}","gists_url":"https://api.github.com/users/codex-academy/gists{/gist_id}","starred_url":"https://api.github.com/users/codex-academy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/codex-academy/subscriptions","organizations_url":"https://api.github.com/users/codex-academy/orgs","repos_url":"https://api.github.com/users/codex-academy/repos","events_url":"https://api.github.com/users/codex-academy/events{/privacy}","received_events_url":"https://api.github.com/users/codex-academy/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/codex-academy/Nelisa","description":"Nelisa Narrative","fork":false,"url":"https://api.github.com/repos/codex-academy/Nelisa","forks_url":"https://api.github.com/repos/codex-academy/Nelisa/forks","keys_url":"https://api.github.com/repos/codex-academy/Nelisa/keys{/key_id}","collaborators_url":"https://api.github.com/repos/codex-academy/Nelisa/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/codex-academy/Nelisa/teams","hooks_url":"https://api.github.com/repos/codex-academy/Nelisa/hooks","issue_events_url":"https://api.github.com/repos/codex-academy/Nelisa/issues/events{/number}","events_url":"https://api.github.com/repos/codex-academy/Nelisa/events","assignees_url":"https://api.github.com/repos/codex-academy/Nelisa/assignees{/user}","branches_url":"https://api.github.com/repos/codex-academy/Nelisa/branches{/branch}","tags_url":"https://api.github.com/repos/codex-academy/Nelisa/tags","blobs_url":"https://api.github.com/repos/codex-academy/Nelisa/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/codex-academy/Nelisa/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/codex-academy/Nelisa/git/refs{/sha}","trees_url":"https://api.github.com/repos/codex-academy/Nelisa/git/trees{/sha}","statuses_url":"https://api.github.com/repos/codex-academy/Nelisa/statuses/{sha}","languages_url":"https://api.github.com/repos/codex-academy/Nelisa/languages","stargazers_url":"https://api.github.com/repos/codex-academy/Nelisa/stargazers","contributors_url":"https://api.github.com/repos/codex-academy/Nelisa/contributors","subscribers_url":"https://api.github.com/repos/codex-academy/Nelisa/subscribers","subscription_url":"https://api.github.com/repos/codex-academy/Nelisa/subscription","commits_url":"https://api.github.com/repos/codex-academy/Nelisa/commits{/sha}","git_commits_url":"https://api.github.com/repos/codex-academy/Nelisa/git/commits{/sha}","comments_url":"https://api.github.com/repos/codex-academy/Nelisa/comments{/number}","issue_comment_url":"https://api.github.com/repos/codex-academy/Nelisa/issues/comments{/number}","contents_url":"https://api.github.com/repos/codex-academy/Nelisa/contents/{+path}","compare_url":"https://api.github.com/repos/codex-academy/Nelisa/compare/{base}...{head}","merges_url":"https://api.github.com/repos/codex-academy/Nelisa/merges","archive_url":"https://api.github.com/repos/codex-academy/Nelisa/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/codex-academy/Nelisa/downloads","issues_url":"https://api.github.com/repos/codex-academy/Nelisa/issues{/number}","pulls_url":"https://api.github.com/repos/codex-academy/Nelisa/pulls{/number}","milestones_url":"https://api.github.com/repos/codex-academy/Nelisa/milestones{/number}","notifications_url":"https://api.github.com/repos/codex-academy/Nelisa/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/codex-academy/Nelisa/labels{/name}","releases_url":"https://api.github.com/repos/codex-academy/Nelisa/releases{/id}","deployments_url":"https://api.github.com/repos/codex-academy/Nelisa/deployments","created_at":"2016-02-26T09:08:47Z","updated_at":"2016-02-26T09:17:09Z","pushed_at":"2016-04-12T20:44:52Z","git_url":"git://github.com/codex-academy/Nelisa.git","ssh_url":"git@github.com:codex-academy/Nelisa.git","clone_url":"https://github.com/codex-academy/Nelisa.git","svn_url":"https://github.com/codex-academy/Nelisa","homepage":"http://nelisa.projectcodex.co/","size":159,"stargazers_count":0,"watchers_count":0,"language":"CSS","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":1,"mirror_url":null,"open_issues_count":2,"forks":1,"open_issues":2,"watchers":0,"default_branch":"gh-pages"}},"base":{"label":"codex-academy:gh-pages","ref":"gh-pages","sha":"6a7a3d43074fc9617eab83351e4fe792a6eccfd2","user":{"login":"codex-academy","id":7427964,"avatar_url":"https://avatars.githubusercontent.com/u/7427964?v=3","gravatar_id":"","url":"https://api.github.com/users/codex-academy","html_url":"https://github.com/codex-academy","followers_url":"https://api.github.com/users/codex-academy/followers","following_url":"https://api.github.com/users/codex-academy/following{/other_user}","gists_url":"https://api.github.com/users/codex-academy/gists{/gist_id}","starred_url":"https://api.github.com/users/codex-academy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/codex-academy/subscriptions","organizations_url":"https://api.github.com/users/codex-academy/orgs","repos_url":"https://api.github.com/users/codex-academy/repos","events_url":"https://api.github.com/users/codex-academy/events{/privacy}","received_events_url":"https://api.github.com/users/codex-academy/received_events","type":"Organization","site_admin":false},"repo":{"id":52592342,"name":"Nelisa","full_name":"codex-academy/Nelisa","owner":{"login":"codex-academy","id":7427964,"avatar_url":"https://avatars.githubusercontent.com/u/7427964?v=3","gravatar_id":"","url":"https://api.github.com/users/codex-academy","html_url":"https://github.com/codex-academy","followers_url":"https://api.github.com/users/codex-academy/followers","following_url":"https://api.github.com/users/codex-academy/following{/other_user}","gists_url":"https://api.github.com/users/codex-academy/gists{/gist_id}","starred_url":"https://api.github.com/users/codex-academy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/codex-academy/subscriptions","organizations_url":"https://api.github.com/users/codex-academy/orgs","repos_url":"https://api.github.com/users/codex-academy/repos","events_url":"https://api.github.com/users/codex-academy/events{/privacy}","received_events_url":"https://api.github.com/users/codex-academy/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/codex-academy/Nelisa","description":"Nelisa Narrative","fork":false,"url":"https://api.github.com/repos/codex-academy/Nelisa","forks_url":"https://api.github.com/repos/codex-academy/Nelisa/forks","keys_url":"https://api.github.com/repos/codex-academy/Nelisa/keys{/key_id}","collaborators_url":"https://api.github.com/repos/codex-academy/Nelisa/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/codex-academy/Nelisa/teams","hooks_url":"https://api.github.com/repos/codex-academy/Nelisa/hooks","issue_events_url":"https://api.github.com/repos/codex-academy/Nelisa/issues/events{/number}","events_url":"https://api.github.com/repos/codex-academy/Nelisa/events","assignees_url":"https://api.github.com/repos/codex-academy/Nelisa/assignees{/user}","branches_url":"https://api.github.com/repos/codex-academy/Nelisa/branches{/branch}","tags_url":"https://api.github.com/repos/codex-academy/Nelisa/tags","blobs_url":"https://api.github.com/repos/codex-academy/Nelisa/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/codex-academy/Nelisa/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/codex-academy/Nelisa/git/refs{/sha}","trees_url":"https://api.github.com/repos/codex-academy/Nelisa/git/trees{/sha}","statuses_url":"https://api.github.com/repos/codex-academy/Nelisa/statuses/{sha}","languages_url":"https://api.github.com/repos/codex-academy/Nelisa/languages","stargazers_url":"https://api.github.com/repos/codex-academy/Nelisa/stargazers","contributors_url":"https://api.github.com/repos/codex-academy/Nelisa/contributors","subscribers_url":"https://api.github.com/repos/codex-academy/Nelisa/subscribers","subscription_url":"https://api.github.com/repos/codex-academy/Nelisa/subscription","commits_url":"https://api.github.com/repos/codex-academy/Nelisa/commits{/sha}","git_commits_url":"https://api.github.com/repos/codex-academy/Nelisa/git/commits{/sha}","comments_url":"https://api.github.com/repos/codex-academy/Nelisa/comments{/number}","issue_comment_url":"https://api.github.com/repos/codex-academy/Nelisa/issues/comments{/number}","contents_url":"https://api.github.com/repos/codex-academy/Nelisa/contents/{+path}","compare_url":"https://api.github.com/repos/codex-academy/Nelisa/compare/{base}...{head}","merges_url":"https://api.github.com/repos/codex-academy/Nelisa/merges","archive_url":"https://api.github.com/repos/codex-academy/Nelisa/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/codex-academy/Nelisa/downloads","issues_url":"https://api.github.com/repos/codex-academy/Nelisa/issues{/number}","pulls_url":"https://api.github.com/repos/codex-academy/Nelisa/pulls{/number}","milestones_url":"https://api.github.com/repos/codex-academy/Nelisa/milestones{/number}","notifications_url":"https://api.github.com/repos/codex-academy/Nelisa/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/codex-academy/Nelisa/labels{/name}","releases_url":"https://api.github.com/repos/codex-academy/Nelisa/releases{/id}","deployments_url":"https://api.github.com/repos/codex-academy/Nelisa/deployments","created_at":"2016-02-26T09:08:47Z","updated_at":"2016-02-26T09:17:09Z","pushed_at":"2016-04-12T20:44:52Z","git_url":"git://github.com/codex-academy/Nelisa.git","ssh_url":"git@github.com:codex-academy/Nelisa.git","clone_url":"https://github.com/codex-academy/Nelisa.git","svn_url":"https://github.com/codex-academy/Nelisa","homepage":"http://nelisa.projectcodex.co/","size":159,"stargazers_count":0,"watchers_count":0,"language":"CSS","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":1,"mirror_url":null,"open_issues_count":2,"forks":1,"open_issues":2,"watchers":0,"default_branch":"gh-pages"}},"_links":{"self":{"href":"https://api.github.com/repos/codex-academy/Nelisa/pulls/3"},"html":{"href":"https://github.com/codex-academy/Nelisa/pull/3"},"issue":{"href":"https://api.github.com/repos/codex-academy/Nelisa/issues/3"},"comments":{"href":"https://api.github.com/repos/codex-academy/Nelisa/issues/3/comments"},"review_comments":{"href":"https://api.github.com/repos/codex-academy/Nelisa/pulls/3/comments"},"review_comment":{"href":"https://api.github.com/repos/codex-academy/Nelisa/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/codex-academy/Nelisa/pulls/3/commits"},"statuses":{"href":"https://api.github.com/repos/codex-academy/Nelisa/statuses/233bb3e876f79a63d583b7a96b559e85e723c82d"}}}}