{"action":"closed","number":151,"pull_request":{"url":"https://api.github.com/repos/rapid7/metasploit_data_models/pulls/151","id":60565705,"html_url":"https://github.com/rapid7/metasploit_data_models/pull/151","diff_url":"https://github.com/rapid7/metasploit_data_models/pull/151.diff","patch_url":"https://github.com/rapid7/metasploit_data_models/pull/151.patch","issue_url":"https://api.github.com/repos/rapid7/metasploit_data_models/issues/151","number":151,"state":"closed","locked":false,"title":"Fix eager loading table(s) that are referenced in a string SQL snippe…","user":{"login":"farias-r7","id":3832705,"avatar_url":"https://avatars.githubusercontent.com/u/3832705?v=3","gravatar_id":"","url":"https://api.github.com/users/farias-r7","html_url":"https://github.com/farias-r7","followers_url":"https://api.github.com/users/farias-r7/followers","following_url":"https://api.github.com/users/farias-r7/following{/other_user}","gists_url":"https://api.github.com/users/farias-r7/gists{/gist_id}","starred_url":"https://api.github.com/users/farias-r7/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/farias-r7/subscriptions","organizations_url":"https://api.github.com/users/farias-r7/orgs","repos_url":"https://api.github.com/users/farias-r7/repos","events_url":"https://api.github.com/users/farias-r7/events{/privacy}","received_events_url":"https://api.github.com/users/farias-r7/received_events","type":"User","site_admin":false},"body":"*Cherry picked commit with actual MS-899 fix. We need to merge into staging/rails-upgrade because it was merged into staging/rails-4.0-deprecations instead. https://github.com/rapid7/metasploit_data_models/pull/150\r\n\r\nDEPRECATION WARNING: It looks like you are eager loading table(s) that are referenced in a string SQL snippet.\r\n\r\n# Verification Steps\r\n\r\n- [ ] `bundle install`\r\n\r\n## `rake spec`\r\n- [ ] `rake spec`\r\n- [ ] VERIFY no failures\r\n\r\n## `rake yard`\r\n- [ ] `rake yard`\r\n- [ ] VERIFY no undocumented objects","created_at":"2016-02-24T19:39:14Z","updated_at":"2016-03-07T18:39:42Z","closed_at":"2016-03-07T18:39:42Z","merged_at":null,"merge_commit_sha":"21de70c5ec23095d75bd44dfef1d89139d0b31db","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/rapid7/metasploit_data_models/pulls/151/commits","review_comments_url":"https://api.github.com/repos/rapid7/metasploit_data_models/pulls/151/comments","review_comment_url":"https://api.github.com/repos/rapid7/metasploit_data_models/pulls/comments{/number}","comments_url":"https://api.github.com/repos/rapid7/metasploit_data_models/issues/151/comments","statuses_url":"https://api.github.com/repos/rapid7/metasploit_data_models/statuses/7f6417d0154988f200c547e2a4d24ff37218b26c","head":{"label":"farias-r7:bug/MS-899/string-sql-eager-load-2","ref":"bug/MS-899/string-sql-eager-load-2","sha":"7f6417d0154988f200c547e2a4d24ff37218b26c","user":{"login":"farias-r7","id":3832705,"avatar_url":"https://avatars.githubusercontent.com/u/3832705?v=3","gravatar_id":"","url":"https://api.github.com/users/farias-r7","html_url":"https://github.com/farias-r7","followers_url":"https://api.github.com/users/farias-r7/followers","following_url":"https://api.github.com/users/farias-r7/following{/other_user}","gists_url":"https://api.github.com/users/farias-r7/gists{/gist_id}","starred_url":"https://api.github.com/users/farias-r7/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/farias-r7/subscriptions","organizations_url":"https://api.github.com/users/farias-r7/orgs","repos_url":"https://api.github.com/users/farias-r7/repos","events_url":"https://api.github.com/users/farias-r7/events{/privacy}","received_events_url":"https://api.github.com/users/farias-r7/received_events","type":"User","site_admin":false},"repo":{"id":42542390,"name":"metasploit_data_models","full_name":"farias-r7/metasploit_data_models","owner":{"login":"farias-r7","id":3832705,"avatar_url":"https://avatars.githubusercontent.com/u/3832705?v=3","gravatar_id":"","url":"https://api.github.com/users/farias-r7","html_url":"https://github.com/farias-r7","followers_url":"https://api.github.com/users/farias-r7/followers","following_url":"https://api.github.com/users/farias-r7/following{/other_user}","gists_url":"https://api.github.com/users/farias-r7/gists{/gist_id}","starred_url":"https://api.github.com/users/farias-r7/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/farias-r7/subscriptions","organizations_url":"https://api.github.com/users/farias-r7/orgs","repos_url":"https://api.github.com/users/farias-r7/repos","events_url":"https://api.github.com/users/farias-r7/events{/privacy}","received_events_url":"https://api.github.com/users/farias-r7/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/farias-r7/metasploit_data_models","description":"MSF database code, gemified","fork":true,"url":"https://api.github.com/repos/farias-r7/metasploit_data_models","forks_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/forks","keys_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/keys{/key_id}","collaborators_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/teams","hooks_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/hooks","issue_events_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/issues/events{/number}","events_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/events","assignees_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/assignees{/user}","branches_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/branches{/branch}","tags_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/tags","blobs_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/git/refs{/sha}","trees_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/git/trees{/sha}","statuses_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/statuses/{sha}","languages_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/languages","stargazers_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/stargazers","contributors_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/contributors","subscribers_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/subscribers","subscription_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/subscription","commits_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/commits{/sha}","git_commits_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/git/commits{/sha}","comments_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/comments{/number}","issue_comment_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/issues/comments{/number}","contents_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/contents/{+path}","compare_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/compare/{base}...{head}","merges_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/merges","archive_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/downloads","issues_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/issues{/number}","pulls_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/pulls{/number}","milestones_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/milestones{/number}","notifications_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/labels{/name}","releases_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/releases{/id}","deployments_url":"https://api.github.com/repos/farias-r7/metasploit_data_models/deployments","created_at":"2015-09-15T19:45:22Z","updated_at":"2015-09-15T19:45:23Z","pushed_at":"2016-02-24T19:36:30Z","git_url":"git://github.com/farias-r7/metasploit_data_models.git","ssh_url":"git@github.com:farias-r7/metasploit_data_models.git","clone_url":"https://github.com/farias-r7/metasploit_data_models.git","svn_url":"https://github.com/farias-r7/metasploit_data_models","homepage":"","size":4128,"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":"rapid7:staging/rails-upgrade","ref":"staging/rails-upgrade","sha":"97197d0955936ee2f0881dd262951dfc667b905b","user":{"login":"rapid7","id":1013671,"avatar_url":"https://avatars.githubusercontent.com/u/1013671?v=3","gravatar_id":"","url":"https://api.github.com/users/rapid7","html_url":"https://github.com/rapid7","followers_url":"https://api.github.com/users/rapid7/followers","following_url":"https://api.github.com/users/rapid7/following{/other_user}","gists_url":"https://api.github.com/users/rapid7/gists{/gist_id}","starred_url":"https://api.github.com/users/rapid7/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rapid7/subscriptions","organizations_url":"https://api.github.com/users/rapid7/orgs","repos_url":"https://api.github.com/users/rapid7/repos","events_url":"https://api.github.com/users/rapid7/events{/privacy}","received_events_url":"https://api.github.com/users/rapid7/received_events","type":"Organization","site_admin":false},"repo":{"id":3072132,"name":"metasploit_data_models","full_name":"rapid7/metasploit_data_models","owner":{"login":"rapid7","id":1013671,"avatar_url":"https://avatars.githubusercontent.com/u/1013671?v=3","gravatar_id":"","url":"https://api.github.com/users/rapid7","html_url":"https://github.com/rapid7","followers_url":"https://api.github.com/users/rapid7/followers","following_url":"https://api.github.com/users/rapid7/following{/other_user}","gists_url":"https://api.github.com/users/rapid7/gists{/gist_id}","starred_url":"https://api.github.com/users/rapid7/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rapid7/subscriptions","organizations_url":"https://api.github.com/users/rapid7/orgs","repos_url":"https://api.github.com/users/rapid7/repos","events_url":"https://api.github.com/users/rapid7/events{/privacy}","received_events_url":"https://api.github.com/users/rapid7/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/rapid7/metasploit_data_models","description":"MSF database code, gemified","fork":false,"url":"https://api.github.com/repos/rapid7/metasploit_data_models","forks_url":"https://api.github.com/repos/rapid7/metasploit_data_models/forks","keys_url":"https://api.github.com/repos/rapid7/metasploit_data_models/keys{/key_id}","collaborators_url":"https://api.github.com/repos/rapid7/metasploit_data_models/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/rapid7/metasploit_data_models/teams","hooks_url":"https://api.github.com/repos/rapid7/metasploit_data_models/hooks","issue_events_url":"https://api.github.com/repos/rapid7/metasploit_data_models/issues/events{/number}","events_url":"https://api.github.com/repos/rapid7/metasploit_data_models/events","assignees_url":"https://api.github.com/repos/rapid7/metasploit_data_models/assignees{/user}","branches_url":"https://api.github.com/repos/rapid7/metasploit_data_models/branches{/branch}","tags_url":"https://api.github.com/repos/rapid7/metasploit_data_models/tags","blobs_url":"https://api.github.com/repos/rapid7/metasploit_data_models/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/rapid7/metasploit_data_models/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/rapid7/metasploit_data_models/git/refs{/sha}","trees_url":"https://api.github.com/repos/rapid7/metasploit_data_models/git/trees{/sha}","statuses_url":"https://api.github.com/repos/rapid7/metasploit_data_models/statuses/{sha}","languages_url":"https://api.github.com/repos/rapid7/metasploit_data_models/languages","stargazers_url":"https://api.github.com/repos/rapid7/metasploit_data_models/stargazers","contributors_url":"https://api.github.com/repos/rapid7/metasploit_data_models/contributors","subscribers_url":"https://api.github.com/repos/rapid7/metasploit_data_models/subscribers","subscription_url":"https://api.github.com/repos/rapid7/metasploit_data_models/subscription","commits_url":"https://api.github.com/repos/rapid7/metasploit_data_models/commits{/sha}","git_commits_url":"https://api.github.com/repos/rapid7/metasploit_data_models/git/commits{/sha}","comments_url":"https://api.github.com/repos/rapid7/metasploit_data_models/comments{/number}","issue_comment_url":"https://api.github.com/repos/rapid7/metasploit_data_models/issues/comments{/number}","contents_url":"https://api.github.com/repos/rapid7/metasploit_data_models/contents/{+path}","compare_url":"https://api.github.com/repos/rapid7/metasploit_data_models/compare/{base}...{head}","merges_url":"https://api.github.com/repos/rapid7/metasploit_data_models/merges","archive_url":"https://api.github.com/repos/rapid7/metasploit_data_models/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/rapid7/metasploit_data_models/downloads","issues_url":"https://api.github.com/repos/rapid7/metasploit_data_models/issues{/number}","pulls_url":"https://api.github.com/repos/rapid7/metasploit_data_models/pulls{/number}","milestones_url":"https://api.github.com/repos/rapid7/metasploit_data_models/milestones{/number}","notifications_url":"https://api.github.com/repos/rapid7/metasploit_data_models/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/rapid7/metasploit_data_models/labels{/name}","releases_url":"https://api.github.com/repos/rapid7/metasploit_data_models/releases{/id}","deployments_url":"https://api.github.com/repos/rapid7/metasploit_data_models/deployments","created_at":"2011-12-30T01:15:12Z","updated_at":"2016-02-21T05:56:57Z","pushed_at":"2016-03-07T18:39:42Z","git_url":"git://github.com/rapid7/metasploit_data_models.git","ssh_url":"git@github.com:rapid7/metasploit_data_models.git","clone_url":"https://github.com/rapid7/metasploit_data_models.git","svn_url":"https://github.com/rapid7/metasploit_data_models","homepage":"","size":4189,"stargazers_count":23,"watchers_count":23,"language":"Ruby","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":31,"mirror_url":null,"open_issues_count":3,"forks":31,"open_issues":3,"watchers":23,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/rapid7/metasploit_data_models/pulls/151"},"html":{"href":"https://github.com/rapid7/metasploit_data_models/pull/151"},"issue":{"href":"https://api.github.com/repos/rapid7/metasploit_data_models/issues/151"},"comments":{"href":"https://api.github.com/repos/rapid7/metasploit_data_models/issues/151/comments"},"review_comments":{"href":"https://api.github.com/repos/rapid7/metasploit_data_models/pulls/151/comments"},"review_comment":{"href":"https://api.github.com/repos/rapid7/metasploit_data_models/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/rapid7/metasploit_data_models/pulls/151/commits"},"statuses":{"href":"https://api.github.com/repos/rapid7/metasploit_data_models/statuses/7f6417d0154988f200c547e2a4d24ff37218b26c"}},"merged":false,"mergeable":false,"mergeable_state":"dirty","merged_by":null,"comments":0,"review_comments":0,"commits":1,"additions":3,"deletions":3,"changed_files":2}}