{"action":"created","comment":{"url":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/comments/38204686","id":38204686,"diff_hunk":"@@ -0,0 +1,104 @@\n+require 'faker'\n+require 'pg'\n+\n+module YaddaGenerator\n+  CONFIG = { adapter: 'postgresql', database: 'yadda' }\n+  BREWERY_COUNT = 100_000\n+  ADDRESS_COUNT = 50_000\n+  BEER_COUNT = 1_000_000\n+  USER_COUNT = 200_000\n+  RATING_COUNT = 100_000\n+\n+  def self.connect\n+    @conn = PG.connect(dbname: 'yadda')\n+  end\n+\n+  def self.reload_schema\n+    `psql -f sql/schema.sql`\n+  end\n+\n+  def self.create_data\n+    create_beer_styles\n+    create_addresses\n+    create_breweries\n+    create_beers\n+    create_users\n+    create_ratings\n+  end\n+\n+  def self.create_beer_styles\n+    @conn.prepare(\"insert_beer_style\", \"INSERT INTO beer_styles (id, name, created_by) values ($1, $2, $3)\")\n+    File.foreach('data/beer_styles.txt').with_index do |beer_style, index|\n+      @conn.exec_prepared(\"insert_beer_style\", [index, beer_style.chomp, 'script'])\n+    end\n+  end\n+\n+  def self.create_addresses\n+    @conn.prepare(\"insert_address\", \"INSERT INTO addresses (id, address_line_1, address_line_2, city, state, zipcode, country, created_by) values ($1, $2, $3, $4, $5, $6, $7, $8)\")\n+    ADDRESS_COUNT.times do |i|\n+      address_line_1 = Faker::Address.street_address\n+      address_line_2 = Faker::Address.secondary_address\n+      city = Faker::Address.city\n+      state = Faker::Address.state_abbr\n+      zipcode = Faker::Address.zip_code[0..4]\n+      country = 'US'\n+      @conn.exec_prepared(\"insert_address\", [i, address_line_1, address_line_2, city, state, zipcode, country, 'script'])\n+    end\n+  end\n+\n+  def self.create_breweries\n+    @conn.prepare(\"insert_brewery\", \"INSERT INTO breweries (id, name, description, founding_year, address_id, created_by) values ($1, $2, $3, $4, $5, $6)\")\n+    BREWERY_COUNT.times do |i|\n+      name = Faker::Name.first_name << ' Brewery'\n+      description = Faker::Lorem.paragraph\n+      date = Faker::Date.between(Date.today - 2 * 365, Date.today).year\n+      @conn.exec_prepared(\"insert_brewery\", [i, name, description, date, rand(1..ADDRESS_COUNT-1), 'script'])\n+    end\n+  end\n+\n+  def self.create_beers\n+    @conn.prepare(\"insert_beer\", \"INSERT INTO beers (id, name, description, brewing_year, beer_style_id, brewery_id, created_by) values ($1, $2, $3, $4, $5, $6, $7)\")\n+    num_beer_styles = File.readlines('data/beer_styles.txt').count\n+    BEER_COUNT.times do |i|\n+      name = \"#{Faker::Lorem.word}\"\n+      description = Faker::Lorem.paragraph\n+      date = Faker::Date.between(Date.today - 2 * 365, Date.today).year\n+      @conn.exec_prepared(\"insert_beer\", [i, name, description, date, rand(1..num_beer_styles-1), rand(1..BREWERY_COUNT-1), 'script'])\n+    end\n+  end\n+\n+  def self.create_users\n+    @conn.prepare(\"insert_user\", \"INSERT INTO users (id, fname, lname, username, age, weight_in_lbs, height_in_inches, email, address_id, created_by) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)\")\n+    USER_COUNT.times do |i|\n+      fname = Faker::Name.first_name\n+      lname = Faker::Name.last_name\n+      username = Faker::Internet.user_name\n+      age = Faker::Number.between(21, 125)\n+      weight_in_lbs = Faker::Number.between(10, 500)\n+      height_in_inches = Faker::Number.between(36, 100)\n+      email = Faker::Internet.email\n+\n+      @conn.exec_prepared(\"insert_user\", [i, fname, lname, username, age, weight_in_lbs, height_in_inches, email, rand(1..ADDRESS_COUNT-1), 'script'])\n+    end\n+  end\n+\n+  def self.create_ratings","path":"yadda/yadda_generator.rb","position":85,"original_position":85,"commit_id":"946d5b46970f61d9e543348ec38af3adb39b651e","original_commit_id":"946d5b46970f61d9e543348ec38af3adb39b651e","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":"Assignment Branch Condition size for create_ratings is too high. [29.83/15]","created_at":"2015-08-28T14:25:19Z","updated_at":"2015-08-28T14:25:19Z","html_url":"https://github.com/jmmastey/level_up_exercises/pull/956#discussion_r38204686","pull_request_url":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/956","_links":{"self":{"href":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/comments/38204686"},"html":{"href":"https://github.com/jmmastey/level_up_exercises/pull/956#discussion_r38204686"},"pull_request":{"href":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/956"}}},"pull_request":{"url":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/956","id":43633145,"html_url":"https://github.com/jmmastey/level_up_exercises/pull/956","diff_url":"https://github.com/jmmastey/level_up_exercises/pull/956.diff","patch_url":"https://github.com/jmmastey/level_up_exercises/pull/956.patch","issue_url":"https://api.github.com/repos/jmmastey/level_up_exercises/issues/956","number":956,"state":"open","locked":false,"title":"Yadda Part 4 v1","user":{"login":"ssapra","id":1894216,"avatar_url":"https://avatars.githubusercontent.com/u/1894216?v=3","gravatar_id":"","url":"https://api.github.com/users/ssapra","html_url":"https://github.com/ssapra","followers_url":"https://api.github.com/users/ssapra/followers","following_url":"https://api.github.com/users/ssapra/following{/other_user}","gists_url":"https://api.github.com/users/ssapra/gists{/gist_id}","starred_url":"https://api.github.com/users/ssapra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ssapra/subscriptions","organizations_url":"https://api.github.com/users/ssapra/orgs","repos_url":"https://api.github.com/users/ssapra/repos","events_url":"https://api.github.com/users/ssapra/events{/privacy}","received_events_url":"https://api.github.com/users/ssapra/received_events","type":"User","site_admin":false},"body":"","created_at":"2015-08-28T14:25:13Z","updated_at":"2015-08-28T14:25:19Z","closed_at":null,"merged_at":null,"merge_commit_sha":"4005814148069251be9f1055b1f7afb7db23a7e5","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/956/commits","review_comments_url":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/956/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/956/comments","statuses_url":"https://api.github.com/repos/jmmastey/level_up_exercises/statuses/946d5b46970f61d9e543348ec38af3adb39b651e","head":{"label":"ssapra:yadda-part4","ref":"yadda-part4","sha":"946d5b46970f61d9e543348ec38af3adb39b651e","user":{"login":"ssapra","id":1894216,"avatar_url":"https://avatars.githubusercontent.com/u/1894216?v=3","gravatar_id":"","url":"https://api.github.com/users/ssapra","html_url":"https://github.com/ssapra","followers_url":"https://api.github.com/users/ssapra/followers","following_url":"https://api.github.com/users/ssapra/following{/other_user}","gists_url":"https://api.github.com/users/ssapra/gists{/gist_id}","starred_url":"https://api.github.com/users/ssapra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ssapra/subscriptions","organizations_url":"https://api.github.com/users/ssapra/orgs","repos_url":"https://api.github.com/users/ssapra/repos","events_url":"https://api.github.com/users/ssapra/events{/privacy}","received_events_url":"https://api.github.com/users/ssapra/received_events","type":"User","site_admin":false},"repo":{"id":39095853,"name":"level_up_exercises","full_name":"ssapra/level_up_exercises","owner":{"login":"ssapra","id":1894216,"avatar_url":"https://avatars.githubusercontent.com/u/1894216?v=3","gravatar_id":"","url":"https://api.github.com/users/ssapra","html_url":"https://github.com/ssapra","followers_url":"https://api.github.com/users/ssapra/followers","following_url":"https://api.github.com/users/ssapra/following{/other_user}","gists_url":"https://api.github.com/users/ssapra/gists{/gist_id}","starred_url":"https://api.github.com/users/ssapra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ssapra/subscriptions","organizations_url":"https://api.github.com/users/ssapra/orgs","repos_url":"https://api.github.com/users/ssapra/repos","events_url":"https://api.github.com/users/ssapra/events{/privacy}","received_events_url":"https://api.github.com/users/ssapra/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/ssapra/level_up_exercises","description":"A series of code-related assignments to challenge starting engineers","fork":true,"url":"https://api.github.com/repos/ssapra/level_up_exercises","forks_url":"https://api.github.com/repos/ssapra/level_up_exercises/forks","keys_url":"https://api.github.com/repos/ssapra/level_up_exercises/keys{/key_id}","collaborators_url":"https://api.github.com/repos/ssapra/level_up_exercises/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/ssapra/level_up_exercises/teams","hooks_url":"https://api.github.com/repos/ssapra/level_up_exercises/hooks","issue_events_url":"https://api.github.com/repos/ssapra/level_up_exercises/issues/events{/number}","events_url":"https://api.github.com/repos/ssapra/level_up_exercises/events","assignees_url":"https://api.github.com/repos/ssapra/level_up_exercises/assignees{/user}","branches_url":"https://api.github.com/repos/ssapra/level_up_exercises/branches{/branch}","tags_url":"https://api.github.com/repos/ssapra/level_up_exercises/tags","blobs_url":"https://api.github.com/repos/ssapra/level_up_exercises/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/ssapra/level_up_exercises/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/ssapra/level_up_exercises/git/refs{/sha}","trees_url":"https://api.github.com/repos/ssapra/level_up_exercises/git/trees{/sha}","statuses_url":"https://api.github.com/repos/ssapra/level_up_exercises/statuses/{sha}","languages_url":"https://api.github.com/repos/ssapra/level_up_exercises/languages","stargazers_url":"https://api.github.com/repos/ssapra/level_up_exercises/stargazers","contributors_url":"https://api.github.com/repos/ssapra/level_up_exercises/contributors","subscribers_url":"https://api.github.com/repos/ssapra/level_up_exercises/subscribers","subscription_url":"https://api.github.com/repos/ssapra/level_up_exercises/subscription","commits_url":"https://api.github.com/repos/ssapra/level_up_exercises/commits{/sha}","git_commits_url":"https://api.github.com/repos/ssapra/level_up_exercises/git/commits{/sha}","comments_url":"https://api.github.com/repos/ssapra/level_up_exercises/comments{/number}","issue_comment_url":"https://api.github.com/repos/ssapra/level_up_exercises/issues/comments{/number}","contents_url":"https://api.github.com/repos/ssapra/level_up_exercises/contents/{+path}","compare_url":"https://api.github.com/repos/ssapra/level_up_exercises/compare/{base}...{head}","merges_url":"https://api.github.com/repos/ssapra/level_up_exercises/merges","archive_url":"https://api.github.com/repos/ssapra/level_up_exercises/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/ssapra/level_up_exercises/downloads","issues_url":"https://api.github.com/repos/ssapra/level_up_exercises/issues{/number}","pulls_url":"https://api.github.com/repos/ssapra/level_up_exercises/pulls{/number}","milestones_url":"https://api.github.com/repos/ssapra/level_up_exercises/milestones{/number}","notifications_url":"https://api.github.com/repos/ssapra/level_up_exercises/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/ssapra/level_up_exercises/labels{/name}","releases_url":"https://api.github.com/repos/ssapra/level_up_exercises/releases{/id}","created_at":"2015-07-14T19:24:32Z","updated_at":"2015-07-14T19:24:32Z","pushed_at":"2015-08-28T14:21:30Z","git_url":"git://github.com/ssapra/level_up_exercises.git","ssh_url":"git@github.com:ssapra/level_up_exercises.git","clone_url":"https://github.com/ssapra/level_up_exercises.git","svn_url":"https://github.com/ssapra/level_up_exercises","homepage":"http://leveluprails.herokuapp.com","size":3353,"stargazers_count":0,"watchers_count":0,"language":"Ruby","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":"jmmastey:master","ref":"master","sha":"573aed5af1dff6995e407c7c9c16cdaa9aa183ca","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-07-09T21:47:15Z","pushed_at":"2015-08-28T14:25:13Z","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":222816,"stargazers_count":27,"watchers_count":27,"language":"Ruby","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":138,"mirror_url":null,"open_issues_count":16,"forks":138,"open_issues":16,"watchers":27,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/956"},"html":{"href":"https://github.com/jmmastey/level_up_exercises/pull/956"},"issue":{"href":"https://api.github.com/repos/jmmastey/level_up_exercises/issues/956"},"comments":{"href":"https://api.github.com/repos/jmmastey/level_up_exercises/issues/956/comments"},"review_comments":{"href":"https://api.github.com/repos/jmmastey/level_up_exercises/pulls/956/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/956/commits"},"statuses":{"href":"https://api.github.com/repos/jmmastey/level_up_exercises/statuses/946d5b46970f61d9e543348ec38af3adb39b651e"}}}}