{"action":"closed","number":54,"pull_request":{"url":"https://api.github.com/repos/ops-trust/portal/pulls/54","id":54699828,"html_url":"https://github.com/ops-trust/portal/pull/54","diff_url":"https://github.com/ops-trust/portal/pull/54.diff","patch_url":"https://github.com/ops-trust/portal/pull/54.patch","issue_url":"https://api.github.com/repos/ops-trust/portal/issues/54","number":54,"state":"closed","locked":false,"title":"Update SQL statement, to only list keys that are connected to an acti…","user":{"login":"bapril","id":827792,"avatar_url":"https://avatars.githubusercontent.com/u/827792?v=3","gravatar_id":"","url":"https://api.github.com/users/bapril","html_url":"https://github.com/bapril","followers_url":"https://api.github.com/users/bapril/followers","following_url":"https://api.github.com/users/bapril/following{/other_user}","gists_url":"https://api.github.com/users/bapril/gists{/gist_id}","starred_url":"https://api.github.com/users/bapril/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bapril/subscriptions","organizations_url":"https://api.github.com/users/bapril/orgs","repos_url":"https://api.github.com/users/bapril/repos","events_url":"https://api.github.com/users/bapril/events{/privacy}","received_events_url":"https://api.github.com/users/bapril/received_events","type":"User","site_admin":false},"body":"Fixing issue #53 ","created_at":"2015-12-29T03:21:42Z","updated_at":"2016-03-29T17:54:18Z","closed_at":"2016-03-29T17:54:18Z","merged_at":"2016-03-29T17:54:18Z","merge_commit_sha":"4babd24f9352aca3b37d84308787fa16bc45d7b7","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/ops-trust/portal/pulls/54/commits","review_comments_url":"https://api.github.com/repos/ops-trust/portal/pulls/54/comments","review_comment_url":"https://api.github.com/repos/ops-trust/portal/pulls/comments{/number}","comments_url":"https://api.github.com/repos/ops-trust/portal/issues/54/comments","statuses_url":"https://api.github.com/repos/ops-trust/portal/statuses/ceaf01f7a230505877e458f1e68dff01e43b7e40","head":{"label":"ops-trust:issue_53","ref":"issue_53","sha":"ceaf01f7a230505877e458f1e68dff01e43b7e40","user":{"login":"ops-trust","id":8291916,"avatar_url":"https://avatars.githubusercontent.com/u/8291916?v=3","gravatar_id":"","url":"https://api.github.com/users/ops-trust","html_url":"https://github.com/ops-trust","followers_url":"https://api.github.com/users/ops-trust/followers","following_url":"https://api.github.com/users/ops-trust/following{/other_user}","gists_url":"https://api.github.com/users/ops-trust/gists{/gist_id}","starred_url":"https://api.github.com/users/ops-trust/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ops-trust/subscriptions","organizations_url":"https://api.github.com/users/ops-trust/orgs","repos_url":"https://api.github.com/users/ops-trust/repos","events_url":"https://api.github.com/users/ops-trust/events{/privacy}","received_events_url":"https://api.github.com/users/ops-trust/received_events","type":"Organization","site_admin":false},"repo":{"id":25702676,"name":"portal","full_name":"ops-trust/portal","owner":{"login":"ops-trust","id":8291916,"avatar_url":"https://avatars.githubusercontent.com/u/8291916?v=3","gravatar_id":"","url":"https://api.github.com/users/ops-trust","html_url":"https://github.com/ops-trust","followers_url":"https://api.github.com/users/ops-trust/followers","following_url":"https://api.github.com/users/ops-trust/following{/other_user}","gists_url":"https://api.github.com/users/ops-trust/gists{/gist_id}","starred_url":"https://api.github.com/users/ops-trust/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ops-trust/subscriptions","organizations_url":"https://api.github.com/users/ops-trust/orgs","repos_url":"https://api.github.com/users/ops-trust/repos","events_url":"https://api.github.com/users/ops-trust/events{/privacy}","received_events_url":"https://api.github.com/users/ops-trust/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/ops-trust/portal","description":"Ops-Trust Platform - Portal","fork":false,"url":"https://api.github.com/repos/ops-trust/portal","forks_url":"https://api.github.com/repos/ops-trust/portal/forks","keys_url":"https://api.github.com/repos/ops-trust/portal/keys{/key_id}","collaborators_url":"https://api.github.com/repos/ops-trust/portal/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/ops-trust/portal/teams","hooks_url":"https://api.github.com/repos/ops-trust/portal/hooks","issue_events_url":"https://api.github.com/repos/ops-trust/portal/issues/events{/number}","events_url":"https://api.github.com/repos/ops-trust/portal/events","assignees_url":"https://api.github.com/repos/ops-trust/portal/assignees{/user}","branches_url":"https://api.github.com/repos/ops-trust/portal/branches{/branch}","tags_url":"https://api.github.com/repos/ops-trust/portal/tags","blobs_url":"https://api.github.com/repos/ops-trust/portal/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/ops-trust/portal/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/ops-trust/portal/git/refs{/sha}","trees_url":"https://api.github.com/repos/ops-trust/portal/git/trees{/sha}","statuses_url":"https://api.github.com/repos/ops-trust/portal/statuses/{sha}","languages_url":"https://api.github.com/repos/ops-trust/portal/languages","stargazers_url":"https://api.github.com/repos/ops-trust/portal/stargazers","contributors_url":"https://api.github.com/repos/ops-trust/portal/contributors","subscribers_url":"https://api.github.com/repos/ops-trust/portal/subscribers","subscription_url":"https://api.github.com/repos/ops-trust/portal/subscription","commits_url":"https://api.github.com/repos/ops-trust/portal/commits{/sha}","git_commits_url":"https://api.github.com/repos/ops-trust/portal/git/commits{/sha}","comments_url":"https://api.github.com/repos/ops-trust/portal/comments{/number}","issue_comment_url":"https://api.github.com/repos/ops-trust/portal/issues/comments{/number}","contents_url":"https://api.github.com/repos/ops-trust/portal/contents/{+path}","compare_url":"https://api.github.com/repos/ops-trust/portal/compare/{base}...{head}","merges_url":"https://api.github.com/repos/ops-trust/portal/merges","archive_url":"https://api.github.com/repos/ops-trust/portal/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/ops-trust/portal/downloads","issues_url":"https://api.github.com/repos/ops-trust/portal/issues{/number}","pulls_url":"https://api.github.com/repos/ops-trust/portal/pulls{/number}","milestones_url":"https://api.github.com/repos/ops-trust/portal/milestones{/number}","notifications_url":"https://api.github.com/repos/ops-trust/portal/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/ops-trust/portal/labels{/name}","releases_url":"https://api.github.com/repos/ops-trust/portal/releases{/id}","deployments_url":"https://api.github.com/repos/ops-trust/portal/deployments","created_at":"2014-10-24T18:42:24Z","updated_at":"2016-03-23T00:45:44Z","pushed_at":"2016-03-29T17:54:18Z","git_url":"git://github.com/ops-trust/portal.git","ssh_url":"git@github.com:ops-trust/portal.git","clone_url":"https://github.com/ops-trust/portal.git","svn_url":"https://github.com/ops-trust/portal","homepage":"https://www.ops-trust.net","size":154,"stargazers_count":14,"watchers_count":14,"language":"HTML","has_issues":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":2,"mirror_url":null,"open_issues_count":44,"forks":2,"open_issues":44,"watchers":14,"default_branch":"master"}},"base":{"label":"ops-trust:master","ref":"master","sha":"ec4dff1a1fd90425b543d1286a3c268ab8bf2b67","user":{"login":"ops-trust","id":8291916,"avatar_url":"https://avatars.githubusercontent.com/u/8291916?v=3","gravatar_id":"","url":"https://api.github.com/users/ops-trust","html_url":"https://github.com/ops-trust","followers_url":"https://api.github.com/users/ops-trust/followers","following_url":"https://api.github.com/users/ops-trust/following{/other_user}","gists_url":"https://api.github.com/users/ops-trust/gists{/gist_id}","starred_url":"https://api.github.com/users/ops-trust/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ops-trust/subscriptions","organizations_url":"https://api.github.com/users/ops-trust/orgs","repos_url":"https://api.github.com/users/ops-trust/repos","events_url":"https://api.github.com/users/ops-trust/events{/privacy}","received_events_url":"https://api.github.com/users/ops-trust/received_events","type":"Organization","site_admin":false},"repo":{"id":25702676,"name":"portal","full_name":"ops-trust/portal","owner":{"login":"ops-trust","id":8291916,"avatar_url":"https://avatars.githubusercontent.com/u/8291916?v=3","gravatar_id":"","url":"https://api.github.com/users/ops-trust","html_url":"https://github.com/ops-trust","followers_url":"https://api.github.com/users/ops-trust/followers","following_url":"https://api.github.com/users/ops-trust/following{/other_user}","gists_url":"https://api.github.com/users/ops-trust/gists{/gist_id}","starred_url":"https://api.github.com/users/ops-trust/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ops-trust/subscriptions","organizations_url":"https://api.github.com/users/ops-trust/orgs","repos_url":"https://api.github.com/users/ops-trust/repos","events_url":"https://api.github.com/users/ops-trust/events{/privacy}","received_events_url":"https://api.github.com/users/ops-trust/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/ops-trust/portal","description":"Ops-Trust Platform - Portal","fork":false,"url":"https://api.github.com/repos/ops-trust/portal","forks_url":"https://api.github.com/repos/ops-trust/portal/forks","keys_url":"https://api.github.com/repos/ops-trust/portal/keys{/key_id}","collaborators_url":"https://api.github.com/repos/ops-trust/portal/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/ops-trust/portal/teams","hooks_url":"https://api.github.com/repos/ops-trust/portal/hooks","issue_events_url":"https://api.github.com/repos/ops-trust/portal/issues/events{/number}","events_url":"https://api.github.com/repos/ops-trust/portal/events","assignees_url":"https://api.github.com/repos/ops-trust/portal/assignees{/user}","branches_url":"https://api.github.com/repos/ops-trust/portal/branches{/branch}","tags_url":"https://api.github.com/repos/ops-trust/portal/tags","blobs_url":"https://api.github.com/repos/ops-trust/portal/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/ops-trust/portal/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/ops-trust/portal/git/refs{/sha}","trees_url":"https://api.github.com/repos/ops-trust/portal/git/trees{/sha}","statuses_url":"https://api.github.com/repos/ops-trust/portal/statuses/{sha}","languages_url":"https://api.github.com/repos/ops-trust/portal/languages","stargazers_url":"https://api.github.com/repos/ops-trust/portal/stargazers","contributors_url":"https://api.github.com/repos/ops-trust/portal/contributors","subscribers_url":"https://api.github.com/repos/ops-trust/portal/subscribers","subscription_url":"https://api.github.com/repos/ops-trust/portal/subscription","commits_url":"https://api.github.com/repos/ops-trust/portal/commits{/sha}","git_commits_url":"https://api.github.com/repos/ops-trust/portal/git/commits{/sha}","comments_url":"https://api.github.com/repos/ops-trust/portal/comments{/number}","issue_comment_url":"https://api.github.com/repos/ops-trust/portal/issues/comments{/number}","contents_url":"https://api.github.com/repos/ops-trust/portal/contents/{+path}","compare_url":"https://api.github.com/repos/ops-trust/portal/compare/{base}...{head}","merges_url":"https://api.github.com/repos/ops-trust/portal/merges","archive_url":"https://api.github.com/repos/ops-trust/portal/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/ops-trust/portal/downloads","issues_url":"https://api.github.com/repos/ops-trust/portal/issues{/number}","pulls_url":"https://api.github.com/repos/ops-trust/portal/pulls{/number}","milestones_url":"https://api.github.com/repos/ops-trust/portal/milestones{/number}","notifications_url":"https://api.github.com/repos/ops-trust/portal/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/ops-trust/portal/labels{/name}","releases_url":"https://api.github.com/repos/ops-trust/portal/releases{/id}","deployments_url":"https://api.github.com/repos/ops-trust/portal/deployments","created_at":"2014-10-24T18:42:24Z","updated_at":"2016-03-23T00:45:44Z","pushed_at":"2016-03-29T17:54:18Z","git_url":"git://github.com/ops-trust/portal.git","ssh_url":"git@github.com:ops-trust/portal.git","clone_url":"https://github.com/ops-trust/portal.git","svn_url":"https://github.com/ops-trust/portal","homepage":"https://www.ops-trust.net","size":154,"stargazers_count":14,"watchers_count":14,"language":"HTML","has_issues":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":2,"mirror_url":null,"open_issues_count":44,"forks":2,"open_issues":44,"watchers":14,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/ops-trust/portal/pulls/54"},"html":{"href":"https://github.com/ops-trust/portal/pull/54"},"issue":{"href":"https://api.github.com/repos/ops-trust/portal/issues/54"},"comments":{"href":"https://api.github.com/repos/ops-trust/portal/issues/54/comments"},"review_comments":{"href":"https://api.github.com/repos/ops-trust/portal/pulls/54/comments"},"review_comment":{"href":"https://api.github.com/repos/ops-trust/portal/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/ops-trust/portal/pulls/54/commits"},"statuses":{"href":"https://api.github.com/repos/ops-trust/portal/statuses/ceaf01f7a230505877e458f1e68dff01e43b7e40"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"login":"massar","id":1963778,"avatar_url":"https://avatars.githubusercontent.com/u/1963778?v=3","gravatar_id":"","url":"https://api.github.com/users/massar","html_url":"https://github.com/massar","followers_url":"https://api.github.com/users/massar/followers","following_url":"https://api.github.com/users/massar/following{/other_user}","gists_url":"https://api.github.com/users/massar/gists{/gist_id}","starred_url":"https://api.github.com/users/massar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/massar/subscriptions","organizations_url":"https://api.github.com/users/massar/orgs","repos_url":"https://api.github.com/users/massar/repos","events_url":"https://api.github.com/users/massar/events{/privacy}","received_events_url":"https://api.github.com/users/massar/received_events","type":"User","site_admin":false},"comments":0,"review_comments":0,"commits":1,"additions":4,"deletions":3,"changed_files":1}}