{"action":"created","comment":{"url":"https://api.github.com/repos/fossasia/open-event-server/pulls/comments/194252607","pull_request_review_id":127392342,"id":194252607,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDE5NDI1MjYwNw==","diff_hunk":"@@ -0,0 +1,30 @@\n+\"\"\"empty message\n+\n+Revision ID: 1471fe0d04ee\n+Revises: 49f3a33f5437\n+Create Date: 2018-06-08 19:32:47.485543\n+\n+\"\"\"\n+\n+from alembic import op\n+import sqlalchemy as sa\n+import sqlalchemy_utils\n+\n+\n+# revision identifiers, used by Alembic.\n+revision = '1471fe0d04ee'\n+down_revision = '49f3a33f5437'\n+\n+\n+def upgrade():\n+    # ### commands auto generated by Alembic - please adjust! ###\n+    op.add_column('events', sa.Column('average_rating', sa.Float(), nullable=True))\n+    op.add_column('events_version', sa.Column('average_rating', sa.Float(), autoincrement=False, nullable=True))\n+    # ### end Alembic commands ###\n+\n+\n+def downgrade():\n+    # ### commands auto generated by Alembic - please adjust! ###\n+    op.drop_column('events_version', 'average_rating')\n+    op.drop_column('events', 'average_rating')\n+    # ### end Alembic commands ###","path":"migrations/versions/1471fe0d04ee_.py","position":30,"original_position":30,"commit_id":"75c3024b6a7da07dc6b9e18dbb14a9c9fe9009b7","original_commit_id":"35ddb98812262827793eb62db837c21a1d598afd","user":{"login":"schedutron","id":22810216,"node_id":"MDQ6VXNlcjIyODEwMjE2","avatar_url":"https://avatars1.githubusercontent.com/u/22810216?v=4","gravatar_id":"","url":"https://api.github.com/users/schedutron","html_url":"https://github.com/schedutron","followers_url":"https://api.github.com/users/schedutron/followers","following_url":"https://api.github.com/users/schedutron/following{/other_user}","gists_url":"https://api.github.com/users/schedutron/gists{/gist_id}","starred_url":"https://api.github.com/users/schedutron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/schedutron/subscriptions","organizations_url":"https://api.github.com/users/schedutron/orgs","repos_url":"https://api.github.com/users/schedutron/repos","events_url":"https://api.github.com/users/schedutron/events{/privacy}","received_events_url":"https://api.github.com/users/schedutron/received_events","type":"User","site_admin":false},"body":"@iamareebjamal Cool, got it. I'll now remove the field and try to compute the aggregate for every request. I'll search, but do you know of another attribute on the server which is evaluated this way? So that I can write code in the same way?","created_at":"2018-06-10T10:35:53Z","updated_at":"2018-06-10T10:35:53Z","html_url":"https://github.com/fossasia/open-event-server/pull/4865#discussion_r194252607","pull_request_url":"https://api.github.com/repos/fossasia/open-event-server/pulls/4865","author_association":"MEMBER","_links":{"self":{"href":"https://api.github.com/repos/fossasia/open-event-server/pulls/comments/194252607"},"html":{"href":"https://github.com/fossasia/open-event-server/pull/4865#discussion_r194252607"},"pull_request":{"href":"https://api.github.com/repos/fossasia/open-event-server/pulls/4865"}},"in_reply_to_id":194161310},"pull_request":{"url":"https://api.github.com/repos/fossasia/open-event-server/pulls/4865","id":193625632,"node_id":"MDExOlB1bGxSZXF1ZXN0MTkzNjI1NjMy","html_url":"https://github.com/fossasia/open-event-server/pull/4865","diff_url":"https://github.com/fossasia/open-event-server/pull/4865.diff","patch_url":"https://github.com/fossasia/open-event-server/pull/4865.patch","issue_url":"https://api.github.com/repos/fossasia/open-event-server/issues/4865","number":4865,"state":"open","locked":false,"title":"WIP: Implement Average Rating for Events","user":{"login":"schedutron","id":22810216,"node_id":"MDQ6VXNlcjIyODEwMjE2","avatar_url":"https://avatars1.githubusercontent.com/u/22810216?v=4","gravatar_id":"","url":"https://api.github.com/users/schedutron","html_url":"https://github.com/schedutron","followers_url":"https://api.github.com/users/schedutron/followers","following_url":"https://api.github.com/users/schedutron/following{/other_user}","gists_url":"https://api.github.com/users/schedutron/gists{/gist_id}","starred_url":"https://api.github.com/users/schedutron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/schedutron/subscriptions","organizations_url":"https://api.github.com/users/schedutron/orgs","repos_url":"https://api.github.com/users/schedutron/repos","events_url":"https://api.github.com/users/schedutron/events{/privacy}","received_events_url":"https://api.github.com/users/schedutron/received_events","type":"User","site_admin":false},"body":"Fixes #4808\r\n\r\n#### Checklist\r\n\r\n- [x] I have read the [Contribution & Best practices Guide](https://blog.fossasia.org/open-source-developer-guide-and-best-practices-at-fossasia) and my PR follows them.\r\n- [x] My branch is up-to-date with the Upstream `development` branch.\r\n- [ ] The unit tests pass locally with my changes <!-- use `nosetests tests/unittests` to run all the tests -->\r\n- [ ] I have added tests that prove my fix is effective or that my feature works\r\n- [ ] I have added necessary documentation (if appropriate)\r\n<!-- If an existing function does not have a docstring, please add one -->\r\n- [ ] All the functions created/modified in this PR contain relevant docstrings.\r\n\r\n#### Short description of what this resolves:\r\nThis PR implements average ratings for events","created_at":"2018-06-08T14:09:11Z","updated_at":"2018-06-10T10:35:53Z","closed_at":null,"merged_at":null,"merge_commit_sha":"1d1e14e0d3cb0544574d8b04bf9a950f3ff0dea2","assignee":{"login":"schedutron","id":22810216,"node_id":"MDQ6VXNlcjIyODEwMjE2","avatar_url":"https://avatars1.githubusercontent.com/u/22810216?v=4","gravatar_id":"","url":"https://api.github.com/users/schedutron","html_url":"https://github.com/schedutron","followers_url":"https://api.github.com/users/schedutron/followers","following_url":"https://api.github.com/users/schedutron/following{/other_user}","gists_url":"https://api.github.com/users/schedutron/gists{/gist_id}","starred_url":"https://api.github.com/users/schedutron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/schedutron/subscriptions","organizations_url":"https://api.github.com/users/schedutron/orgs","repos_url":"https://api.github.com/users/schedutron/repos","events_url":"https://api.github.com/users/schedutron/events{/privacy}","received_events_url":"https://api.github.com/users/schedutron/received_events","type":"User","site_admin":false},"assignees":[{"login":"schedutron","id":22810216,"node_id":"MDQ6VXNlcjIyODEwMjE2","avatar_url":"https://avatars1.githubusercontent.com/u/22810216?v=4","gravatar_id":"","url":"https://api.github.com/users/schedutron","html_url":"https://github.com/schedutron","followers_url":"https://api.github.com/users/schedutron/followers","following_url":"https://api.github.com/users/schedutron/following{/other_user}","gists_url":"https://api.github.com/users/schedutron/gists{/gist_id}","starred_url":"https://api.github.com/users/schedutron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/schedutron/subscriptions","organizations_url":"https://api.github.com/users/schedutron/orgs","repos_url":"https://api.github.com/users/schedutron/repos","events_url":"https://api.github.com/users/schedutron/events{/privacy}","received_events_url":"https://api.github.com/users/schedutron/received_events","type":"User","site_admin":false}],"requested_reviewers":[],"requested_teams":[],"labels":[{"id":634334822,"node_id":"MDU6TGFiZWw2MzQzMzQ4MjI=","url":"https://api.github.com/repos/fossasia/open-event-server/labels/needs-review","name":"needs-review","color":"fef2c0","default":false}],"milestone":null,"commits_url":"https://api.github.com/repos/fossasia/open-event-server/pulls/4865/commits","review_comments_url":"https://api.github.com/repos/fossasia/open-event-server/pulls/4865/comments","review_comment_url":"https://api.github.com/repos/fossasia/open-event-server/pulls/comments{/number}","comments_url":"https://api.github.com/repos/fossasia/open-event-server/issues/4865/comments","statuses_url":"https://api.github.com/repos/fossasia/open-event-server/statuses/75c3024b6a7da07dc6b9e18dbb14a9c9fe9009b7","head":{"label":"schedutron:average","ref":"average","sha":"75c3024b6a7da07dc6b9e18dbb14a9c9fe9009b7","user":{"login":"schedutron","id":22810216,"node_id":"MDQ6VXNlcjIyODEwMjE2","avatar_url":"https://avatars1.githubusercontent.com/u/22810216?v=4","gravatar_id":"","url":"https://api.github.com/users/schedutron","html_url":"https://github.com/schedutron","followers_url":"https://api.github.com/users/schedutron/followers","following_url":"https://api.github.com/users/schedutron/following{/other_user}","gists_url":"https://api.github.com/users/schedutron/gists{/gist_id}","starred_url":"https://api.github.com/users/schedutron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/schedutron/subscriptions","organizations_url":"https://api.github.com/users/schedutron/orgs","repos_url":"https://api.github.com/users/schedutron/repos","events_url":"https://api.github.com/users/schedutron/events{/privacy}","received_events_url":"https://api.github.com/users/schedutron/received_events","type":"User","site_admin":false},"repo":{"id":131246426,"node_id":"MDEwOlJlcG9zaXRvcnkxMzEyNDY0MjY=","name":"open-event-server","full_name":"schedutron/open-event-server","owner":{"login":"schedutron","id":22810216,"node_id":"MDQ6VXNlcjIyODEwMjE2","avatar_url":"https://avatars1.githubusercontent.com/u/22810216?v=4","gravatar_id":"","url":"https://api.github.com/users/schedutron","html_url":"https://github.com/schedutron","followers_url":"https://api.github.com/users/schedutron/followers","following_url":"https://api.github.com/users/schedutron/following{/other_user}","gists_url":"https://api.github.com/users/schedutron/gists{/gist_id}","starred_url":"https://api.github.com/users/schedutron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/schedutron/subscriptions","organizations_url":"https://api.github.com/users/schedutron/orgs","repos_url":"https://api.github.com/users/schedutron/repos","events_url":"https://api.github.com/users/schedutron/events{/privacy}","received_events_url":"https://api.github.com/users/schedutron/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/schedutron/open-event-server","description":"The Open Event Organizer Server to Manage Events","fork":true,"url":"https://api.github.com/repos/schedutron/open-event-server","forks_url":"https://api.github.com/repos/schedutron/open-event-server/forks","keys_url":"https://api.github.com/repos/schedutron/open-event-server/keys{/key_id}","collaborators_url":"https://api.github.com/repos/schedutron/open-event-server/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/schedutron/open-event-server/teams","hooks_url":"https://api.github.com/repos/schedutron/open-event-server/hooks","issue_events_url":"https://api.github.com/repos/schedutron/open-event-server/issues/events{/number}","events_url":"https://api.github.com/repos/schedutron/open-event-server/events","assignees_url":"https://api.github.com/repos/schedutron/open-event-server/assignees{/user}","branches_url":"https://api.github.com/repos/schedutron/open-event-server/branches{/branch}","tags_url":"https://api.github.com/repos/schedutron/open-event-server/tags","blobs_url":"https://api.github.com/repos/schedutron/open-event-server/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/schedutron/open-event-server/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/schedutron/open-event-server/git/refs{/sha}","trees_url":"https://api.github.com/repos/schedutron/open-event-server/git/trees{/sha}","statuses_url":"https://api.github.com/repos/schedutron/open-event-server/statuses/{sha}","languages_url":"https://api.github.com/repos/schedutron/open-event-server/languages","stargazers_url":"https://api.github.com/repos/schedutron/open-event-server/stargazers","contributors_url":"https://api.github.com/repos/schedutron/open-event-server/contributors","subscribers_url":"https://api.github.com/repos/schedutron/open-event-server/subscribers","subscription_url":"https://api.github.com/repos/schedutron/open-event-server/subscription","commits_url":"https://api.github.com/repos/schedutron/open-event-server/commits{/sha}","git_commits_url":"https://api.github.com/repos/schedutron/open-event-server/git/commits{/sha}","comments_url":"https://api.github.com/repos/schedutron/open-event-server/comments{/number}","issue_comment_url":"https://api.github.com/repos/schedutron/open-event-server/issues/comments{/number}","contents_url":"https://api.github.com/repos/schedutron/open-event-server/contents/{+path}","compare_url":"https://api.github.com/repos/schedutron/open-event-server/compare/{base}...{head}","merges_url":"https://api.github.com/repos/schedutron/open-event-server/merges","archive_url":"https://api.github.com/repos/schedutron/open-event-server/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/schedutron/open-event-server/downloads","issues_url":"https://api.github.com/repos/schedutron/open-event-server/issues{/number}","pulls_url":"https://api.github.com/repos/schedutron/open-event-server/pulls{/number}","milestones_url":"https://api.github.com/repos/schedutron/open-event-server/milestones{/number}","notifications_url":"https://api.github.com/repos/schedutron/open-event-server/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/schedutron/open-event-server/labels{/name}","releases_url":"https://api.github.com/repos/schedutron/open-event-server/releases{/id}","deployments_url":"https://api.github.com/repos/schedutron/open-event-server/deployments","created_at":"2018-04-27T04:43:01Z","updated_at":"2018-05-27T21:00:16Z","pushed_at":"2018-06-09T02:40:07Z","git_url":"git://github.com/schedutron/open-event-server.git","ssh_url":"git@github.com:schedutron/open-event-server.git","clone_url":"https://github.com/schedutron/open-event-server.git","svn_url":"https://github.com/schedutron/open-event-server","homepage":"http://open-event-api.herokuapp.com/","size":44421,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"development"}},"base":{"label":"fossasia:development","ref":"development","sha":"7cdf1c26f8ae014925174e9cd7df7ad7f452b4c4","user":{"login":"fossasia","id":6295529,"node_id":"MDEyOk9yZ2FuaXphdGlvbjYyOTU1Mjk=","avatar_url":"https://avatars3.githubusercontent.com/u/6295529?v=4","gravatar_id":"","url":"https://api.github.com/users/fossasia","html_url":"https://github.com/fossasia","followers_url":"https://api.github.com/users/fossasia/followers","following_url":"https://api.github.com/users/fossasia/following{/other_user}","gists_url":"https://api.github.com/users/fossasia/gists{/gist_id}","starred_url":"https://api.github.com/users/fossasia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fossasia/subscriptions","organizations_url":"https://api.github.com/users/fossasia/orgs","repos_url":"https://api.github.com/users/fossasia/repos","events_url":"https://api.github.com/users/fossasia/events{/privacy}","received_events_url":"https://api.github.com/users/fossasia/received_events","type":"Organization","site_admin":false},"repo":{"id":35270176,"node_id":"MDEwOlJlcG9zaXRvcnkzNTI3MDE3Ng==","name":"open-event-server","full_name":"fossasia/open-event-server","owner":{"login":"fossasia","id":6295529,"node_id":"MDEyOk9yZ2FuaXphdGlvbjYyOTU1Mjk=","avatar_url":"https://avatars3.githubusercontent.com/u/6295529?v=4","gravatar_id":"","url":"https://api.github.com/users/fossasia","html_url":"https://github.com/fossasia","followers_url":"https://api.github.com/users/fossasia/followers","following_url":"https://api.github.com/users/fossasia/following{/other_user}","gists_url":"https://api.github.com/users/fossasia/gists{/gist_id}","starred_url":"https://api.github.com/users/fossasia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fossasia/subscriptions","organizations_url":"https://api.github.com/users/fossasia/orgs","repos_url":"https://api.github.com/users/fossasia/repos","events_url":"https://api.github.com/users/fossasia/events{/privacy}","received_events_url":"https://api.github.com/users/fossasia/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/fossasia/open-event-server","description":"The Open Event Organizer Server to Manage Events","fork":false,"url":"https://api.github.com/repos/fossasia/open-event-server","forks_url":"https://api.github.com/repos/fossasia/open-event-server/forks","keys_url":"https://api.github.com/repos/fossasia/open-event-server/keys{/key_id}","collaborators_url":"https://api.github.com/repos/fossasia/open-event-server/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/fossasia/open-event-server/teams","hooks_url":"https://api.github.com/repos/fossasia/open-event-server/hooks","issue_events_url":"https://api.github.com/repos/fossasia/open-event-server/issues/events{/number}","events_url":"https://api.github.com/repos/fossasia/open-event-server/events","assignees_url":"https://api.github.com/repos/fossasia/open-event-server/assignees{/user}","branches_url":"https://api.github.com/repos/fossasia/open-event-server/branches{/branch}","tags_url":"https://api.github.com/repos/fossasia/open-event-server/tags","blobs_url":"https://api.github.com/repos/fossasia/open-event-server/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/fossasia/open-event-server/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/fossasia/open-event-server/git/refs{/sha}","trees_url":"https://api.github.com/repos/fossasia/open-event-server/git/trees{/sha}","statuses_url":"https://api.github.com/repos/fossasia/open-event-server/statuses/{sha}","languages_url":"https://api.github.com/repos/fossasia/open-event-server/languages","stargazers_url":"https://api.github.com/repos/fossasia/open-event-server/stargazers","contributors_url":"https://api.github.com/repos/fossasia/open-event-server/contributors","subscribers_url":"https://api.github.com/repos/fossasia/open-event-server/subscribers","subscription_url":"https://api.github.com/repos/fossasia/open-event-server/subscription","commits_url":"https://api.github.com/repos/fossasia/open-event-server/commits{/sha}","git_commits_url":"https://api.github.com/repos/fossasia/open-event-server/git/commits{/sha}","comments_url":"https://api.github.com/repos/fossasia/open-event-server/comments{/number}","issue_comment_url":"https://api.github.com/repos/fossasia/open-event-server/issues/comments{/number}","contents_url":"https://api.github.com/repos/fossasia/open-event-server/contents/{+path}","compare_url":"https://api.github.com/repos/fossasia/open-event-server/compare/{base}...{head}","merges_url":"https://api.github.com/repos/fossasia/open-event-server/merges","archive_url":"https://api.github.com/repos/fossasia/open-event-server/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/fossasia/open-event-server/downloads","issues_url":"https://api.github.com/repos/fossasia/open-event-server/issues{/number}","pulls_url":"https://api.github.com/repos/fossasia/open-event-server/pulls{/number}","milestones_url":"https://api.github.com/repos/fossasia/open-event-server/milestones{/number}","notifications_url":"https://api.github.com/repos/fossasia/open-event-server/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/fossasia/open-event-server/labels{/name}","releases_url":"https://api.github.com/repos/fossasia/open-event-server/releases{/id}","deployments_url":"https://api.github.com/repos/fossasia/open-event-server/deployments","created_at":"2015-05-08T09:16:19Z","updated_at":"2018-06-10T01:46:03Z","pushed_at":"2018-06-10T01:21:34Z","git_url":"git://github.com/fossasia/open-event-server.git","ssh_url":"git@github.com:fossasia/open-event-server.git","clone_url":"https://github.com/fossasia/open-event-server.git","svn_url":"https://github.com/fossasia/open-event-server","homepage":"http://open-event-api.herokuapp.com/","size":44425,"stargazers_count":1009,"watchers_count":1009,"language":"Python","has_issues":true,"has_projects":false,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":913,"mirror_url":null,"archived":false,"open_issues_count":81,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":913,"open_issues":81,"watchers":1009,"default_branch":"development"}},"_links":{"self":{"href":"https://api.github.com/repos/fossasia/open-event-server/pulls/4865"},"html":{"href":"https://github.com/fossasia/open-event-server/pull/4865"},"issue":{"href":"https://api.github.com/repos/fossasia/open-event-server/issues/4865"},"comments":{"href":"https://api.github.com/repos/fossasia/open-event-server/issues/4865/comments"},"review_comments":{"href":"https://api.github.com/repos/fossasia/open-event-server/pulls/4865/comments"},"review_comment":{"href":"https://api.github.com/repos/fossasia/open-event-server/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/fossasia/open-event-server/pulls/4865/commits"},"statuses":{"href":"https://api.github.com/repos/fossasia/open-event-server/statuses/75c3024b6a7da07dc6b9e18dbb14a9c9fe9009b7"}},"author_association":"MEMBER"}}
{"actor":{"display_login":"schedutron"}}