{"action":"closed","number":6953,"pull_request":{"url":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/6953","id":109986243,"html_url":"https://github.com/CenterForOpenScience/osf.io/pull/6953","diff_url":"https://github.com/CenterForOpenScience/osf.io/pull/6953.diff","patch_url":"https://github.com/CenterForOpenScience/osf.io/pull/6953.patch","issue_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/issues/6953","number":6953,"state":"closed","locked":false,"title":"[RFR] Make explore/new projects page faster [#OSF-7600]","user":{"login":"cwisecarver","id":3709,"avatar_url":"https://avatars2.githubusercontent.com/u/3709?v=3","gravatar_id":"","url":"https://api.github.com/users/cwisecarver","html_url":"https://github.com/cwisecarver","followers_url":"https://api.github.com/users/cwisecarver/followers","following_url":"https://api.github.com/users/cwisecarver/following{/other_user}","gists_url":"https://api.github.com/users/cwisecarver/gists{/gist_id}","starred_url":"https://api.github.com/users/cwisecarver/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cwisecarver/subscriptions","organizations_url":"https://api.github.com/users/cwisecarver/orgs","repos_url":"https://api.github.com/users/cwisecarver/repos","events_url":"https://api.github.com/users/cwisecarver/events{/privacy}","received_events_url":"https://api.github.com/users/cwisecarver/received_events","type":"User","site_admin":false},"body":"<!-- Before submit your Pull Request, make sure you picked\r\n     the right branch:\r\n\r\n     - For hotfixes, select \"master\" as the target branch\r\n     - For new features, select \"develop\" as the target branch\r\n     - For release feature fixes, select the relevant release branch (release/X.Y.Z) as the target branch -->\r\n\r\n## Purpose\r\n\r\nMake explore/new projects page faster\r\n\r\n## Changes\r\n\r\nReplaced modm find and iterative filtering in python with analogous django queryset.\r\n\r\n## Side effects\r\n\r\nUnlikely. Left the previous code in and compared the two result sets to make sure SQL matched the python+modm.\r\n\r\n\r\n## Ticket\r\n\r\n<!-- Link to JIRA ticket, if applicable e.g. https://openscience.atlassian.net/browse/OSF-1234 -->\r\n","created_at":"2017-03-09T19:21:47Z","updated_at":"2017-03-09T23:38:17Z","closed_at":"2017-03-09T23:38:17Z","merged_at":"2017-03-09T23:38:17Z","merge_commit_sha":"27fc0277265ce43d7e86febda7c7720ff284d6a9","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/6953/commits","review_comments_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/6953/comments","review_comment_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/comments{/number}","comments_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/issues/6953/comments","statuses_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/statuses/87fd43e0cf4ef676fbc9177815e2b2fb6cae45ac","head":{"label":"cwisecarver:feature/improve-discovery","ref":"feature/improve-discovery","sha":"87fd43e0cf4ef676fbc9177815e2b2fb6cae45ac","user":{"login":"cwisecarver","id":3709,"avatar_url":"https://avatars2.githubusercontent.com/u/3709?v=3","gravatar_id":"","url":"https://api.github.com/users/cwisecarver","html_url":"https://github.com/cwisecarver","followers_url":"https://api.github.com/users/cwisecarver/followers","following_url":"https://api.github.com/users/cwisecarver/following{/other_user}","gists_url":"https://api.github.com/users/cwisecarver/gists{/gist_id}","starred_url":"https://api.github.com/users/cwisecarver/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cwisecarver/subscriptions","organizations_url":"https://api.github.com/users/cwisecarver/orgs","repos_url":"https://api.github.com/users/cwisecarver/repos","events_url":"https://api.github.com/users/cwisecarver/events{/privacy}","received_events_url":"https://api.github.com/users/cwisecarver/received_events","type":"User","site_admin":false},"repo":{"id":43563889,"name":"osf.io","full_name":"cwisecarver/osf.io","owner":{"login":"cwisecarver","id":3709,"avatar_url":"https://avatars2.githubusercontent.com/u/3709?v=3","gravatar_id":"","url":"https://api.github.com/users/cwisecarver","html_url":"https://github.com/cwisecarver","followers_url":"https://api.github.com/users/cwisecarver/followers","following_url":"https://api.github.com/users/cwisecarver/following{/other_user}","gists_url":"https://api.github.com/users/cwisecarver/gists{/gist_id}","starred_url":"https://api.github.com/users/cwisecarver/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cwisecarver/subscriptions","organizations_url":"https://api.github.com/users/cwisecarver/orgs","repos_url":"https://api.github.com/users/cwisecarver/repos","events_url":"https://api.github.com/users/cwisecarver/events{/privacy}","received_events_url":"https://api.github.com/users/cwisecarver/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/cwisecarver/osf.io","description":"Facilitating Open Science","fork":true,"url":"https://api.github.com/repos/cwisecarver/osf.io","forks_url":"https://api.github.com/repos/cwisecarver/osf.io/forks","keys_url":"https://api.github.com/repos/cwisecarver/osf.io/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cwisecarver/osf.io/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cwisecarver/osf.io/teams","hooks_url":"https://api.github.com/repos/cwisecarver/osf.io/hooks","issue_events_url":"https://api.github.com/repos/cwisecarver/osf.io/issues/events{/number}","events_url":"https://api.github.com/repos/cwisecarver/osf.io/events","assignees_url":"https://api.github.com/repos/cwisecarver/osf.io/assignees{/user}","branches_url":"https://api.github.com/repos/cwisecarver/osf.io/branches{/branch}","tags_url":"https://api.github.com/repos/cwisecarver/osf.io/tags","blobs_url":"https://api.github.com/repos/cwisecarver/osf.io/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cwisecarver/osf.io/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cwisecarver/osf.io/git/refs{/sha}","trees_url":"https://api.github.com/repos/cwisecarver/osf.io/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cwisecarver/osf.io/statuses/{sha}","languages_url":"https://api.github.com/repos/cwisecarver/osf.io/languages","stargazers_url":"https://api.github.com/repos/cwisecarver/osf.io/stargazers","contributors_url":"https://api.github.com/repos/cwisecarver/osf.io/contributors","subscribers_url":"https://api.github.com/repos/cwisecarver/osf.io/subscribers","subscription_url":"https://api.github.com/repos/cwisecarver/osf.io/subscription","commits_url":"https://api.github.com/repos/cwisecarver/osf.io/commits{/sha}","git_commits_url":"https://api.github.com/repos/cwisecarver/osf.io/git/commits{/sha}","comments_url":"https://api.github.com/repos/cwisecarver/osf.io/comments{/number}","issue_comment_url":"https://api.github.com/repos/cwisecarver/osf.io/issues/comments{/number}","contents_url":"https://api.github.com/repos/cwisecarver/osf.io/contents/{+path}","compare_url":"https://api.github.com/repos/cwisecarver/osf.io/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cwisecarver/osf.io/merges","archive_url":"https://api.github.com/repos/cwisecarver/osf.io/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cwisecarver/osf.io/downloads","issues_url":"https://api.github.com/repos/cwisecarver/osf.io/issues{/number}","pulls_url":"https://api.github.com/repos/cwisecarver/osf.io/pulls{/number}","milestones_url":"https://api.github.com/repos/cwisecarver/osf.io/milestones{/number}","notifications_url":"https://api.github.com/repos/cwisecarver/osf.io/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cwisecarver/osf.io/labels{/name}","releases_url":"https://api.github.com/repos/cwisecarver/osf.io/releases{/id}","deployments_url":"https://api.github.com/repos/cwisecarver/osf.io/deployments","created_at":"2015-10-02T16:30:01Z","updated_at":"2016-01-27T20:05:09Z","pushed_at":"2017-03-09T21:13:22Z","git_url":"git://github.com/cwisecarver/osf.io.git","ssh_url":"git@github.com:cwisecarver/osf.io.git","clone_url":"https://github.com/cwisecarver/osf.io.git","svn_url":"https://github.com/cwisecarver/osf.io","homepage":"http://osf.io","size":149743,"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":1,"forks":0,"open_issues":1,"watchers":0,"default_branch":"develop"}},"base":{"label":"CenterForOpenScience:develop","ref":"develop","sha":"a62c12744ada4f7996fe60fc15b9795f96272b3a","user":{"login":"CenterForOpenScience","id":3344584,"avatar_url":"https://avatars2.githubusercontent.com/u/3344584?v=3","gravatar_id":"","url":"https://api.github.com/users/CenterForOpenScience","html_url":"https://github.com/CenterForOpenScience","followers_url":"https://api.github.com/users/CenterForOpenScience/followers","following_url":"https://api.github.com/users/CenterForOpenScience/following{/other_user}","gists_url":"https://api.github.com/users/CenterForOpenScience/gists{/gist_id}","starred_url":"https://api.github.com/users/CenterForOpenScience/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CenterForOpenScience/subscriptions","organizations_url":"https://api.github.com/users/CenterForOpenScience/orgs","repos_url":"https://api.github.com/users/CenterForOpenScience/repos","events_url":"https://api.github.com/users/CenterForOpenScience/events{/privacy}","received_events_url":"https://api.github.com/users/CenterForOpenScience/received_events","type":"Organization","site_admin":false},"repo":{"id":10199599,"name":"osf.io","full_name":"CenterForOpenScience/osf.io","owner":{"login":"CenterForOpenScience","id":3344584,"avatar_url":"https://avatars2.githubusercontent.com/u/3344584?v=3","gravatar_id":"","url":"https://api.github.com/users/CenterForOpenScience","html_url":"https://github.com/CenterForOpenScience","followers_url":"https://api.github.com/users/CenterForOpenScience/followers","following_url":"https://api.github.com/users/CenterForOpenScience/following{/other_user}","gists_url":"https://api.github.com/users/CenterForOpenScience/gists{/gist_id}","starred_url":"https://api.github.com/users/CenterForOpenScience/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CenterForOpenScience/subscriptions","organizations_url":"https://api.github.com/users/CenterForOpenScience/orgs","repos_url":"https://api.github.com/users/CenterForOpenScience/repos","events_url":"https://api.github.com/users/CenterForOpenScience/events{/privacy}","received_events_url":"https://api.github.com/users/CenterForOpenScience/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/CenterForOpenScience/osf.io","description":"Facilitating Open Science","fork":false,"url":"https://api.github.com/repos/CenterForOpenScience/osf.io","forks_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/forks","keys_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/keys{/key_id}","collaborators_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/teams","hooks_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/hooks","issue_events_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/issues/events{/number}","events_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/events","assignees_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/assignees{/user}","branches_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/branches{/branch}","tags_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/tags","blobs_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/git/refs{/sha}","trees_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/git/trees{/sha}","statuses_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/statuses/{sha}","languages_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/languages","stargazers_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/stargazers","contributors_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/contributors","subscribers_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/subscribers","subscription_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/subscription","commits_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/commits{/sha}","git_commits_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/git/commits{/sha}","comments_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/comments{/number}","issue_comment_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/issues/comments{/number}","contents_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/contents/{+path}","compare_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/compare/{base}...{head}","merges_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/merges","archive_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/downloads","issues_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/issues{/number}","pulls_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls{/number}","milestones_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/milestones{/number}","notifications_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/labels{/name}","releases_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/releases{/id}","deployments_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/deployments","created_at":"2013-05-21T15:53:37Z","updated_at":"2017-03-06T22:20:32Z","pushed_at":"2017-03-09T23:38:17Z","git_url":"git://github.com/CenterForOpenScience/osf.io.git","ssh_url":"git@github.com:CenterForOpenScience/osf.io.git","clone_url":"https://github.com/CenterForOpenScience/osf.io.git","svn_url":"https://github.com/CenterForOpenScience/osf.io","homepage":"https://osf.io","size":149895,"stargazers_count":305,"watchers_count":305,"language":"Python","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":214,"mirror_url":null,"open_issues_count":228,"forks":214,"open_issues":228,"watchers":305,"default_branch":"develop"}},"_links":{"self":{"href":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/6953"},"html":{"href":"https://github.com/CenterForOpenScience/osf.io/pull/6953"},"issue":{"href":"https://api.github.com/repos/CenterForOpenScience/osf.io/issues/6953"},"comments":{"href":"https://api.github.com/repos/CenterForOpenScience/osf.io/issues/6953/comments"},"review_comments":{"href":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/6953/comments"},"review_comment":{"href":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/6953/commits"},"statuses":{"href":"https://api.github.com/repos/CenterForOpenScience/osf.io/statuses/87fd43e0cf4ef676fbc9177815e2b2fb6cae45ac"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"login":"icereval","id":3111541,"avatar_url":"https://avatars3.githubusercontent.com/u/3111541?v=3","gravatar_id":"","url":"https://api.github.com/users/icereval","html_url":"https://github.com/icereval","followers_url":"https://api.github.com/users/icereval/followers","following_url":"https://api.github.com/users/icereval/following{/other_user}","gists_url":"https://api.github.com/users/icereval/gists{/gist_id}","starred_url":"https://api.github.com/users/icereval/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/icereval/subscriptions","organizations_url":"https://api.github.com/users/icereval/orgs","repos_url":"https://api.github.com/users/icereval/repos","events_url":"https://api.github.com/users/icereval/events{/privacy}","received_events_url":"https://api.github.com/users/icereval/received_events","type":"User","site_admin":false},"comments":1,"review_comments":8,"maintainer_can_modify":false,"commits":4,"additions":39,"deletions":18,"changed_files":2}}
{"actor":{"display_login":"icereval"}}