)]}'
{"id":"openstack%2Fkeystone~875763","triplet_id":"openstack%2Fkeystone~master~I277cb4d512ca6b4e4aca5aad60a97a78cdb961e3","project":"openstack/keystone","branch":"master","topic":"sqlalchemy-20","attention_set":{},"removed_from_attention_set":{"15334":{"account":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"last_update":"2023-06-27 16:02:08.000000000","reason":"Change was submitted"}},"hashtags":[],"change_id":"I277cb4d512ca6b4e4aca5aad60a97a78cdb961e3","subject":"db: Replace use of reverse cascades","status":"MERGED","created":"2023-02-28 17:26:46.000000000","updated":"2023-06-27 16:03:30.000000000","submitted":"2023-06-27 16:02:08.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"875763-sqlalchemy-20","meta_rev_id":"eb2188ca168238e2c9b9be6f90ea77a1743bcb19","_number":875763,"virtual_id_number":875763,"owner":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"value":0,"_account_id":597,"name":"Pete Zaitcev","email":"zaitcev@kotori.zaitcev.us","username":"zaitcev"},{"value":0,"_account_id":16137,"name":"Tobias Urdin","email":"tobias.urdin@binero.com","username":"tobasco"},{"value":0,"_account_id":14250,"name":"Grzegorz Grasza","email":"xek@redhat.com","username":"xek"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2023-06-27 16:02:08.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","default_value":0,"optional":true},"Code-Review":{"approved":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"all":[{"value":2,"date":"2023-06-22 21:38:48.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"value":1,"date":"2023-04-04 23:45:30.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":597,"name":"Pete Zaitcev","email":"zaitcev@kotori.zaitcev.us","username":"zaitcev"},{"value":1,"date":"2023-05-29 21:05:18.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":16137,"name":"Tobias Urdin","email":"tobias.urdin@binero.com","username":"tobasco"},{"value":2,"date":"2023-06-19 08:22:53.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":14250,"name":"Grzegorz Grasza","email":"xek@redhat.com","username":"xek"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-2":"Do not merge","-1":"This patch needs further work before it can be merged"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me (core reviewer)"},"description":"","default_value":0,"optional":true},"Workflow":{"approved":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"all":[{"value":1,"date":"2023-06-22 21:38:48.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"value":0,"_account_id":597,"name":"Pete Zaitcev","email":"zaitcev@kotori.zaitcev.us","username":"zaitcev"},{"value":0,"_account_id":16137,"name":"Tobias Urdin","email":"tobias.urdin@binero.com","username":"tobasco"},{"value":0,"_account_id":14250,"name":"Grzegorz Grasza","email":"xek@redhat.com","username":"xek"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":597,"name":"Pete Zaitcev","email":"zaitcev@kotori.zaitcev.us","username":"zaitcev"},{"_account_id":14250,"name":"Grzegorz Grasza","email":"xek@redhat.com","username":"xek"},{"_account_id":16137,"name":"Tobias Urdin","email":"tobias.urdin@binero.com","username":"tobasco"},{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"CC":[{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2023-02-28 17:44:17.000000000","updated_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"reviewer":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"state":"CC"},{"updated":"2023-02-28 20:40:50.000000000","updated_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"reviewer":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2023-04-04 23:45:30.000000000","updated_by":{"_account_id":597,"name":"Pete Zaitcev","email":"zaitcev@kotori.zaitcev.us","username":"zaitcev"},"reviewer":{"_account_id":597,"name":"Pete Zaitcev","email":"zaitcev@kotori.zaitcev.us","username":"zaitcev"},"state":"REVIEWER"},{"updated":"2023-05-29 21:05:18.000000000","updated_by":{"_account_id":16137,"name":"Tobias Urdin","email":"tobias.urdin@binero.com","username":"tobasco"},"reviewer":{"_account_id":16137,"name":"Tobias Urdin","email":"tobias.urdin@binero.com","username":"tobasco"},"state":"REVIEWER"},{"updated":"2023-06-07 13:11:43.000000000","updated_by":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"reviewer":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"state":"CC"},{"updated":"2023-06-19 08:22:53.000000000","updated_by":{"_account_id":14250,"name":"Grzegorz Grasza","email":"xek@redhat.com","username":"xek"},"reviewer":{"_account_id":14250,"name":"Grzegorz Grasza","email":"xek@redhat.com","username":"xek"},"state":"REVIEWER"},{"updated":"2023-06-22 21:38:48.000000000","updated_by":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"reviewer":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"state":"REVIEWER"}],"messages":[{"id":"1e85cd31b58a4e8391531a06ada9ca81c285d563","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2023-02-28 17:26:46.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"b9a9c364543fb1c71b86b6618845f4f652844b17","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-02-28 17:44:17.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/faf02d0ec6b94ac087e41455d8a8d736\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/9964220dbf3b4c6b975e1f1e338c19d3 : SUCCESS in 12m 27s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/9df8628caabc45d98a416f18c9720619 : SUCCESS in 14m 37s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"75c2690c68236e92bd2d422ba12224631ba62484","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-02-28 20:40:50.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/787e445978ac481c8ddd9e7b7f5d2fcb\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/cd6a5926974c4754938707f79e0cb919 : SUCCESS in 15m 18s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/1ffa638e68134cd7bfccc1ff6bca460f : SUCCESS in 5m 16s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/1c7f8da43a5c4b7382e493d5570a0223 : SUCCESS in 13m 43s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/9bd7c1e87c134b6b96729f0657870568 : SUCCESS in 12m 50s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/06c66f7530ee46609e3610543f183ee1 : SUCCESS in 14m 42s\n- grenade https://zuul.opendev.org/t/openstack/build/4549fb8b9a5d4618b99a4e04345acd9e : SUCCESS in 48m 12s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/873a0f343b234de58ff7293ddd6ffd00 : SUCCESS in 1h 15m 29s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/257b83a6ed52440c8c910b2f153b6511 : SUCCESS in 36m 35s\n- keystone-dsvm-py3-functional-fips https://zuul.opendev.org/t/openstack/build/8728be458f744fecb716fbee9fe0a6c5 : SUCCESS in 47m 12s (non-voting)\n- keystone-dsvm-py3-functional-federation-ubuntu-focal https://zuul.opendev.org/t/openstack/build/026ac27026fa4cd1b18bde1363b04154 : SUCCESS in 29m 03s (non-voting)\n- keystone-dsvm-py3-functional-federation-ubuntu-focal-k2k https://zuul.opendev.org/t/openstack/build/67cbce8f423f448986d167e825d3818b : SUCCESS in 24m 14s\n- keystoneclient-devstack-functional https://zuul.opendev.org/t/openstack/build/bbfc8a3a037f46159fb51e3186a0fabf : SUCCESS in 10m 05s (non-voting)\n- keystone-dsvm-ldap-domain-specific-driver https://zuul.opendev.org/t/openstack/build/4c61305829014e16b1feb9bb6678fd81 : FAILURE in 26m 25s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/407ffd607d6b46398a65b6db5d142a77 : SUCCESS in 1h 10m 07s\n- keystone-protection-functional https://zuul.opendev.org/t/openstack/build/783df6fd95e242978d654827556784ef : SUCCESS in 51m 55s","accounts_in_message":[],"_revision_number":1},{"id":"08c01e4c527bd49cd875b32f84d437b70d074298","author":{"_account_id":597,"name":"Pete Zaitcev","email":"zaitcev@kotori.zaitcev.us","username":"zaitcev"},"date":"2023-04-04 23:45:30.000000000","message":"Patch Set 1: Code-Review+1","accounts_in_message":[],"_revision_number":1},{"id":"524209bfedd4c0109392f241d5dc2869248b7755","author":{"_account_id":16137,"name":"Tobias Urdin","email":"tobias.urdin@binero.com","username":"tobasco"},"date":"2023-05-29 21:05:18.000000000","message":"Patch Set 1: Code-Review+1","accounts_in_message":[],"_revision_number":1},{"id":"d18877e47781cb94c065b86f9723c443414bde2c","author":{"_account_id":14250,"name":"Grzegorz Grasza","email":"xek@redhat.com","username":"xek"},"date":"2023-06-19 08:22:53.000000000","message":"Patch Set 1: Code-Review+2","accounts_in_message":[],"_revision_number":1},{"id":"f89fff1a47512a6e9a2171319a36abfeb95afb4b","author":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"date":"2023-06-22 21:38:48.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":1},{"id":"22623e9ac21ce90b462ebd5a3d5269a4b64f2c8a","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-06-27 13:12:22.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"832cfe549ba4fbb2613bc5f3e521076019da4915","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-06-27 16:02:08.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/91a2d91dd04e4930b79cb63e3ffd798a\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/5c54df8582384c10b97f5ebbe61adf35 : SUCCESS in 8m 34s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/8f3dac9ede524564b797ab603d47f9bd : SUCCESS in 14m 26s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/a6cbbfad8c9c4d788e5f34e3c2df5765 : SUCCESS in 14m 17s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/97dfb072f6404a82ae3fcf43efb19d99 : SUCCESS in 22m 52s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/c23d6391d1344277ace514e670a1d6f4 : SUCCESS in 14m 33s\n- grenade https://zuul.opendev.org/t/openstack/build/f2bc2b846f9c416eb0fa83a46f7b9d5f : SUCCESS in 48m 50s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/5e4b915d71284aa7847f277685549333 : SUCCESS in 1h 27m 48s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/93697f8cc5904b0d86f3c9b6b3da4899 : SUCCESS in 23m 46s\n- keystone-dsvm-py3-functional-federation-ubuntu-focal-k2k https://zuul.opendev.org/t/openstack/build/577e4a56af32470e963c5e598060417e : SUCCESS in 21m 27s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/29418ff74b124bf59e6a0a5862283116 : SUCCESS in 57m 03s\n- keystone-protection-functional https://zuul.opendev.org/t/openstack/build/e24353f629ae4683a4d2f1c096dbbf22 : SUCCESS in 32m 12s","accounts_in_message":[],"_revision_number":1},{"id":"515fd92cba3799875ecff8454df5c12f6aaff8e4","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-06-27 16:02:08.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":1},{"id":"eb2188ca168238e2c9b9be6f90ea77a1743bcb19","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-06-27 16:03:30.000000000","message":"Patch Set 1:\n\nBuild succeeded (promote pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/2cf3f46f2ee2427ead4c12d76dab0bb2\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/ba58f8f5c3c24f87835622b60e3e045b : SUCCESS in 58s","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"0bbaf63a5a730b0f0cb72c79c4715167e5d9187f","revisions":{"0bbaf63a5a730b0f0cb72c79c4715167e5d9187f":{"kind":"REWORK","_number":1,"created":"2023-02-28 17:26:46.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"ref":"refs/changes/63/875763/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/keystone","ref":"refs/changes/63/875763/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/keystone refs/changes/63/875763/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/keystone refs/changes/63/875763/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/keystone refs/changes/63/875763/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/keystone refs/changes/63/875763/1"}}},"commit":{"parents":[{"commit":"5d2ab6c63b5b943a5a8062b92daf2c198e21b714","subject":"db: Replace use of Query.get()","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/5d2ab6c63b5b943a5a8062b92daf2c198e21b714"}]}],"author":{"name":"Stephen Finucane","email":"sfinucan@redhat.com","date":"2023-02-28 12:57:36.000000000","tz":0},"committer":{"name":"Stephen Finucane","email":"sfinucan@redhat.com","date":"2023-02-28 17:26:39.000000000","tz":0},"subject":"db: Replace use of reverse cascades","message":"db: Replace use of reverse cascades\n\nResolve the following RemovedIn20Warning warning:\n\n  \"ApplicationCredentialRoleModel\" object is being merged into a Session\n  along the backref cascade path for relationship\n  \"ApplicationCredentialModel.roles\"; in SQLAlchemy 2.0, this reverse\n  cascade will not take place.  Set cascade_backrefs to False in either\n  the relationship() or backref() function for the 2.0 behavior; or to\n  set globally for the whole Session, set the future\u003dTrue flag\n\nThis also applies for \"ApplicationCredentialAccessRuleModel\" and\n\"AccessRuleModel.application_credential\".\n\nChange-Id: I277cb4d512ca6b4e4aca5aad60a97a78cdb961e3\nSigned-off-by: Stephen Finucane \u003csfinucan@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/0bbaf63a5a730b0f0cb72c79c4715167e5d9187f"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/0bbaf63a5a730b0f0cb72c79c4715167e5d9187f"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~DefaultSubmitRule","status":"CLOSED","labels":[{"label":"Verified","status":"MAY","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"MAY","applied_by":{"_account_id":14250,"name":"Grzegorz Grasza","email":"xek@redhat.com","username":"xek"}},{"label":"Workflow","status":"MAY","applied_by":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"}}]}],"submit_requirements":[{"name":"Verified","description":"Verified in gate by CI","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Verified\u003dMAX AND -label:Verified\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Verified\u003dMAX"],"failing_atoms":["label:Verified\u003dMIN"],"atom_explanations":{}}},{"name":"Code-Review","description":"Code reviewed by core reviewer","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Code-Review\u003dMAX AND -label:Code-Review\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Code-Review\u003dMAX"],"failing_atoms":["label:Code-Review\u003dMIN"],"atom_explanations":{}}},{"name":"Workflow","description":"Approved for gate by core reviewer","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Workflow\u003dMAX AND -label:Workflow\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Workflow\u003dMAX"],"failing_atoms":["label:Workflow\u003dMIN"],"atom_explanations":{}}}]}