)]}'
{"id":"openstack%2Fkeystone~875764","triplet_id":"openstack%2Fkeystone~master~I31ba9e4f129a7cc28744e814b5fd28eb284ae3de","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:10.000000000","reason":"Change was submitted"}},"hashtags":[],"change_id":"I31ba9e4f129a7cc28744e814b5fd28eb284ae3de","subject":"db: Remove legacy migrations","status":"MERGED","created":"2023-02-28 17:26:46.000000000","updated":"2023-06-27 16:02:10.000000000","submitted":"2023-06-27 16:02:10.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":"875764-sqlalchemy-20","meta_rev_id":"b1ba5831b1b8c31524dfcc6dbdb39c8d245491d8","_number":875764,"virtual_id_number":875764,"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":7414,"name":"David Wilde","email":"dwilde@redhat.com","username":"d34dh0r53"},{"value":0,"_account_id":32761,"name":"panhongyin","display_name":"panhongyin","email":"panhongyin@yovole.com","username":"panhongyin"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2023-06-27 16:02:10.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:40:29.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"value":2,"date":"2023-06-27 13:12:10.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":7414,"name":"David Wilde","email":"dwilde@redhat.com","username":"d34dh0r53"},{"value":1,"date":"2023-06-26 07:50:26.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":32761,"name":"panhongyin","display_name":"panhongyin","email":"panhongyin@yovole.com","username":"panhongyin"},{"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":7414,"name":"David Wilde","email":"dwilde@redhat.com","username":"d34dh0r53"},"all":[{"value":0,"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"value":1,"date":"2023-06-27 13:12:10.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":7414,"name":"David Wilde","email":"dwilde@redhat.com","username":"d34dh0r53"},{"value":0,"_account_id":32761,"name":"panhongyin","display_name":"panhongyin","email":"panhongyin@yovole.com","username":"panhongyin"},{"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":7414,"name":"David Wilde","email":"dwilde@redhat.com","username":"d34dh0r53"},{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":32761,"name":"panhongyin","display_name":"panhongyin","email":"panhongyin@yovole.com","username":"panhongyin"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2023-02-28 17:43:02.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 21:07:47.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-06-22 21:40:29.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"},{"updated":"2023-06-26 07:50:26.000000000","updated_by":{"_account_id":32761,"name":"panhongyin","display_name":"panhongyin","email":"panhongyin@yovole.com","username":"panhongyin"},"reviewer":{"_account_id":32761,"name":"panhongyin","display_name":"panhongyin","email":"panhongyin@yovole.com","username":"panhongyin"},"state":"REVIEWER"},{"updated":"2023-06-27 13:12:10.000000000","updated_by":{"_account_id":7414,"name":"David Wilde","email":"dwilde@redhat.com","username":"d34dh0r53"},"reviewer":{"_account_id":7414,"name":"David Wilde","email":"dwilde@redhat.com","username":"d34dh0r53"},"state":"REVIEWER"}],"messages":[{"id":"22462f3950816b3d9def76690505f258677ecc35","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":"3b999a592d1250e44fb633f833e085683afe6aef","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-02-28 17:43:02.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/ab7cfca073c94d49a798ff160ee649c9\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/46f1fd8f0cf34b1fb6872a9f206d088c : SUCCESS in 13m 22s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/50c5c4cad20e4f8cb514091823352a4a : SUCCESS in 13m 18s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"100b29232510b176f7bfd6269f63d648cb053b18","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-02-28 21:07:47.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/bbd0d0e844da401d94edef686d41dd9e\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/04d34e76b48b48d8bfbb8d238ec06123 : SUCCESS in 14m 00s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/1e7f02fb2ec841f9b7045d07300afbda : SUCCESS in 8m 14s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/bebdf5c7d03546b182d79c8d95526ff7 : SUCCESS in 19m 49s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/633d811a5829477daf77fd0f749758a2 : SUCCESS in 11m 04s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/2335a9ce21194de3872316ba88ebb60f : SUCCESS in 12m 50s\n- requirements-check https://zuul.opendev.org/t/openstack/build/c94887117daf4ed48fa71cf548689c8c : SUCCESS in 4m 01s\n- grenade https://zuul.opendev.org/t/openstack/build/2522773725804cd28b23f21f16e763aa : SUCCESS in 51m 36s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/49519ab0f608425197e5265ec1049a5e : SUCCESS in 1h 23m 36s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/6fd2067a2a0f4cbfa1b952f0e4fff921 : SUCCESS in 6m 56s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/f32a3fef8b3743c0970895d1d53d334f : SUCCESS in 27m 33s\n- keystone-dsvm-py3-functional-fips https://zuul.opendev.org/t/openstack/build/aac62e2f6fc844aeb76026cc2dde4432 : SUCCESS in 48m 19s (non-voting)\n- keystone-dsvm-py3-functional-federation-ubuntu-focal https://zuul.opendev.org/t/openstack/build/1142525426ae4674a47f92cd02e303ea : SUCCESS in 50m 03s (non-voting)\n- keystone-dsvm-py3-functional-federation-ubuntu-focal-k2k https://zuul.opendev.org/t/openstack/build/6aa1ba7e3ba14ae7900affed40bbf1af : SUCCESS in 36m 25s\n- keystoneclient-devstack-functional https://zuul.opendev.org/t/openstack/build/147f39a1b3fd4829873145c82fcc8963 : SUCCESS in 21m 48s (non-voting)\n- keystone-dsvm-ldap-domain-specific-driver https://zuul.opendev.org/t/openstack/build/39ff2f129c30421693ac1ab7e9d331a6 : FAILURE in 24m 26s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/93d6fc37f7b048218d1616a72c256d53 : SUCCESS in 58m 23s\n- keystone-protection-functional https://zuul.opendev.org/t/openstack/build/6107be9c668543a6b42da9e21e2933ba : SUCCESS in 39m 15s","accounts_in_message":[],"_revision_number":1},{"id":"58657768089a0e609d8a4275e505e6d7d5f8999d","author":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"date":"2023-06-22 21:40:29.000000000","message":"Patch Set 1: Code-Review+2","accounts_in_message":[],"_revision_number":1},{"id":"018f5a2e0a3a89013c5a7ea534f754d2fb3489bd","author":{"_account_id":32761,"name":"panhongyin","display_name":"panhongyin","email":"panhongyin@yovole.com","username":"panhongyin"},"date":"2023-06-26 07:50:26.000000000","message":"Patch Set 1: Code-Review+1","accounts_in_message":[],"_revision_number":1},{"id":"47758b62bb9f47feb460d7153d1d5b286123822c","author":{"_account_id":7414,"name":"David Wilde","email":"dwilde@redhat.com","username":"d34dh0r53"},"date":"2023-06-27 13:12:10.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":1},{"id":"416296c3a9b34e00573b0ca47f0c488ea1f613f6","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-06-27 13:12:56.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"c9ba56c92bf7f9b7bfc1ae638f0302c88b537a3d","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-06-27 16:02:10.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/f167aeb1dd2d4a5c8ccb219d07a394ed\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/1db39ddc1e644f069a74f903a20cb5af : SUCCESS in 4m 37s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/7596babb9687493491101b03cc4d7824 : SUCCESS in 13m 31s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/ea0020f77da14e609ccb848f1145adbf : SUCCESS in 11m 43s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/ab2aef2c6fb24768aed77a0edc978d62 : SUCCESS in 9m 08s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/6155835c6337401f983997dd358e10fa : SUCCESS in 19m 28s\n- requirements-check https://zuul.opendev.org/t/openstack/build/2f2ab5f978cd412e9e4769647c1f3853 : SUCCESS in 2m 54s\n- grenade https://zuul.opendev.org/t/openstack/build/bf8ebaf3f9b14993b26af29a25c9230e : SUCCESS in 37m 23s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/e4de7b1b7c664671842a7e43f2095906 : SUCCESS in 1h 21m 10s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/fa6de4cb7bb14a99885c6ca45aedb9ec : SUCCESS in 7m 30s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/915b4881fd4641869d1afe8ee8d9a02b : SUCCESS in 38m 50s\n- keystone-dsvm-py3-functional-federation-ubuntu-focal-k2k https://zuul.opendev.org/t/openstack/build/17c2e9af123a47e1b97fb34e77c168cc : SUCCESS in 48m 36s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/86286977e10343d38f244c0407ae88fd : SUCCESS in 49m 27s\n- keystone-protection-functional https://zuul.opendev.org/t/openstack/build/c3fa6cd044ee4084811ed4698add92f8 : SUCCESS in 1h 00m 34s","accounts_in_message":[],"_revision_number":1},{"id":"b1ba5831b1b8c31524dfcc6dbdb39c8d245491d8","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-06-27 16:02:10.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"8c9462f6fa65fb615af4d4bfe8afae0d0143a644","revisions":{"8c9462f6fa65fb615af4d4bfe8afae0d0143a644":{"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/64/875764/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/keystone","ref":"refs/changes/64/875764/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/keystone refs/changes/64/875764/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/keystone refs/changes/64/875764/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/keystone refs/changes/64/875764/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/keystone refs/changes/64/875764/1"}}},"commit":{"parents":[{"commit":"0bbaf63a5a730b0f0cb72c79c4715167e5d9187f","subject":"db: Replace use of reverse cascades","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/0bbaf63a5a730b0f0cb72c79c4715167e5d9187f"}]}],"author":{"name":"Stephen Finucane","email":"sfinucan@redhat.com","date":"2023-02-28 13:17:31.000000000","tz":0},"committer":{"name":"Stephen Finucane","email":"sfinucan@redhat.com","date":"2023-02-28 17:26:39.000000000","tz":0},"subject":"db: Remove legacy migrations","message":"db: Remove legacy migrations\n\nsqlalchemy-migrate does not (and will not) support sqlalchemy 2.0. We\nneed to drop these migrations to ensure we can upgrade our sqlalchemy\nversion.\n\nChange-Id: I31ba9e4f129a7cc28744e814b5fd28eb284ae3de\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/8c9462f6fa65fb615af4d4bfe8afae0d0143a644"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/8c9462f6fa65fb615af4d4bfe8afae0d0143a644"}]},"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":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"}},{"label":"Workflow","status":"MAY","applied_by":{"_account_id":7414,"name":"David Wilde","email":"dwilde@redhat.com","username":"d34dh0r53"}}]}],"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":{}}}]}