{"action":"created","comment":{"url":"https://api.github.com/repos/uclouvain/osis/pulls/comments/212211423","pull_request_review_id":148792237,"id":212211423,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIxMjIxMTQyMw==","diff_hunk":"@@ -455,11 +456,17 @@ def children_group_element_years(self):\n \n     @cached_property\n     def group_element_year_branches(self):\n-        return self.groupelementyear_set.filter(child_branch__isnull=False)\n+        return self.groupelementyear_set.filter(child_branch__isnull=False).select_related(\"child_branch\")\n \n     @cached_property\n     def group_element_year_leaves(self):\n-        return self.groupelementyear_set.filter(child_leaf__isnull=False)\n+        return self.groupelementyear_set.filter(child_leaf__isnull=False).\\\n+            select_related(\"child_leaf\", \"child_leaf__learning_container_year\")\n+\n+    def group_element_year_leaves_with_annotate_on_prerequisites(self, root_id):\n+        has_prerequisite = Prerequisite.objects.filter(education_group_year__id=root_id,\n+                                                       learning_unit_year__id=OuterRef(\"child_leaf__id\"))\n+        return self.group_element_year_leaves.annotate(has_prerequisites=Exists(has_prerequisite))","path":"base/models/education_group_year.py","position":33,"original_position":33,"commit_id":"d251fe717871ebbeec02a2604a127d8ea13c1fca","original_commit_id":"d251fe717871ebbeec02a2604a127d8ea13c1fca","user":{"login":"albrugnetti","id":19836473,"node_id":"MDQ6VXNlcjE5ODM2NDcz","avatar_url":"https://avatars3.githubusercontent.com/u/19836473?v=4","gravatar_id":"","url":"https://api.github.com/users/albrugnetti","html_url":"https://github.com/albrugnetti","followers_url":"https://api.github.com/users/albrugnetti/followers","following_url":"https://api.github.com/users/albrugnetti/following{/other_user}","gists_url":"https://api.github.com/users/albrugnetti/gists{/gist_id}","starred_url":"https://api.github.com/users/albrugnetti/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/albrugnetti/subscriptions","organizations_url":"https://api.github.com/users/albrugnetti/orgs","repos_url":"https://api.github.com/users/albrugnetti/repos","events_url":"https://api.github.com/users/albrugnetti/events{/privacy}","received_events_url":"https://api.github.com/users/albrugnetti/received_events","type":"User","site_admin":false},"body":"+1","created_at":"2018-08-23T07:45:35Z","updated_at":"2018-08-23T07:45:35Z","html_url":"https://github.com/uclouvain/osis/pull/4144#discussion_r212211423","pull_request_url":"https://api.github.com/repos/uclouvain/osis/pulls/4144","author_association":"COLLABORATOR","_links":{"self":{"href":"https://api.github.com/repos/uclouvain/osis/pulls/comments/212211423"},"html":{"href":"https://github.com/uclouvain/osis/pull/4144#discussion_r212211423"},"pull_request":{"href":"https://api.github.com/repos/uclouvain/osis/pulls/4144"}}},"pull_request":{"url":"https://api.github.com/repos/uclouvain/osis/pulls/4144","id":210138836,"node_id":"MDExOlB1bGxSZXF1ZXN0MjEwMTM4ODM2","html_url":"https://github.com/uclouvain/osis/pull/4144","diff_url":"https://github.com/uclouvain/osis/pull/4144.diff","patch_url":"https://github.com/uclouvain/osis/pull/4144.patch","issue_url":"https://api.github.com/repos/uclouvain/osis/issues/4144","number":4144,"state":"open","locked":false,"title":"Osis 1689","user":{"login":"edd19","id":7523653,"node_id":"MDQ6VXNlcjc1MjM2NTM=","avatar_url":"https://avatars0.githubusercontent.com/u/7523653?v=4","gravatar_id":"","url":"https://api.github.com/users/edd19","html_url":"https://github.com/edd19","followers_url":"https://api.github.com/users/edd19/followers","following_url":"https://api.github.com/users/edd19/following{/other_user}","gists_url":"https://api.github.com/users/edd19/gists{/gist_id}","starred_url":"https://api.github.com/users/edd19/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edd19/subscriptions","organizations_url":"https://api.github.com/users/edd19/orgs","repos_url":"https://api.github.com/users/edd19/repos","events_url":"https://api.github.com/users/edd19/events{/privacy}","received_events_url":"https://api.github.com/users/edd19/received_events","type":"User","site_admin":false},"body":"Référence Jira : OSIS-1689\r\n\r\nVérifier les points suivants : \r\n- [x] Ouvrir une release task Jira si le ticket génère une tâche pour la release : \r\n    - modification de configuration\r\n    - table à synchroniser en entier, etc.\r\n- [x] Uniformiser les modèles osis-portal avec les changements effectués dans osis si nécessaire\r\n- [x] Permissions et droits d’accès mettre à jour la documentation si : \r\n    - on rajoute/modifie une permission\r\n    - on rajoute/modifie un groupe d’utilisateurs, etc.\r\n","created_at":"2018-08-22T13:44:55Z","updated_at":"2018-08-23T07:45:35Z","closed_at":null,"merged_at":null,"merge_commit_sha":"61f900b67468f30cd24c95ac9a2ad2fee0c0cd55","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/uclouvain/osis/pulls/4144/commits","review_comments_url":"https://api.github.com/repos/uclouvain/osis/pulls/4144/comments","review_comment_url":"https://api.github.com/repos/uclouvain/osis/pulls/comments{/number}","comments_url":"https://api.github.com/repos/uclouvain/osis/issues/4144/comments","statuses_url":"https://api.github.com/repos/uclouvain/osis/statuses/d251fe717871ebbeec02a2604a127d8ea13c1fca","head":{"label":"uclouvain:OSIS-1689","ref":"OSIS-1689","sha":"d251fe717871ebbeec02a2604a127d8ea13c1fca","user":{"login":"uclouvain","id":9862060,"node_id":"MDEyOk9yZ2FuaXphdGlvbjk4NjIwNjA=","avatar_url":"https://avatars0.githubusercontent.com/u/9862060?v=4","gravatar_id":"","url":"https://api.github.com/users/uclouvain","html_url":"https://github.com/uclouvain","followers_url":"https://api.github.com/users/uclouvain/followers","following_url":"https://api.github.com/users/uclouvain/following{/other_user}","gists_url":"https://api.github.com/users/uclouvain/gists{/gist_id}","starred_url":"https://api.github.com/users/uclouvain/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/uclouvain/subscriptions","organizations_url":"https://api.github.com/users/uclouvain/orgs","repos_url":"https://api.github.com/users/uclouvain/repos","events_url":"https://api.github.com/users/uclouvain/events{/privacy}","received_events_url":"https://api.github.com/users/uclouvain/received_events","type":"Organization","site_admin":false},"repo":{"id":37489388,"node_id":"MDEwOlJlcG9zaXRvcnkzNzQ4OTM4OA==","name":"osis","full_name":"uclouvain/osis","owner":{"login":"uclouvain","id":9862060,"node_id":"MDEyOk9yZ2FuaXphdGlvbjk4NjIwNjA=","avatar_url":"https://avatars0.githubusercontent.com/u/9862060?v=4","gravatar_id":"","url":"https://api.github.com/users/uclouvain","html_url":"https://github.com/uclouvain","followers_url":"https://api.github.com/users/uclouvain/followers","following_url":"https://api.github.com/users/uclouvain/following{/other_user}","gists_url":"https://api.github.com/users/uclouvain/gists{/gist_id}","starred_url":"https://api.github.com/users/uclouvain/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/uclouvain/subscriptions","organizations_url":"https://api.github.com/users/uclouvain/orgs","repos_url":"https://api.github.com/users/uclouvain/repos","events_url":"https://api.github.com/users/uclouvain/events{/privacy}","received_events_url":"https://api.github.com/users/uclouvain/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/uclouvain/osis","description":"Open Student Information System Backoffice","fork":false,"url":"https://api.github.com/repos/uclouvain/osis","forks_url":"https://api.github.com/repos/uclouvain/osis/forks","keys_url":"https://api.github.com/repos/uclouvain/osis/keys{/key_id}","collaborators_url":"https://api.github.com/repos/uclouvain/osis/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/uclouvain/osis/teams","hooks_url":"https://api.github.com/repos/uclouvain/osis/hooks","issue_events_url":"https://api.github.com/repos/uclouvain/osis/issues/events{/number}","events_url":"https://api.github.com/repos/uclouvain/osis/events","assignees_url":"https://api.github.com/repos/uclouvain/osis/assignees{/user}","branches_url":"https://api.github.com/repos/uclouvain/osis/branches{/branch}","tags_url":"https://api.github.com/repos/uclouvain/osis/tags","blobs_url":"https://api.github.com/repos/uclouvain/osis/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/uclouvain/osis/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/uclouvain/osis/git/refs{/sha}","trees_url":"https://api.github.com/repos/uclouvain/osis/git/trees{/sha}","statuses_url":"https://api.github.com/repos/uclouvain/osis/statuses/{sha}","languages_url":"https://api.github.com/repos/uclouvain/osis/languages","stargazers_url":"https://api.github.com/repos/uclouvain/osis/stargazers","contributors_url":"https://api.github.com/repos/uclouvain/osis/contributors","subscribers_url":"https://api.github.com/repos/uclouvain/osis/subscribers","subscription_url":"https://api.github.com/repos/uclouvain/osis/subscription","commits_url":"https://api.github.com/repos/uclouvain/osis/commits{/sha}","git_commits_url":"https://api.github.com/repos/uclouvain/osis/git/commits{/sha}","comments_url":"https://api.github.com/repos/uclouvain/osis/comments{/number}","issue_comment_url":"https://api.github.com/repos/uclouvain/osis/issues/comments{/number}","contents_url":"https://api.github.com/repos/uclouvain/osis/contents/{+path}","compare_url":"https://api.github.com/repos/uclouvain/osis/compare/{base}...{head}","merges_url":"https://api.github.com/repos/uclouvain/osis/merges","archive_url":"https://api.github.com/repos/uclouvain/osis/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/uclouvain/osis/downloads","issues_url":"https://api.github.com/repos/uclouvain/osis/issues{/number}","pulls_url":"https://api.github.com/repos/uclouvain/osis/pulls{/number}","milestones_url":"https://api.github.com/repos/uclouvain/osis/milestones{/number}","notifications_url":"https://api.github.com/repos/uclouvain/osis/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/uclouvain/osis/labels{/name}","releases_url":"https://api.github.com/repos/uclouvain/osis/releases{/id}","deployments_url":"https://api.github.com/repos/uclouvain/osis/deployments","created_at":"2015-06-15T20:25:28Z","updated_at":"2018-08-23T07:36:14Z","pushed_at":"2018-08-23T07:36:26Z","git_url":"git://github.com/uclouvain/osis.git","ssh_url":"git@github.com:uclouvain/osis.git","clone_url":"https://github.com/uclouvain/osis.git","svn_url":"https://github.com/uclouvain/osis","homepage":"http://uclouvain.github.io/osis","size":67647,"stargazers_count":37,"watchers_count":37,"language":"Python","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":true,"forks_count":15,"mirror_url":null,"archived":false,"open_issues_count":17,"license":{"key":"agpl-3.0","name":"GNU Affero General Public License v3.0","spdx_id":"AGPL-3.0","url":"https://api.github.com/licenses/agpl-3.0","node_id":"MDc6TGljZW5zZTE="},"forks":15,"open_issues":17,"watchers":37,"default_branch":"dev"}},"base":{"label":"uclouvain:dev","ref":"dev","sha":"fa9b55e81c2ac4c9334b8f5814e280a18e9d67d8","user":{"login":"uclouvain","id":9862060,"node_id":"MDEyOk9yZ2FuaXphdGlvbjk4NjIwNjA=","avatar_url":"https://avatars0.githubusercontent.com/u/9862060?v=4","gravatar_id":"","url":"https://api.github.com/users/uclouvain","html_url":"https://github.com/uclouvain","followers_url":"https://api.github.com/users/uclouvain/followers","following_url":"https://api.github.com/users/uclouvain/following{/other_user}","gists_url":"https://api.github.com/users/uclouvain/gists{/gist_id}","starred_url":"https://api.github.com/users/uclouvain/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/uclouvain/subscriptions","organizations_url":"https://api.github.com/users/uclouvain/orgs","repos_url":"https://api.github.com/users/uclouvain/repos","events_url":"https://api.github.com/users/uclouvain/events{/privacy}","received_events_url":"https://api.github.com/users/uclouvain/received_events","type":"Organization","site_admin":false},"repo":{"id":37489388,"node_id":"MDEwOlJlcG9zaXRvcnkzNzQ4OTM4OA==","name":"osis","full_name":"uclouvain/osis","owner":{"login":"uclouvain","id":9862060,"node_id":"MDEyOk9yZ2FuaXphdGlvbjk4NjIwNjA=","avatar_url":"https://avatars0.githubusercontent.com/u/9862060?v=4","gravatar_id":"","url":"https://api.github.com/users/uclouvain","html_url":"https://github.com/uclouvain","followers_url":"https://api.github.com/users/uclouvain/followers","following_url":"https://api.github.com/users/uclouvain/following{/other_user}","gists_url":"https://api.github.com/users/uclouvain/gists{/gist_id}","starred_url":"https://api.github.com/users/uclouvain/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/uclouvain/subscriptions","organizations_url":"https://api.github.com/users/uclouvain/orgs","repos_url":"https://api.github.com/users/uclouvain/repos","events_url":"https://api.github.com/users/uclouvain/events{/privacy}","received_events_url":"https://api.github.com/users/uclouvain/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/uclouvain/osis","description":"Open Student Information System Backoffice","fork":false,"url":"https://api.github.com/repos/uclouvain/osis","forks_url":"https://api.github.com/repos/uclouvain/osis/forks","keys_url":"https://api.github.com/repos/uclouvain/osis/keys{/key_id}","collaborators_url":"https://api.github.com/repos/uclouvain/osis/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/uclouvain/osis/teams","hooks_url":"https://api.github.com/repos/uclouvain/osis/hooks","issue_events_url":"https://api.github.com/repos/uclouvain/osis/issues/events{/number}","events_url":"https://api.github.com/repos/uclouvain/osis/events","assignees_url":"https://api.github.com/repos/uclouvain/osis/assignees{/user}","branches_url":"https://api.github.com/repos/uclouvain/osis/branches{/branch}","tags_url":"https://api.github.com/repos/uclouvain/osis/tags","blobs_url":"https://api.github.com/repos/uclouvain/osis/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/uclouvain/osis/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/uclouvain/osis/git/refs{/sha}","trees_url":"https://api.github.com/repos/uclouvain/osis/git/trees{/sha}","statuses_url":"https://api.github.com/repos/uclouvain/osis/statuses/{sha}","languages_url":"https://api.github.com/repos/uclouvain/osis/languages","stargazers_url":"https://api.github.com/repos/uclouvain/osis/stargazers","contributors_url":"https://api.github.com/repos/uclouvain/osis/contributors","subscribers_url":"https://api.github.com/repos/uclouvain/osis/subscribers","subscription_url":"https://api.github.com/repos/uclouvain/osis/subscription","commits_url":"https://api.github.com/repos/uclouvain/osis/commits{/sha}","git_commits_url":"https://api.github.com/repos/uclouvain/osis/git/commits{/sha}","comments_url":"https://api.github.com/repos/uclouvain/osis/comments{/number}","issue_comment_url":"https://api.github.com/repos/uclouvain/osis/issues/comments{/number}","contents_url":"https://api.github.com/repos/uclouvain/osis/contents/{+path}","compare_url":"https://api.github.com/repos/uclouvain/osis/compare/{base}...{head}","merges_url":"https://api.github.com/repos/uclouvain/osis/merges","archive_url":"https://api.github.com/repos/uclouvain/osis/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/uclouvain/osis/downloads","issues_url":"https://api.github.com/repos/uclouvain/osis/issues{/number}","pulls_url":"https://api.github.com/repos/uclouvain/osis/pulls{/number}","milestones_url":"https://api.github.com/repos/uclouvain/osis/milestones{/number}","notifications_url":"https://api.github.com/repos/uclouvain/osis/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/uclouvain/osis/labels{/name}","releases_url":"https://api.github.com/repos/uclouvain/osis/releases{/id}","deployments_url":"https://api.github.com/repos/uclouvain/osis/deployments","created_at":"2015-06-15T20:25:28Z","updated_at":"2018-08-23T07:36:14Z","pushed_at":"2018-08-23T07:36:26Z","git_url":"git://github.com/uclouvain/osis.git","ssh_url":"git@github.com:uclouvain/osis.git","clone_url":"https://github.com/uclouvain/osis.git","svn_url":"https://github.com/uclouvain/osis","homepage":"http://uclouvain.github.io/osis","size":67647,"stargazers_count":37,"watchers_count":37,"language":"Python","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":true,"forks_count":15,"mirror_url":null,"archived":false,"open_issues_count":17,"license":{"key":"agpl-3.0","name":"GNU Affero General Public License v3.0","spdx_id":"AGPL-3.0","url":"https://api.github.com/licenses/agpl-3.0","node_id":"MDc6TGljZW5zZTE="},"forks":15,"open_issues":17,"watchers":37,"default_branch":"dev"}},"_links":{"self":{"href":"https://api.github.com/repos/uclouvain/osis/pulls/4144"},"html":{"href":"https://github.com/uclouvain/osis/pull/4144"},"issue":{"href":"https://api.github.com/repos/uclouvain/osis/issues/4144"},"comments":{"href":"https://api.github.com/repos/uclouvain/osis/issues/4144/comments"},"review_comments":{"href":"https://api.github.com/repos/uclouvain/osis/pulls/4144/comments"},"review_comment":{"href":"https://api.github.com/repos/uclouvain/osis/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/uclouvain/osis/pulls/4144/commits"},"statuses":{"href":"https://api.github.com/repos/uclouvain/osis/statuses/d251fe717871ebbeec02a2604a127d8ea13c1fca"}},"author_association":"COLLABORATOR"}}
{"actor":{"display_login":"albrugnetti"}}