{"action":"created","comment":{"url":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/comments/24033146","id":24033146,"diff_hunk":"@@ -0,0 +1,56 @@\n+require 'pg'\n+require 'securerandom'\n+\n+# Connect to database\n+db_connection = PG.connect(dbname: 'yadda')\n+\n+# Create User Records\n+\n+first_names = [\"Amy\", \"Brian\", \"Chris\", \"David\", \"Emily\", \"Frank\", \"George\", \"Heather\", \"John\", \"Isabel\", \"Mike\"]\n+last_names = [\"Fernandez\", \"Perham\", \"Campbell\", \"Cardarealla\", \"Souza\", \"Michael\", \"Haddad\", \"Hansson\", \"Fried\", \"Kemper\", \"Matz\"]\n+\n+200000.times do\n+  db_connection.exec(\"INSERT INTO users (username, password, first_name, last_name, address, city, state, zip_code, email, created_by) VALUES ('#{SecureRandom.base64(25)}', 'password', '#{first_names.sample}', '#{last_names.sample}', '123 Main Street', 'Chicago', 'IL', '60614', 'name@enova.com','Paul');\")\n+end\n+\n+# Create Brewery Records\n+\n+db_connection.exec(\"INSERT INTO breweries (name, address, city, state, zip_code, description, founding_year, created_by, updated_by) VALUES ('Goose Island', '123 Wacker Drive', 'Chicago', 'IL', '60614', 'Known for their 312', '1960', 1, 1);\")\n+db_connection.exec(\"INSERT INTO breweries (name, address, city, state, zip_code, description, founding_year, created_by, updated_by) VALUES ('Great Lakes', '123 Lake Shore Drive', 'Cleveland', 'OH', '43214', 'Known for their Dortmunder Gold', '1980', 1, 1);\")\n+db_connection.exec(\"INSERT INTO breweries (name, address, city, state, zip_code, description, founding_year, created_by, updated_by) VALUES ('Sierra Nevada', '123 Pacific Coast Highway', 'San Francisco', 'CA', '00983', 'Known for their Pale Ale', '1960', 1, 1);\")\n+db_connection.exec(\"INSERT INTO breweries (name, address, city, state, zip_code, description, founding_year, created_by, updated_by) VALUES ('Stone Brewery', '123 Stone Way', 'Los Angeles', 'CA', '09745', 'Not sure what they are known for', '1960', 1, 1);\")\n+db_connection.exec(\"INSERT INTO breweries (name, address, city, state, zip_code, description, founding_year, created_by, updated_by) VALUES ('Revolution Brewing', '123 Lasalle', 'Chicago', 'IL', '60614', 'Known for their IPA', '2005', 1, 1);\")","path":"yadda/database_connector.rb","position":22,"original_position":22,"commit_id":"e8af336e3638c8b5279df734e5a07e19ce20850d","original_commit_id":"e8af336e3638c8b5279df734e5a07e19ce20850d","user":{"login":"houndci","id":6697940,"avatar_url":"https://avatars.githubusercontent.com/u/6697940?v=3","gravatar_id":"","url":"https://api.github.com/users/houndci","html_url":"https://github.com/houndci","followers_url":"https://api.github.com/users/houndci/followers","following_url":"https://api.github.com/users/houndci/following{/other_user}","gists_url":"https://api.github.com/users/houndci/gists{/gist_id}","starred_url":"https://api.github.com/users/houndci/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/houndci/subscriptions","organizations_url":"https://api.github.com/users/houndci/orgs","repos_url":"https://api.github.com/users/houndci/repos","events_url":"https://api.github.com/users/houndci/events{/privacy}","received_events_url":"https://api.github.com/users/houndci/received_events","type":"User","site_admin":false},"body":"Line is too long. [243/80]","created_at":"2015-02-03T19:46:56Z","updated_at":"2015-02-03T19:46:56Z","html_url":"https://github.com/jmmastey/level_up_exercises/pull/477#discussion_r24033146","pull_request_url":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/477","_links":{"self":{"href":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/comments/24033146"},"html":{"href":"https://github.com/jmmastey/level_up_exercises/pull/477#discussion_r24033146"},"pull_request":{"href":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/477"}}},"pull_request":{"url":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/477","id":28582457,"html_url":"https://github.com/jmmastey/level_up_exercises/pull/477","diff_url":"https://github.com/jmmastey/level_up_exercises/pull/477.diff","patch_url":"https://github.com/jmmastey/level_up_exercises/pull/477.patch","issue_url":"https://api.github.com/repos/jmmastey/level_up_exercises/issues/477","number":477,"state":"open","locked":false,"title":"Yadda part 2","user":{"login":"paulh16","id":1412714,"avatar_url":"https://avatars.githubusercontent.com/u/1412714?v=3","gravatar_id":"","url":"https://api.github.com/users/paulh16","html_url":"https://github.com/paulh16","followers_url":"https://api.github.com/users/paulh16/followers","following_url":"https://api.github.com/users/paulh16/following{/other_user}","gists_url":"https://api.github.com/users/paulh16/gists{/gist_id}","starred_url":"https://api.github.com/users/paulh16/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/paulh16/subscriptions","organizations_url":"https://api.github.com/users/paulh16/orgs","repos_url":"https://api.github.com/users/paulh16/repos","events_url":"https://api.github.com/users/paulh16/events{/privacy}","received_events_url":"https://api.github.com/users/paulh16/received_events","type":"User","site_admin":false},"body":"This is Part 2 of my Yadda exercise. `database_connector.rb` contains the logic for generating the database records. The three views requested for this exercise are at the bottom of `yadda-pg.sql`. I've provided sample usage for each view as a comment in this file.\r\n\r\nThanks!","created_at":"2015-02-03T19:46:50Z","updated_at":"2015-02-03T19:46:56Z","closed_at":null,"merged_at":null,"merge_commit_sha":"e31de26108afb4dfd20ed5432817030e26176b4f","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/477/commits","review_comments_url":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/477/comments","review_comment_url":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/comments/{number}","comments_url":"https://api.github.com/repos/jmmastey/level_up_exercises/issues/477/comments","statuses_url":"https://api.github.com/repos/jmmastey/level_up_exercises/statuses/e8af336e3638c8b5279df734e5a07e19ce20850d","head":{"label":"paulh16:yadda_part_2","ref":"yadda_part_2","sha":"e8af336e3638c8b5279df734e5a07e19ce20850d","user":{"login":"paulh16","id":1412714,"avatar_url":"https://avatars.githubusercontent.com/u/1412714?v=3","gravatar_id":"","url":"https://api.github.com/users/paulh16","html_url":"https://github.com/paulh16","followers_url":"https://api.github.com/users/paulh16/followers","following_url":"https://api.github.com/users/paulh16/following{/other_user}","gists_url":"https://api.github.com/users/paulh16/gists{/gist_id}","starred_url":"https://api.github.com/users/paulh16/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/paulh16/subscriptions","organizations_url":"https://api.github.com/users/paulh16/orgs","repos_url":"https://api.github.com/users/paulh16/repos","events_url":"https://api.github.com/users/paulh16/events{/privacy}","received_events_url":"https://api.github.com/users/paulh16/received_events","type":"User","site_admin":false},"repo":{"id":25008270,"name":"level_up_exercises","full_name":"paulh16/level_up_exercises","owner":{"login":"paulh16","id":1412714,"avatar_url":"https://avatars.githubusercontent.com/u/1412714?v=3","gravatar_id":"","url":"https://api.github.com/users/paulh16","html_url":"https://github.com/paulh16","followers_url":"https://api.github.com/users/paulh16/followers","following_url":"https://api.github.com/users/paulh16/following{/other_user}","gists_url":"https://api.github.com/users/paulh16/gists{/gist_id}","starred_url":"https://api.github.com/users/paulh16/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/paulh16/subscriptions","organizations_url":"https://api.github.com/users/paulh16/orgs","repos_url":"https://api.github.com/users/paulh16/repos","events_url":"https://api.github.com/users/paulh16/events{/privacy}","received_events_url":"https://api.github.com/users/paulh16/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/paulh16/level_up_exercises","description":"A series of code-related assignments to challenge starting engineers","fork":true,"url":"https://api.github.com/repos/paulh16/level_up_exercises","forks_url":"https://api.github.com/repos/paulh16/level_up_exercises/forks","keys_url":"https://api.github.com/repos/paulh16/level_up_exercises/keys{/key_id}","collaborators_url":"https://api.github.com/repos/paulh16/level_up_exercises/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/paulh16/level_up_exercises/teams","hooks_url":"https://api.github.com/repos/paulh16/level_up_exercises/hooks","issue_events_url":"https://api.github.com/repos/paulh16/level_up_exercises/issues/events{/number}","events_url":"https://api.github.com/repos/paulh16/level_up_exercises/events","assignees_url":"https://api.github.com/repos/paulh16/level_up_exercises/assignees{/user}","branches_url":"https://api.github.com/repos/paulh16/level_up_exercises/branches{/branch}","tags_url":"https://api.github.com/repos/paulh16/level_up_exercises/tags","blobs_url":"https://api.github.com/repos/paulh16/level_up_exercises/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/paulh16/level_up_exercises/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/paulh16/level_up_exercises/git/refs{/sha}","trees_url":"https://api.github.com/repos/paulh16/level_up_exercises/git/trees{/sha}","statuses_url":"https://api.github.com/repos/paulh16/level_up_exercises/statuses/{sha}","languages_url":"https://api.github.com/repos/paulh16/level_up_exercises/languages","stargazers_url":"https://api.github.com/repos/paulh16/level_up_exercises/stargazers","contributors_url":"https://api.github.com/repos/paulh16/level_up_exercises/contributors","subscribers_url":"https://api.github.com/repos/paulh16/level_up_exercises/subscribers","subscription_url":"https://api.github.com/repos/paulh16/level_up_exercises/subscription","commits_url":"https://api.github.com/repos/paulh16/level_up_exercises/commits{/sha}","git_commits_url":"https://api.github.com/repos/paulh16/level_up_exercises/git/commits{/sha}","comments_url":"https://api.github.com/repos/paulh16/level_up_exercises/comments{/number}","issue_comment_url":"https://api.github.com/repos/paulh16/level_up_exercises/issues/comments/{number}","contents_url":"https://api.github.com/repos/paulh16/level_up_exercises/contents/{+path}","compare_url":"https://api.github.com/repos/paulh16/level_up_exercises/compare/{base}...{head}","merges_url":"https://api.github.com/repos/paulh16/level_up_exercises/merges","archive_url":"https://api.github.com/repos/paulh16/level_up_exercises/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/paulh16/level_up_exercises/downloads","issues_url":"https://api.github.com/repos/paulh16/level_up_exercises/issues{/number}","pulls_url":"https://api.github.com/repos/paulh16/level_up_exercises/pulls{/number}","milestones_url":"https://api.github.com/repos/paulh16/level_up_exercises/milestones{/number}","notifications_url":"https://api.github.com/repos/paulh16/level_up_exercises/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/paulh16/level_up_exercises/labels{/name}","releases_url":"https://api.github.com/repos/paulh16/level_up_exercises/releases{/id}","created_at":"2014-10-09T20:57:49Z","updated_at":"2014-10-22T17:51:40Z","pushed_at":"2015-02-03T19:43:57Z","git_url":"git://github.com/paulh16/level_up_exercises.git","ssh_url":"git@github.com:paulh16/level_up_exercises.git","clone_url":"https://github.com/paulh16/level_up_exercises.git","svn_url":"https://github.com/paulh16/level_up_exercises","homepage":"http://leveluprails.herokuapp.com","size":4044,"stargazers_count":0,"watchers_count":0,"language":"Ruby","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"jmmastey:master","ref":"master","sha":"f208d381f275b417df72d3cdf6562ceb443bfd3a","user":{"login":"jmmastey","id":302011,"avatar_url":"https://avatars.githubusercontent.com/u/302011?v=3","gravatar_id":"","url":"https://api.github.com/users/jmmastey","html_url":"https://github.com/jmmastey","followers_url":"https://api.github.com/users/jmmastey/followers","following_url":"https://api.github.com/users/jmmastey/following{/other_user}","gists_url":"https://api.github.com/users/jmmastey/gists{/gist_id}","starred_url":"https://api.github.com/users/jmmastey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmmastey/subscriptions","organizations_url":"https://api.github.com/users/jmmastey/orgs","repos_url":"https://api.github.com/users/jmmastey/repos","events_url":"https://api.github.com/users/jmmastey/events{/privacy}","received_events_url":"https://api.github.com/users/jmmastey/received_events","type":"User","site_admin":false},"repo":{"id":20705648,"name":"level_up_exercises","full_name":"jmmastey/level_up_exercises","owner":{"login":"jmmastey","id":302011,"avatar_url":"https://avatars.githubusercontent.com/u/302011?v=3","gravatar_id":"","url":"https://api.github.com/users/jmmastey","html_url":"https://github.com/jmmastey","followers_url":"https://api.github.com/users/jmmastey/followers","following_url":"https://api.github.com/users/jmmastey/following{/other_user}","gists_url":"https://api.github.com/users/jmmastey/gists{/gist_id}","starred_url":"https://api.github.com/users/jmmastey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmmastey/subscriptions","organizations_url":"https://api.github.com/users/jmmastey/orgs","repos_url":"https://api.github.com/users/jmmastey/repos","events_url":"https://api.github.com/users/jmmastey/events{/privacy}","received_events_url":"https://api.github.com/users/jmmastey/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/jmmastey/level_up_exercises","description":"A series of code-related assignments to challenge starting engineers","fork":false,"url":"https://api.github.com/repos/jmmastey/level_up_exercises","forks_url":"https://api.github.com/repos/jmmastey/level_up_exercises/forks","keys_url":"https://api.github.com/repos/jmmastey/level_up_exercises/keys{/key_id}","collaborators_url":"https://api.github.com/repos/jmmastey/level_up_exercises/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/jmmastey/level_up_exercises/teams","hooks_url":"https://api.github.com/repos/jmmastey/level_up_exercises/hooks","issue_events_url":"https://api.github.com/repos/jmmastey/level_up_exercises/issues/events{/number}","events_url":"https://api.github.com/repos/jmmastey/level_up_exercises/events","assignees_url":"https://api.github.com/repos/jmmastey/level_up_exercises/assignees{/user}","branches_url":"https://api.github.com/repos/jmmastey/level_up_exercises/branches{/branch}","tags_url":"https://api.github.com/repos/jmmastey/level_up_exercises/tags","blobs_url":"https://api.github.com/repos/jmmastey/level_up_exercises/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/jmmastey/level_up_exercises/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/jmmastey/level_up_exercises/git/refs{/sha}","trees_url":"https://api.github.com/repos/jmmastey/level_up_exercises/git/trees{/sha}","statuses_url":"https://api.github.com/repos/jmmastey/level_up_exercises/statuses/{sha}","languages_url":"https://api.github.com/repos/jmmastey/level_up_exercises/languages","stargazers_url":"https://api.github.com/repos/jmmastey/level_up_exercises/stargazers","contributors_url":"https://api.github.com/repos/jmmastey/level_up_exercises/contributors","subscribers_url":"https://api.github.com/repos/jmmastey/level_up_exercises/subscribers","subscription_url":"https://api.github.com/repos/jmmastey/level_up_exercises/subscription","commits_url":"https://api.github.com/repos/jmmastey/level_up_exercises/commits{/sha}","git_commits_url":"https://api.github.com/repos/jmmastey/level_up_exercises/git/commits{/sha}","comments_url":"https://api.github.com/repos/jmmastey/level_up_exercises/comments{/number}","issue_comment_url":"https://api.github.com/repos/jmmastey/level_up_exercises/issues/comments/{number}","contents_url":"https://api.github.com/repos/jmmastey/level_up_exercises/contents/{+path}","compare_url":"https://api.github.com/repos/jmmastey/level_up_exercises/compare/{base}...{head}","merges_url":"https://api.github.com/repos/jmmastey/level_up_exercises/merges","archive_url":"https://api.github.com/repos/jmmastey/level_up_exercises/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/jmmastey/level_up_exercises/downloads","issues_url":"https://api.github.com/repos/jmmastey/level_up_exercises/issues{/number}","pulls_url":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls{/number}","milestones_url":"https://api.github.com/repos/jmmastey/level_up_exercises/milestones{/number}","notifications_url":"https://api.github.com/repos/jmmastey/level_up_exercises/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/jmmastey/level_up_exercises/labels{/name}","releases_url":"https://api.github.com/repos/jmmastey/level_up_exercises/releases{/id}","created_at":"2014-06-10T23:42:24Z","updated_at":"2015-01-23T17:55:29Z","pushed_at":"2015-01-23T17:55:29Z","git_url":"git://github.com/jmmastey/level_up_exercises.git","ssh_url":"git@github.com:jmmastey/level_up_exercises.git","clone_url":"https://github.com/jmmastey/level_up_exercises.git","svn_url":"https://github.com/jmmastey/level_up_exercises","homepage":"http://leveluprails.herokuapp.com","size":120749,"stargazers_count":14,"watchers_count":14,"language":"Ruby","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":69,"mirror_url":null,"open_issues_count":3,"forks":69,"open_issues":3,"watchers":14,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/477"},"html":{"href":"https://github.com/jmmastey/level_up_exercises/pull/477"},"issue":{"href":"https://api.github.com/repos/jmmastey/level_up_exercises/issues/477"},"comments":{"href":"https://api.github.com/repos/jmmastey/level_up_exercises/issues/477/comments"},"review_comments":{"href":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/477/comments"},"review_comment":{"href":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/comments/{number}"},"commits":{"href":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/477/commits"},"statuses":{"href":"https://api.github.com/repos/jmmastey/level_up_exercises/statuses/e8af336e3638c8b5279df734e5a07e19ce20850d"}}}}