)]}'
{"id":"openstack%2Fplacement~855862","triplet_id":"openstack%2Fplacement~master~I23ac1d85290a2dec307f8e76aafb02096259b605","project":"openstack/placement","branch":"master","topic":"sqlalchemy-20","attention_set":{},"removed_from_attention_set":{"9708":{"account":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"last_update":"2022-09-07 11:15:06.000000000","reason":"Change was submitted"},"11604":{"account":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"last_update":"2022-09-07 11:15:06.000000000","reason":"Change was submitted"},"15334":{"account":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"last_update":"2022-09-05 14:54:05.000000000","reason":"\u003cGERRIT_ACCOUNT_15334\u003e replied on the change","reason_account":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"}}},"hashtags":[],"change_id":"I23ac1d85290a2dec307f8e76aafb02096259b605","subject":"Make us compatible with oslo.db 12.1.0","status":"MERGED","created":"2022-09-05 09:47:02.000000000","updated":"2022-09-07 11:16:08.000000000","submitted":"2022-09-07 11:15:06.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":5,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"855862-sqlalchemy-20","meta_rev_id":"ae0167aa0430335efdf7b9f3082eda179c60d47f","_number":855862,"virtual_id_number":855862,"owner":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"tag":"autogenerated:zuul:gate","value":2,"date":"2022-09-07 11:15:06.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},{"value":0,"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"}],"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":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"all":[{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":2,"date":"2022-09-07 09:49:32.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},{"value":2,"date":"2022-09-05 14:54:05.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"}],"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":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"all":[{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":1,"date":"2022-09-07 09:49:32.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},{"value":0,"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},{"value":0,"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"}],"values":{" 0":"Default Priority","+1":"Contributor Review Promise","+2":"Core Review Promise"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"}],"reviewers":{"REVIEWER":[{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2022-09-05 09:48:33.000000000","updated_by":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"reviewer":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"state":"REVIEWER"},{"updated":"2022-09-05 09:48:33.000000000","updated_by":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"reviewer":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"state":"REVIEWER"},{"updated":"2022-09-05 11:24:58.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":"2022-09-07 09:49:32.000000000","updated_by":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"reviewer":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"state":"REVIEWER"}],"messages":[{"id":"e0edcced86a76f3b7d308c7ca4e6b76c6fc02b78","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"date":"2022-09-05 09:47:02.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"4c2e11a970520ed586efbef91a26f305d0e0bff0","author":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"date":"2022-09-05 10:26:39.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"61332a56eeec9bb0ec51782a3e5ed3f6971bba9f","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-09-05 11:24:58.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/263325f5af8d44f9a9ab6ff5eef74eeb\n\n- grenade https://zuul.opendev.org/t/openstack/build/442c45d15624408e837415486bca6d3d : SUCCESS in 1h 09m 40s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/71b0fb5d85e547878e710053430f349d : SUCCESS in 1h 32m 42s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/c64aa55643aa4e84bb5f89180a57fdbe : SUCCESS in 1h 04m 07s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/62ae8512e1594ff2b2e8facb53baf5f3 : SUCCESS in 7m 14s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/9fb45f63220a4cc896beddee919446ec : SUCCESS in 4m 58s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/eaf35a8675d7424f972446b518fd06b1 : SUCCESS in 5m 54s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/cc3d1fa4c8d543068a43b77bc09d30e1 : SUCCESS in 8m 53s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/f035efec9c9142ebac96a01f29e6f755 : RETRY_LIMIT in 2m 24s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/ef9d013a2feb4fdba5ad82c820356b63 : SUCCESS in 8m 58s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/7e90a3415e03490891cfb5e69a7a25c7 : SUCCESS in 5m 49s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/8b778d16a5c442e0b527b27b72893932 : SUCCESS in 7m 03s\n- placement-nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/5733784e925445ceb3b15ff5e9509655 : SUCCESS in 18m 01s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/ec406f23cbd846929143c965688ba612 : SUCCESS in 23m 56s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/00468ffbf19248e3a4ba4560032816ff : SUCCESS in 8m 17s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/4869ba68a4a14327a59727edce484429 : SUCCESS in 58m 15s","accounts_in_message":[],"_revision_number":1},{"id":"1236262e64b9e1fd21d723b96a8d3b58f320c963","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2022-09-05 14:54:05.000000000","message":"Patch Set 1: Code-Review+2","accounts_in_message":[],"_revision_number":1},{"id":"6803153a3b148f645ebe8496fd322b972e3012d3","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2022-09-05 16:17:25.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"178501b8814989ca4a5ad0c4f75b7cc3c34c1290","tag":"autogenerated:gerrit:setTopic","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2022-09-05 16:20:34.000000000","message":"Topic oslo.db-12.1.0 removed","accounts_in_message":[],"_revision_number":1},{"id":"c2eac6ace09452063c82c4b331c2cbf1b3d4c923","tag":"autogenerated:gerrit:setTopic","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2022-09-05 16:20:39.000000000","message":"Topic set to sqlalchemy-20","accounts_in_message":[],"_revision_number":1},{"id":"c53742430cc3229e98f64880e4503a3f4eb1e819","author":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"date":"2022-09-07 09:49:32.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1\n\n(3 comments)","accounts_in_message":[],"_revision_number":1},{"id":"57b2bdbce7b74048d8736a5f7362dc4fc03f09f9","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-09-07 09:50:15.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"f17a0d1594a57a46169922e7c97dfb2fd374bb9b","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-09-07 11:15:06.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/3855e8bdf3ed4b05bdb142f2888f8c32\n\n- grenade https://zuul.opendev.org/t/openstack/build/7d7aaf5e75054814ab4d219fe68630de : SUCCESS in 56m 58s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/f5599b320e6c482481144697163207da : SUCCESS in 1h 23m 33s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/a90dd54634e04de38563e4fcb07504b2 : SUCCESS in 1h 10m 11s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/7cdf66e1b6c2406c8f3a5aaea1fb610d : SUCCESS in 7m 55s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/3273940158e04a6e970e5a4357b84b3a : SUCCESS in 8m 34s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/b57a5859f429453ab1f11e8375ee5e7a : SUCCESS in 8m 43s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/311b37fd6fb447edad1995ffd74eeb40 : SUCCESS in 10m 36s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/1add04d80e354ec29e5ade64d42740cc : SUCCESS in 8m 51s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/bb57d535cac0484faea209a4a9443eba : SUCCESS in 9m 02s\n- placement-nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/f7ec6e57c5a14a7cb22ca8edc2ab32ed : SUCCESS in 19m 12s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/457ea04e3d5a4c5284615c80313814d1 : SUCCESS in 59m 44s","accounts_in_message":[],"_revision_number":1},{"id":"c96a5abe4b5cfac73f0cc0a592bf28bde95e1006","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-09-07 11:15:06.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":1},{"id":"ae0167aa0430335efdf7b9f3082eda179c60d47f","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-09-07 11:16:08.000000000","message":"Patch Set 1:\n\nBuild succeeded (promote pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/fff9be660f67404bbc9431740c07824f\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/7e7aff29cb364a5baf0d14d8780fae1f : SUCCESS in 42s","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"5ec38f6d3b76619fac442a85a9b5c73dc606b83a","revisions":{"5ec38f6d3b76619fac442a85a9b5c73dc606b83a":{"kind":"REWORK","_number":1,"created":"2022-09-05 09:47:02.000000000","uploader":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"ref":"refs/changes/62/855862/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/62/855862/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/62/855862/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/62/855862/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/62/855862/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/62/855862/1"}}},"commit":{"parents":[{"commit":"723da65faf66cc9b8d02f3756387dc58437e62af","subject":"Merge \"Fix typo in schema\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/723da65faf66cc9b8d02f3756387dc58437e62af"}]}],"author":{"name":"Balazs Gibizer","email":"gibi@redhat.com","date":"2022-09-05 09:33:11.000000000","tz":120},"committer":{"name":"Balazs Gibizer","email":"gibi@redhat.com","date":"2022-09-05 09:44:53.000000000","tz":120},"subject":"Make us compatible with oslo.db 12.1.0","message":"Make us compatible with oslo.db 12.1.0\n\nWith oslo.db 12.1.0 the following sqlalchemy warning become an error:\n\n  sqlalchemy.exc.RemovedIn20Warning: Retrieving row members using strings\n  or other non-integers is deprecated; use row._mapping for a dictionary\n  interface to the row (Background on SQLAlchemy 2.0 at:\n  https://sqlalche.me/e/b8d9)\n\nWe tried to fix this before but missed a test_case that still used dict\naccess to get the fields of a Row instead of attribute access. We fixed\nthat test here. Also while fixed it I noticed that the generic\n_AttributeCache object states that it stores dicts but actually it\nsometimes stores dict but sometimes it stores Row objects. So the doc is\nupdated and the dict path converted to store namedtuple objects in the\ncache instead. Note that Row is also acts like a namedtuple except that\n._mapping does not exists in namedtuple but exists in Row. The trait\nobject assumed it gets a Row object with ._mapping from the cache so\nthat is adjusted to only assume a namedtuple and use _asdict() to covert\nit to dict which is available both in Row and namedtuple.\n\nChange-Id: I23ac1d85290a2dec307f8e76aafb02096259b605\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/5ec38f6d3b76619fac442a85a9b5c73dc606b83a"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/5ec38f6d3b76619fac442a85a9b5c73dc606b83a"}]},"parents_data":[{"branch_name":"refs/heads/master","commit_id":"723da65faf66cc9b8d02f3756387dc58437e62af","is_merged_in_target_branch":true}],"branch":"refs/heads/master"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~DefaultSubmitRule","status":"CLOSED","labels":[{"label":"Verified","status":"OK","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"OK","applied_by":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"}},{"label":"Workflow","status":"OK","applied_by":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"}},{"label":"Review-Priority","status":"MAY"}]}],"submit_requirements":[]}