{"action":"opened","number":8263,"pull_request":{"url":"https://api.github.com/repos/google/ggrc-core/pulls/8263","id":207263295,"node_id":"MDExOlB1bGxSZXF1ZXN0MjA3MjYzMjk1","html_url":"https://github.com/google/ggrc-core/pull/8263","diff_url":"https://github.com/google/ggrc-core/pull/8263.diff","patch_url":"https://github.com/google/ggrc-core/pull/8263.patch","issue_url":"https://api.github.com/repos/google/ggrc-core/issues/8263","number":8263,"state":"open","locked":false,"title":"GGRC-5812 Migrate Clauses into Requirements","user":{"login":"belovmd","id":39156721,"node_id":"MDQ6VXNlcjM5MTU2NzIx","avatar_url":"https://avatars2.githubusercontent.com/u/39156721?v=4","gravatar_id":"","url":"https://api.github.com/users/belovmd","html_url":"https://github.com/belovmd","followers_url":"https://api.github.com/users/belovmd/followers","following_url":"https://api.github.com/users/belovmd/following{/other_user}","gists_url":"https://api.github.com/users/belovmd/gists{/gist_id}","starred_url":"https://api.github.com/users/belovmd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/belovmd/subscriptions","organizations_url":"https://api.github.com/users/belovmd/orgs","repos_url":"https://api.github.com/users/belovmd/repos","events_url":"https://api.github.com/users/belovmd/events{/privacy}","received_events_url":"https://api.github.com/users/belovmd/received_events","type":"User","site_admin":false},"body":"<!-- If your PR depends on other tickets or PRs, you can list them here\r\n# Dependencies\r\n\r\nThis PR is `on hold` until the dependencies are merged:\r\n\r\n- [ ] GGRC-1234\r\n- [ ] #1234\r\n-->\r\n\r\n# Issue description\r\n\r\nThis is a subtask of [GGRC-4123](https://gojira.corp.google.com/browse/GGRC-4123) ticket. \r\n\r\n\r\n# Steps to test the changes\r\n\r\nBasic test cases:\r\nTBD\r\n\r\n# Solution description\r\nThis PR migrates all Clauses and clauses related data to Requirements model. \r\nThis migrations doesn't have downgrade method, you can take a look through [tech doc](https://docs.google.com/document/d/1IuJiIn_J8n1fYFPOOQ7hyBieXMByiylLxtYup9m7ldc/edit#heading=h.51r6cryobu19)\r\nNOTES:\r\n\r\n- I haven't made global CAD titles unique cause we made request to prod and there are no identical titles there.\r\n- I've populated clauses revisions content in part of acr_role_id. After merging ACR's for Clauses and Requirements  with the same name we will brake acr for former clauses revisions. We can populate these revisions but if we will populate acr during app execution, we need to keep deleted ACR's mapping table that is not relevant data model and we need to populate it only for revisions that were created before release. \r\n\r\n# Sanity checklist\r\n\r\n- [ ] I have clicked through the app to make sure my changes work and not break the app.\r\n- [ ] I have applied the correct milestone and labels.\r\n- [ ] My changes fix the issue described in the description (and do nothing else). 🤞\r\n- [ ] My changes are covered by tests.\r\n- [ ] My changes follow our [performance guidelines](https://github.com/google/ggrc-core/blob/dev/docs/source/contributing/performance.rst).\r\n- [ ] My changes follow our [js](https://github.com/google/ggrc-core/blob/dev/docs/source/contributing/javascript.rst) and/or [python](https://github.com/google/ggrc-core/blob/dev/docs/source/contributing/python.rst) guidelines.\r\n- [ ] My commits follow our [commit guidelines](https://github.com/google/ggrc-core/blob/dev/docs/source/contributing/git/how_to_write_a_commit_message.rst).\r\n\r\n<!-- If your PR includes a migration include the additional checklist items\r\n# Migration checklist\r\n- [ ] Migration passes all checks from our [PR review guidelines](https://github.com/google/ggrc-core/blob/dev/docs/source/contributing/git/reviewing_pull_requests.rst#reviewing-a-pr-containing-database-migration-scripts)\r\n-->\r\n\r\n# PR Review checklist\r\n\r\n- [ ] The changes fix the issue and don't cause any apparent regressions.\r\n- [ ] Labels and milestone are correctly set.\r\n- [ ] The solution description matches the changes in the code.\r\n- [ ] There is no apparent way to improve the performance & design of the new code.\r\n- [ ] The pull request is opened against the correct base branch.\r\n- [ ] Upon merging, the Jira ticket's fixversion is correctly set and the ticket is moved to \"QA - In Progress\".\r\n\r\n<!-- If your code is not finished yet can include a TODO check list\r\n# TODO\r\n\r\n- [ ] First item on the TODO\r\n-->\r\n","created_at":"2018-08-09T10:02:11Z","updated_at":"2018-08-09T10:02:11Z","closed_at":null,"merged_at":null,"merge_commit_sha":null,"assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/google/ggrc-core/pulls/8263/commits","review_comments_url":"https://api.github.com/repos/google/ggrc-core/pulls/8263/comments","review_comment_url":"https://api.github.com/repos/google/ggrc-core/pulls/comments{/number}","comments_url":"https://api.github.com/repos/google/ggrc-core/issues/8263/comments","statuses_url":"https://api.github.com/repos/google/ggrc-core/statuses/c6bcb4a683aadcd1425c3b31bbeaf98bdbca000f","head":{"label":"belovmd:GGRC-4123-remove-Clause","ref":"GGRC-4123-remove-Clause","sha":"c6bcb4a683aadcd1425c3b31bbeaf98bdbca000f","user":{"login":"belovmd","id":39156721,"node_id":"MDQ6VXNlcjM5MTU2NzIx","avatar_url":"https://avatars2.githubusercontent.com/u/39156721?v=4","gravatar_id":"","url":"https://api.github.com/users/belovmd","html_url":"https://github.com/belovmd","followers_url":"https://api.github.com/users/belovmd/followers","following_url":"https://api.github.com/users/belovmd/following{/other_user}","gists_url":"https://api.github.com/users/belovmd/gists{/gist_id}","starred_url":"https://api.github.com/users/belovmd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/belovmd/subscriptions","organizations_url":"https://api.github.com/users/belovmd/orgs","repos_url":"https://api.github.com/users/belovmd/repos","events_url":"https://api.github.com/users/belovmd/events{/privacy}","received_events_url":"https://api.github.com/users/belovmd/received_events","type":"User","site_admin":false},"repo":{"id":133947758,"node_id":"MDEwOlJlcG9zaXRvcnkxMzM5NDc3NTg=","name":"ggrc-core","full_name":"belovmd/ggrc-core","owner":{"login":"belovmd","id":39156721,"node_id":"MDQ6VXNlcjM5MTU2NzIx","avatar_url":"https://avatars2.githubusercontent.com/u/39156721?v=4","gravatar_id":"","url":"https://api.github.com/users/belovmd","html_url":"https://github.com/belovmd","followers_url":"https://api.github.com/users/belovmd/followers","following_url":"https://api.github.com/users/belovmd/following{/other_user}","gists_url":"https://api.github.com/users/belovmd/gists{/gist_id}","starred_url":"https://api.github.com/users/belovmd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/belovmd/subscriptions","organizations_url":"https://api.github.com/users/belovmd/orgs","repos_url":"https://api.github.com/users/belovmd/repos","events_url":"https://api.github.com/users/belovmd/events{/privacy}","received_events_url":"https://api.github.com/users/belovmd/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/belovmd/ggrc-core","description":"GGRC Core","fork":true,"url":"https://api.github.com/repos/belovmd/ggrc-core","forks_url":"https://api.github.com/repos/belovmd/ggrc-core/forks","keys_url":"https://api.github.com/repos/belovmd/ggrc-core/keys{/key_id}","collaborators_url":"https://api.github.com/repos/belovmd/ggrc-core/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/belovmd/ggrc-core/teams","hooks_url":"https://api.github.com/repos/belovmd/ggrc-core/hooks","issue_events_url":"https://api.github.com/repos/belovmd/ggrc-core/issues/events{/number}","events_url":"https://api.github.com/repos/belovmd/ggrc-core/events","assignees_url":"https://api.github.com/repos/belovmd/ggrc-core/assignees{/user}","branches_url":"https://api.github.com/repos/belovmd/ggrc-core/branches{/branch}","tags_url":"https://api.github.com/repos/belovmd/ggrc-core/tags","blobs_url":"https://api.github.com/repos/belovmd/ggrc-core/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/belovmd/ggrc-core/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/belovmd/ggrc-core/git/refs{/sha}","trees_url":"https://api.github.com/repos/belovmd/ggrc-core/git/trees{/sha}","statuses_url":"https://api.github.com/repos/belovmd/ggrc-core/statuses/{sha}","languages_url":"https://api.github.com/repos/belovmd/ggrc-core/languages","stargazers_url":"https://api.github.com/repos/belovmd/ggrc-core/stargazers","contributors_url":"https://api.github.com/repos/belovmd/ggrc-core/contributors","subscribers_url":"https://api.github.com/repos/belovmd/ggrc-core/subscribers","subscription_url":"https://api.github.com/repos/belovmd/ggrc-core/subscription","commits_url":"https://api.github.com/repos/belovmd/ggrc-core/commits{/sha}","git_commits_url":"https://api.github.com/repos/belovmd/ggrc-core/git/commits{/sha}","comments_url":"https://api.github.com/repos/belovmd/ggrc-core/comments{/number}","issue_comment_url":"https://api.github.com/repos/belovmd/ggrc-core/issues/comments{/number}","contents_url":"https://api.github.com/repos/belovmd/ggrc-core/contents/{+path}","compare_url":"https://api.github.com/repos/belovmd/ggrc-core/compare/{base}...{head}","merges_url":"https://api.github.com/repos/belovmd/ggrc-core/merges","archive_url":"https://api.github.com/repos/belovmd/ggrc-core/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/belovmd/ggrc-core/downloads","issues_url":"https://api.github.com/repos/belovmd/ggrc-core/issues{/number}","pulls_url":"https://api.github.com/repos/belovmd/ggrc-core/pulls{/number}","milestones_url":"https://api.github.com/repos/belovmd/ggrc-core/milestones{/number}","notifications_url":"https://api.github.com/repos/belovmd/ggrc-core/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/belovmd/ggrc-core/labels{/name}","releases_url":"https://api.github.com/repos/belovmd/ggrc-core/releases{/id}","deployments_url":"https://api.github.com/repos/belovmd/ggrc-core/deployments","created_at":"2018-05-18T11:51:47Z","updated_at":"2018-08-09T09:40:37Z","pushed_at":"2018-08-09T09:41:33Z","git_url":"git://github.com/belovmd/ggrc-core.git","ssh_url":"git@github.com:belovmd/ggrc-core.git","clone_url":"https://github.com/belovmd/ggrc-core.git","svn_url":"https://github.com/belovmd/ggrc-core","homepage":null,"size":79710,"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":"dev"}},"base":{"label":"google:dev","ref":"dev","sha":"fab9877216491d0b968230a405e333f516cf6ac0","user":{"login":"google","id":1342004,"node_id":"MDEyOk9yZ2FuaXphdGlvbjEzNDIwMDQ=","avatar_url":"https://avatars1.githubusercontent.com/u/1342004?v=4","gravatar_id":"","url":"https://api.github.com/users/google","html_url":"https://github.com/google","followers_url":"https://api.github.com/users/google/followers","following_url":"https://api.github.com/users/google/following{/other_user}","gists_url":"https://api.github.com/users/google/gists{/gist_id}","starred_url":"https://api.github.com/users/google/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/google/subscriptions","organizations_url":"https://api.github.com/users/google/orgs","repos_url":"https://api.github.com/users/google/repos","events_url":"https://api.github.com/users/google/events{/privacy}","received_events_url":"https://api.github.com/users/google/received_events","type":"Organization","site_admin":false},"repo":{"id":9304637,"node_id":"MDEwOlJlcG9zaXRvcnk5MzA0NjM3","name":"ggrc-core","full_name":"google/ggrc-core","owner":{"login":"google","id":1342004,"node_id":"MDEyOk9yZ2FuaXphdGlvbjEzNDIwMDQ=","avatar_url":"https://avatars1.githubusercontent.com/u/1342004?v=4","gravatar_id":"","url":"https://api.github.com/users/google","html_url":"https://github.com/google","followers_url":"https://api.github.com/users/google/followers","following_url":"https://api.github.com/users/google/following{/other_user}","gists_url":"https://api.github.com/users/google/gists{/gist_id}","starred_url":"https://api.github.com/users/google/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/google/subscriptions","organizations_url":"https://api.github.com/users/google/orgs","repos_url":"https://api.github.com/users/google/repos","events_url":"https://api.github.com/users/google/events{/privacy}","received_events_url":"https://api.github.com/users/google/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/google/ggrc-core","description":"GGRC Core","fork":false,"url":"https://api.github.com/repos/google/ggrc-core","forks_url":"https://api.github.com/repos/google/ggrc-core/forks","keys_url":"https://api.github.com/repos/google/ggrc-core/keys{/key_id}","collaborators_url":"https://api.github.com/repos/google/ggrc-core/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/google/ggrc-core/teams","hooks_url":"https://api.github.com/repos/google/ggrc-core/hooks","issue_events_url":"https://api.github.com/repos/google/ggrc-core/issues/events{/number}","events_url":"https://api.github.com/repos/google/ggrc-core/events","assignees_url":"https://api.github.com/repos/google/ggrc-core/assignees{/user}","branches_url":"https://api.github.com/repos/google/ggrc-core/branches{/branch}","tags_url":"https://api.github.com/repos/google/ggrc-core/tags","blobs_url":"https://api.github.com/repos/google/ggrc-core/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/google/ggrc-core/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/google/ggrc-core/git/refs{/sha}","trees_url":"https://api.github.com/repos/google/ggrc-core/git/trees{/sha}","statuses_url":"https://api.github.com/repos/google/ggrc-core/statuses/{sha}","languages_url":"https://api.github.com/repos/google/ggrc-core/languages","stargazers_url":"https://api.github.com/repos/google/ggrc-core/stargazers","contributors_url":"https://api.github.com/repos/google/ggrc-core/contributors","subscribers_url":"https://api.github.com/repos/google/ggrc-core/subscribers","subscription_url":"https://api.github.com/repos/google/ggrc-core/subscription","commits_url":"https://api.github.com/repos/google/ggrc-core/commits{/sha}","git_commits_url":"https://api.github.com/repos/google/ggrc-core/git/commits{/sha}","comments_url":"https://api.github.com/repos/google/ggrc-core/comments{/number}","issue_comment_url":"https://api.github.com/repos/google/ggrc-core/issues/comments{/number}","contents_url":"https://api.github.com/repos/google/ggrc-core/contents/{+path}","compare_url":"https://api.github.com/repos/google/ggrc-core/compare/{base}...{head}","merges_url":"https://api.github.com/repos/google/ggrc-core/merges","archive_url":"https://api.github.com/repos/google/ggrc-core/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/google/ggrc-core/downloads","issues_url":"https://api.github.com/repos/google/ggrc-core/issues{/number}","pulls_url":"https://api.github.com/repos/google/ggrc-core/pulls{/number}","milestones_url":"https://api.github.com/repos/google/ggrc-core/milestones{/number}","notifications_url":"https://api.github.com/repos/google/ggrc-core/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/google/ggrc-core/labels{/name}","releases_url":"https://api.github.com/repos/google/ggrc-core/releases{/id}","deployments_url":"https://api.github.com/repos/google/ggrc-core/deployments","created_at":"2013-04-08T19:16:28Z","updated_at":"2018-08-09T09:48:12Z","pushed_at":"2018-08-09T09:50:15Z","git_url":"git://github.com/google/ggrc-core.git","ssh_url":"git@github.com:google/ggrc-core.git","clone_url":"https://github.com/google/ggrc-core.git","svn_url":"https://github.com/google/ggrc-core","homepage":null,"size":79961,"stargazers_count":306,"watchers_count":306,"language":"Python","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":226,"mirror_url":null,"archived":false,"open_issues_count":49,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":226,"open_issues":49,"watchers":306,"default_branch":"dev"}},"_links":{"self":{"href":"https://api.github.com/repos/google/ggrc-core/pulls/8263"},"html":{"href":"https://github.com/google/ggrc-core/pull/8263"},"issue":{"href":"https://api.github.com/repos/google/ggrc-core/issues/8263"},"comments":{"href":"https://api.github.com/repos/google/ggrc-core/issues/8263/comments"},"review_comments":{"href":"https://api.github.com/repos/google/ggrc-core/pulls/8263/comments"},"review_comment":{"href":"https://api.github.com/repos/google/ggrc-core/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/google/ggrc-core/pulls/8263/commits"},"statuses":{"href":"https://api.github.com/repos/google/ggrc-core/statuses/c6bcb4a683aadcd1425c3b31bbeaf98bdbca000f"}},"author_association":"COLLABORATOR","merged":false,"mergeable":null,"rebaseable":null,"mergeable_state":"unknown","merged_by":null,"comments":0,"review_comments":0,"maintainer_can_modify":true,"commits":2,"additions":498,"deletions":0,"changed_files":4}}
{"actor":{"display_login":"belovmd"}}