{"action":"created","issue":{"url":"https://api.github.com/repos/pypa/warehouse/issues/2213","repository_url":"https://api.github.com/repos/pypa/warehouse","labels_url":"https://api.github.com/repos/pypa/warehouse/issues/2213/labels{/name}","comments_url":"https://api.github.com/repos/pypa/warehouse/issues/2213/comments","events_url":"https://api.github.com/repos/pypa/warehouse/issues/2213/events","html_url":"https://github.com/pypa/warehouse/pull/2213","id":244269468,"number":2213,"title":"Sorting projects on user pages by creation date","user":{"login":"mahmoud","id":130193,"avatar_url":"https://avatars0.githubusercontent.com/u/130193?v=4","gravatar_id":"","url":"https://api.github.com/users/mahmoud","html_url":"https://github.com/mahmoud","followers_url":"https://api.github.com/users/mahmoud/followers","following_url":"https://api.github.com/users/mahmoud/following{/other_user}","gists_url":"https://api.github.com/users/mahmoud/gists{/gist_id}","starred_url":"https://api.github.com/users/mahmoud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mahmoud/subscriptions","organizations_url":"https://api.github.com/users/mahmoud/orgs","repos_url":"https://api.github.com/users/mahmoud/repos","events_url":"https://api.github.com/users/mahmoud/events{/privacy}","received_events_url":"https://api.github.com/users/mahmoud/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2017-07-20T07:29:02Z","updated_at":"2017-11-30T04:57:25Z","closed_at":null,"author_association":"NONE","pull_request":{"url":"https://api.github.com/repos/pypa/warehouse/pulls/2213","html_url":"https://github.com/pypa/warehouse/pull/2213","diff_url":"https://github.com/pypa/warehouse/pull/2213.diff","patch_url":"https://github.com/pypa/warehouse/pull/2213.patch"},"body":"Per #2206, this one-line change sorts projects on a user's page by time of last release. Works in the compose locally, all tests passing, as expected.\r\n\r\nCouple of notes on implementation: I took the approach of doing a simple `.sort()` on the distributions because we're already fetching all the records anyways, and postgres's `ORDER BY` requires the first field to equal that of the `DISTINCT` clause when it's present ([docs](https://www.postgresql.org/docs/9.1/static/sql-select.html#SQL-DISTINCT)). I don't think it'll be a big deal, and I'd rather not complicate the query, just to do the sort on the db.\r\n\r\nHope this works for you!"},"comment":{"url":"https://api.github.com/repos/pypa/warehouse/issues/comments/348082735","html_url":"https://github.com/pypa/warehouse/pull/2213#issuecomment-348082735","issue_url":"https://api.github.com/repos/pypa/warehouse/issues/2213","id":348082735,"user":{"login":"brainwane","id":842790,"avatar_url":"https://avatars0.githubusercontent.com/u/842790?v=4","gravatar_id":"","url":"https://api.github.com/users/brainwane","html_url":"https://github.com/brainwane","followers_url":"https://api.github.com/users/brainwane/followers","following_url":"https://api.github.com/users/brainwane/following{/other_user}","gists_url":"https://api.github.com/users/brainwane/gists{/gist_id}","starred_url":"https://api.github.com/users/brainwane/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/brainwane/subscriptions","organizations_url":"https://api.github.com/users/brainwane/orgs","repos_url":"https://api.github.com/users/brainwane/repos","events_url":"https://api.github.com/users/brainwane/events{/privacy}","received_events_url":"https://api.github.com/users/brainwane/received_events","type":"User","site_admin":false},"created_at":"2017-11-30T04:57:25Z","updated_at":"2017-11-30T04:57:25Z","author_association":"COLLABORATOR","body":"Thanks for your pull request, @mahmoud!\r\n\r\nThe folks working on Warehouse have just gotten [funding to concentrate on improving and deploying Warehouse](https://pyfound.blogspot.com/2017/11/the-psf-awarded-moss-grant-pypi.html), and will in December kick off work towards [the first milestone: redirecting pypi.python.org to pypi.org](https://github.com/pypa/warehouse/milestone/1). So if you have time to revise this PR, then after that kickoff we'll be pretty responsive with feedback."}}
{"actor":{"display_login":"brainwane"}}