{"action":"closed","number":144,"pull_request":{"url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/pulls/144","id":54097410,"html_url":"https://github.com/ocadotechnology/codeforlife-portal/pull/144","diff_url":"https://github.com/ocadotechnology/codeforlife-portal/pull/144.diff","patch_url":"https://github.com/ocadotechnology/codeforlife-portal/pull/144.patch","issue_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/issues/144","number":144,"state":"closed","locked":false,"title":"Performance: Reduce the number of queries used in the admin/data page","user":{"login":"mikebryant","id":1478103,"avatar_url":"https://avatars.githubusercontent.com/u/1478103?v=3","gravatar_id":"","url":"https://api.github.com/users/mikebryant","html_url":"https://github.com/mikebryant","followers_url":"https://api.github.com/users/mikebryant/followers","following_url":"https://api.github.com/users/mikebryant/following{/other_user}","gists_url":"https://api.github.com/users/mikebryant/gists{/gist_id}","starred_url":"https://api.github.com/users/mikebryant/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mikebryant/subscriptions","organizations_url":"https://api.github.com/users/mikebryant/orgs","repos_url":"https://api.github.com/users/mikebryant/repos","events_url":"https://api.github.com/users/mikebryant/events{/privacy}","received_events_url":"https://api.github.com/users/mikebryant/received_events","type":"User","site_admin":false},"body":"","created_at":"2015-12-18T12:29:38Z","updated_at":"2015-12-18T15:16:50Z","closed_at":"2015-12-18T15:16:50Z","merged_at":"2015-12-18T15:16:50Z","merge_commit_sha":"bb075624fb1c4af40430c8d81c22572c021e1406","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/pulls/144/commits","review_comments_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/pulls/144/comments","review_comment_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/pulls/comments{/number}","comments_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/issues/144/comments","statuses_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/statuses/988e52209c306cc061d2f30528fa848cabba0649","head":{"label":"mikebryant:admin-data-reduce-queries","ref":"admin-data-reduce-queries","sha":"988e52209c306cc061d2f30528fa848cabba0649","user":{"login":"mikebryant","id":1478103,"avatar_url":"https://avatars.githubusercontent.com/u/1478103?v=3","gravatar_id":"","url":"https://api.github.com/users/mikebryant","html_url":"https://github.com/mikebryant","followers_url":"https://api.github.com/users/mikebryant/followers","following_url":"https://api.github.com/users/mikebryant/following{/other_user}","gists_url":"https://api.github.com/users/mikebryant/gists{/gist_id}","starred_url":"https://api.github.com/users/mikebryant/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mikebryant/subscriptions","organizations_url":"https://api.github.com/users/mikebryant/orgs","repos_url":"https://api.github.com/users/mikebryant/repos","events_url":"https://api.github.com/users/mikebryant/events{/privacy}","received_events_url":"https://api.github.com/users/mikebryant/received_events","type":"User","site_admin":false},"repo":{"id":45481784,"name":"codeforlife-portal","full_name":"mikebryant/codeforlife-portal","owner":{"login":"mikebryant","id":1478103,"avatar_url":"https://avatars.githubusercontent.com/u/1478103?v=3","gravatar_id":"","url":"https://api.github.com/users/mikebryant","html_url":"https://github.com/mikebryant","followers_url":"https://api.github.com/users/mikebryant/followers","following_url":"https://api.github.com/users/mikebryant/following{/other_user}","gists_url":"https://api.github.com/users/mikebryant/gists{/gist_id}","starred_url":"https://api.github.com/users/mikebryant/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mikebryant/subscriptions","organizations_url":"https://api.github.com/users/mikebryant/orgs","repos_url":"https://api.github.com/users/mikebryant/repos","events_url":"https://api.github.com/users/mikebryant/events{/privacy}","received_events_url":"https://api.github.com/users/mikebryant/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/mikebryant/codeforlife-portal","description":"The portal code for Code for Life","fork":true,"url":"https://api.github.com/repos/mikebryant/codeforlife-portal","forks_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/forks","keys_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/keys{/key_id}","collaborators_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/teams","hooks_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/hooks","issue_events_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/issues/events{/number}","events_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/events","assignees_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/assignees{/user}","branches_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/branches{/branch}","tags_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/tags","blobs_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/git/refs{/sha}","trees_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/git/trees{/sha}","statuses_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/statuses/{sha}","languages_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/languages","stargazers_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/stargazers","contributors_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/contributors","subscribers_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/subscribers","subscription_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/subscription","commits_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/commits{/sha}","git_commits_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/git/commits{/sha}","comments_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/comments{/number}","issue_comment_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/issues/comments{/number}","contents_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/contents/{+path}","compare_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/compare/{base}...{head}","merges_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/merges","archive_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/downloads","issues_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/issues{/number}","pulls_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/pulls{/number}","milestones_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/milestones{/number}","notifications_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/labels{/name}","releases_url":"https://api.github.com/repos/mikebryant/codeforlife-portal/releases{/id}","created_at":"2015-11-03T17:02:45Z","updated_at":"2015-11-03T17:02:48Z","pushed_at":"2015-12-18T14:43:02Z","git_url":"git://github.com/mikebryant/codeforlife-portal.git","ssh_url":"git@github.com:mikebryant/codeforlife-portal.git","clone_url":"https://github.com/mikebryant/codeforlife-portal.git","svn_url":"https://github.com/mikebryant/codeforlife-portal","homepage":null,"size":52691,"stargazers_count":0,"watchers_count":0,"language":"Python","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":"ocadotechnology:master","ref":"master","sha":"e95e011bcb7a788cd0cbbda830992c49cfe09cef","user":{"login":"ocadotechnology","id":2088731,"avatar_url":"https://avatars.githubusercontent.com/u/2088731?v=3","gravatar_id":"","url":"https://api.github.com/users/ocadotechnology","html_url":"https://github.com/ocadotechnology","followers_url":"https://api.github.com/users/ocadotechnology/followers","following_url":"https://api.github.com/users/ocadotechnology/following{/other_user}","gists_url":"https://api.github.com/users/ocadotechnology/gists{/gist_id}","starred_url":"https://api.github.com/users/ocadotechnology/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ocadotechnology/subscriptions","organizations_url":"https://api.github.com/users/ocadotechnology/orgs","repos_url":"https://api.github.com/users/ocadotechnology/repos","events_url":"https://api.github.com/users/ocadotechnology/events{/privacy}","received_events_url":"https://api.github.com/users/ocadotechnology/received_events","type":"Organization","site_admin":false},"repo":{"id":22154147,"name":"codeforlife-portal","full_name":"ocadotechnology/codeforlife-portal","owner":{"login":"ocadotechnology","id":2088731,"avatar_url":"https://avatars.githubusercontent.com/u/2088731?v=3","gravatar_id":"","url":"https://api.github.com/users/ocadotechnology","html_url":"https://github.com/ocadotechnology","followers_url":"https://api.github.com/users/ocadotechnology/followers","following_url":"https://api.github.com/users/ocadotechnology/following{/other_user}","gists_url":"https://api.github.com/users/ocadotechnology/gists{/gist_id}","starred_url":"https://api.github.com/users/ocadotechnology/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ocadotechnology/subscriptions","organizations_url":"https://api.github.com/users/ocadotechnology/orgs","repos_url":"https://api.github.com/users/ocadotechnology/repos","events_url":"https://api.github.com/users/ocadotechnology/events{/privacy}","received_events_url":"https://api.github.com/users/ocadotechnology/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/ocadotechnology/codeforlife-portal","description":"The portal code for Code for Life","fork":false,"url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal","forks_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/forks","keys_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/keys{/key_id}","collaborators_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/teams","hooks_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/hooks","issue_events_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/issues/events{/number}","events_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/events","assignees_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/assignees{/user}","branches_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/branches{/branch}","tags_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/tags","blobs_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/git/refs{/sha}","trees_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/git/trees{/sha}","statuses_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/statuses/{sha}","languages_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/languages","stargazers_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/stargazers","contributors_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/contributors","subscribers_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/subscribers","subscription_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/subscription","commits_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/commits{/sha}","git_commits_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/git/commits{/sha}","comments_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/comments{/number}","issue_comment_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/issues/comments{/number}","contents_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/contents/{+path}","compare_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/compare/{base}...{head}","merges_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/merges","archive_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/downloads","issues_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/issues{/number}","pulls_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/pulls{/number}","milestones_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/milestones{/number}","notifications_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/labels{/name}","releases_url":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/releases{/id}","created_at":"2014-07-23T14:44:13Z","updated_at":"2015-12-17T14:53:37Z","pushed_at":"2015-12-18T15:16:50Z","git_url":"git://github.com/ocadotechnology/codeforlife-portal.git","ssh_url":"git@github.com:ocadotechnology/codeforlife-portal.git","clone_url":"https://github.com/ocadotechnology/codeforlife-portal.git","svn_url":"https://github.com/ocadotechnology/codeforlife-portal","homepage":null,"size":52714,"stargazers_count":4,"watchers_count":4,"language":"Python","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":4,"mirror_url":null,"open_issues_count":13,"forks":4,"open_issues":13,"watchers":4,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/pulls/144"},"html":{"href":"https://github.com/ocadotechnology/codeforlife-portal/pull/144"},"issue":{"href":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/issues/144"},"comments":{"href":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/issues/144/comments"},"review_comments":{"href":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/pulls/144/comments"},"review_comment":{"href":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/pulls/144/commits"},"statuses":{"href":"https://api.github.com/repos/ocadotechnology/codeforlife-portal/statuses/988e52209c306cc061d2f30528fa848cabba0649"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"login":"Spycho","id":710498,"avatar_url":"https://avatars.githubusercontent.com/u/710498?v=3","gravatar_id":"","url":"https://api.github.com/users/Spycho","html_url":"https://github.com/Spycho","followers_url":"https://api.github.com/users/Spycho/followers","following_url":"https://api.github.com/users/Spycho/following{/other_user}","gists_url":"https://api.github.com/users/Spycho/gists{/gist_id}","starred_url":"https://api.github.com/users/Spycho/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Spycho/subscriptions","organizations_url":"https://api.github.com/users/Spycho/orgs","repos_url":"https://api.github.com/users/Spycho/repos","events_url":"https://api.github.com/users/Spycho/events{/privacy}","received_events_url":"https://api.github.com/users/Spycho/received_events","type":"User","site_admin":false},"comments":3,"review_comments":0,"commits":1,"additions":13,"deletions":10,"changed_files":1}}