)]}'
{"id":"openstack%2Fplacement~801100","triplet_id":"openstack%2Fplacement~master~Ia62493017758db218a57c3e48a7b4dbe9c5494ee","project":"openstack/placement","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":"2022-04-14 10:32:47.000000000","reason":"Change was submitted"},"9816":{"account":{"_account_id":9816,"name":"Takashi Kajinami","email":"kajinamit@oss.nttdata.com","username":"kajinamit"},"last_update":"2022-04-07 14:56:55.000000000","reason":"sean mooney replied on the change"}},"hashtags":[],"change_id":"Ia62493017758db218a57c3e48a7b4dbe9c5494ee","subject":"db: Replace \u0027as_scalar()\u0027 with \u0027scalar_subquery()\u0027","status":"MERGED","created":"2021-07-16 16:50:39.000000000","updated":"2022-04-14 10:34:36.000000000","submitted":"2022-04-14 10:32:47.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":"801100-sqlalchemy-20","meta_rev_id":"648beddcdd7343f67c8615525de8fecc65d90f9e","_number":801100,"virtual_id_number":801100,"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":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2022-04-14 10:32:47.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"}],"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":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"all":[{"value":2,"date":"2022-04-07 14:56:55.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":2,"date":"2022-04-14 10:34:36.000000000","post_submit":true,"permitted_voting_range":{"min":2,"max":2},"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"}],"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":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"all":[{"value":1,"date":"2022-04-07 14:56:55.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"}],"values":{" 0":"Default Priority","+1":"Contributor Review Promise","+2":"Core Review Promise"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2021-07-16 18:01:57.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-02-08 12:01:12.000000000","updated_by":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"reviewer":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"state":"REVIEWER"},{"updated":"2022-04-07 14:56:55.000000000","updated_by":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"reviewer":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"state":"REVIEWER"}],"messages":[{"id":"a477e489af95bf18e7bdbf0982721e4351c27b8d","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2021-07-16 16:50:39.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"b39bac1e5275b7ed18704cc0fc9236dceab17a75","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-16 18:01:57.000000000","message":"Patch Set 1: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- grenade https://zuul.opendev.org/t/openstack/build/4bfd2beb84df4bec95ad76c176442f9e : SUCCESS in 1h 05m 45s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/83652bf5638848b5b52c785fe5fe17f1 : FAILURE in 1h 01m 16s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/fa1a9308e6204b0bb2bbbed8b87ecec9 : FAILURE in 8m 34s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/4c638cacde4f4f7bb0d65d79271c4d4f : FAILURE in 7m 23s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/d32d2fc45bec439fa00359cc9108531f : SUCCESS in 7m 07s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/da4a3a9c8555477993aa770071af1d68 : SUCCESS in 7m 39s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/29d8a57e02154a46ba281414b4aebae5 : SUCCESS in 6m 02s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/28d97fe472e44e33a2076fbfe646de9a : SUCCESS in 8m 19s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/8f986ebcd2ba4a34aa0b83553dafd7fa : SUCCESS in 10m 22s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/d0be73fdaadd40629600959c83dff79d : FAILURE in 7m 44s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/51029b4399f94cea888ff743378e026b : FAILURE in 7m 11s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/e77e845a060341ad99cdd2d9ea3fff78 : FAILURE in 10m 26s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/bd5b47a2cce64fd8a8c626c3d0d284ae : FAILURE in 8m 06s (non-voting)\n- placement-nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/a2bc14f038454f1e92affb06a36134b3 : SUCCESS in 18m 29s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/8fbc5b4c71e04a5c92d0608c2001fa07 : SUCCESS in 25m 57s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/8c3d4ad6aae047e69ca7554f67cc6b19 : SUCCESS in 11m 24s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/13e1330677a9467f99fbc5320d761d86 : SUCCESS in 51m 37s","accounts_in_message":[],"_revision_number":1},{"id":"e0f1702559133522fc90c11b3b4a27bc375b9746","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2021-07-27 17:28:35.000000000","message":"Uploaded patch set 2: Patch Set 1 was rebased.","accounts_in_message":[],"_revision_number":2},{"id":"9f171f03f87aef282c7b3d4d13113d54f7b99ff2","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-27 19:15:57.000000000","message":"Patch Set 2: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- grenade https://zuul.opendev.org/t/openstack/build/4b36ff7aa5a8482982335d6a578e49b8 : SUCCESS in 1h 08m 14s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/9b4b42c18856473885fa455a13c6c3fc : SUCCESS in 1h 14m 34s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/79b355601ca94a62b8cac55095ada6a2 : SUCCESS in 7m 16s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/0c133aff1bdb43b4845fc6c862150e54 : FAILURE in 9m 00s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/ff796dd98f054ea4bf82748d8b4d66fd : SUCCESS in 7m 46s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/0ed350184dbb4631bf4579633e65a432 : SUCCESS in 6m 12s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/9d6306b43a47424d96f800ea0613b008 : SUCCESS in 7m 09s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/4afb98d0d8e94b39b127c7afccbe1693 : SUCCESS in 7m 04s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/ee80ee8f6ba846b1a74d01e0f7ea1f62 : SUCCESS in 9m 10s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/141fdebb7b9e40efbd21317d871c30e0 : SUCCESS in 6m 20s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/87d89c3d81fe43f28d73c0c5911f4a93 : SUCCESS in 6m 22s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/af11e8b6716240bf9abe3e5a4c26349a : SUCCESS in 7m 35s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/45f43e341a294dc993a1166bcf73f438 : SUCCESS in 7m 13s (non-voting)\n- placement-nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/911519df4f254efa9288d6b713255b7e : SUCCESS in 15m 11s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/05debdecb8fd492b94fcdf95eaed2119 : SUCCESS in 29m 00s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/5653addd97e744d38ea56bb84bd0a234 : SUCCESS in 10m 43s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/ac420fffa1ca4153967730c5ee83683f : SUCCESS in 55m 42s","accounts_in_message":[],"_revision_number":2},{"id":"894bf3330b866296f8956048a6e90b913db09260","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2021-07-28 09:44:06.000000000","message":"Uploaded patch set 3: Patch Set 2 was rebased.","accounts_in_message":[],"_revision_number":3},{"id":"1356a701dd67a50f240d9cf78e256a110cebeb87","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-28 11:03:40.000000000","message":"Patch Set 3: Verified+1\n\nBuild succeeded (check pipeline).\n\n- grenade https://zuul.opendev.org/t/openstack/build/947e2c628cb04cbab4751e3950353b91 : SUCCESS in 58m 20s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/0cc680a411304d11b66d4107fcf2263c : SUCCESS in 1h 13m 06s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/bc302805fbcb4a79ab5cdd5d46f1a67b : SUCCESS in 8m 27s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/24699d55ee16430297b854be323656e2 : SUCCESS in 7m 14s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/1196c28d4ee74a9cad970409869a72a9 : SUCCESS in 7m 37s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/e1c35f0002b7444ea52c65728f471bfd : SUCCESS in 6m 06s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/74e01c8d89484353b889d4d58d44eaed : SUCCESS in 6m 48s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/4524036febff4c78b1369b70fa837897 : SUCCESS in 6m 13s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/7c80ffc4e94f45bfbc8fb95bf9fae0fa : SUCCESS in 9m 14s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/bb745393db4b453da5a330e20e8e5eb4 : SUCCESS in 5m 55s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/be4d70a2778c457abff2ec0587431191 : SUCCESS in 7m 09s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/64e330c133a047a684bd2debc498ed23 : SUCCESS in 7m 42s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/0f32f1a081c248e597ec5b0516e7732c : SUCCESS in 6m 41s (non-voting)\n- placement-nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/1ddb1edb9d5f47de87fc46dc0be4d3c0 : SUCCESS in 13m 37s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/a5e3d290013b469eb5563ca38c0eb046 : SUCCESS in 19m 31s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/de269a93fb3343cda4d1f61513c623c2 : SUCCESS in 9m 46s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/a515183fde8245d18ded8e3c302c8ac9 : SUCCESS in 46m 45s","accounts_in_message":[],"_revision_number":3},{"id":"5cce02f64c513a3a0588e3cef785b2fcdc8cde9b","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":9816,"name":"Takashi Kajinami","email":"kajinamit@oss.nttdata.com","username":"kajinamit"},"date":"2022-02-05 16:54:49.000000000","message":"Patch Set 4: Patch Set 3 was rebased","accounts_in_message":[],"_revision_number":4},{"id":"e2db8eb5268c628650c1eba9d289387a42d014dd","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":9816,"name":"Takashi Kajinami","email":"kajinamit@oss.nttdata.com","username":"kajinamit"},"date":"2022-02-05 17:00:57.000000000","message":"Uploaded patch set 5: Patch Set 4 was rebased.","accounts_in_message":[],"_revision_number":5},{"id":"0d3c42b4c846fe0df5585160dad40badd00a62be","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-02-05 18:16:26.000000000","message":"Patch Set 5: Verified+1\n\nBuild succeeded (check pipeline).\n\n- grenade https://zuul.opendev.org/t/openstack/build/34b0fe4b24c644af95c35192855c552a : SUCCESS in 54m 17s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/ed06ab1a425847cd905667e8c4e81fbd : SUCCESS in 1h 12m 36s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/450aa4241866499a9bd814869d2cabb7 : SUCCESS in 47m 48s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/6f7ab82e57324b6dad7101044d77dca8 : SUCCESS in 6m 26s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/08486b0a527441149b44d1b2f95272e3 : SUCCESS in 6m 05s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/3962f10c333f4cc099a62f455695b901 : SUCCESS in 5m 21s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/69dd042c1b5e4e9982ffced81a73c429 : SUCCESS in 5m 33s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/74a1ab6d84bc48f8a46566b1c60a2ae2 : SUCCESS in 6m 05s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/8c19b60f174b461fa1fd8985e52b37ef : SUCCESS in 8m 00s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/32f3b7f944f14d7ea0d9ab98635ec0a6 : SUCCESS in 5m 38s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/004cc4eac49740ba85d9da826959c4b4 : SUCCESS in 5m 53s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/63506d348bfd4f33b342777bd135ff9e : SUCCESS in 6m 13s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/8657ff03a66f4a1f82bd68e5466bd54a : SUCCESS in 7m 19s\n- placement-nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/a6edab30aeba4b5ea494489a0dc7bc76 : SUCCESS in 16m 05s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/2f7732bc07a845e6936ee6afee7f26ac : SUCCESS in 21m 57s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/ef9345dfe8684864b51f9e68287c098a : SUCCESS in 12m 32s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/aa17a94d3bea46af900843477b5f0721 : SUCCESS in 50m 50s","accounts_in_message":[],"_revision_number":5},{"id":"f74bc2dddcd2c1d20cec696bd9a8041378b76b0a","author":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"date":"2022-02-08 12:01:12.000000000","message":"Patch Set 5: Code-Review+2","accounts_in_message":[],"_revision_number":5},{"id":"cdb15a5c23160742cac76b2a928b565a5d6811c8","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2022-03-24 15:54:52.000000000","message":"Uploaded patch set 6: Patch Set 5 was rebased.","accounts_in_message":[],"_revision_number":6},{"id":"843b9f42b7a1a0cd5892825d893640a0556fa14c","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-03-24 17:18:22.000000000","message":"Patch Set 6: Verified+1\n\nBuild succeeded (check pipeline).\n\n- grenade https://zuul.opendev.org/t/openstack/build/bbbe0c431c974874ba61991590648036 : SUCCESS in 1h 11m 45s\n- grenade-skip-level https://zuul.opendev.org/t/openstack/build/398150ad96d44e8c9bbbaf0f7a1bdf1d : FAILURE in 34m 58s (non-voting)\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/f606b36d382440e8a28a55745a5e9a02 : SUCCESS in 1h 17m 58s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/b35d42d8b38340c5ae8f66b2771e36f7 : SUCCESS in 59m 54s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/14c2532d49eb4abba27696dd46c09f3a : SUCCESS in 8m 41s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/3be1a601fe87498aad8777cb09ae6246 : SUCCESS in 7m 53s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/931efb3978cc4873b5b1e0defb117fd4 : SUCCESS in 7m 30s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/9f80091ecfb2450ebf265ab3f377b9bb : SUCCESS in 7m 43s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/4375c3a4bd22469fbd9afc145f63a8a5 : SUCCESS in 7m 37s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/affca05b11514fa0b0cfb7f4a55610de : RETRY_LIMIT in 6m 02s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/2afb148f5873465f84e1ec7042256ff3 : SUCCESS in 9m 39s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/6c8f286e40fd4cc2b407a73c138edd24 : SUCCESS in 7m 55s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/cd117c038a1a4118932403efae9b7a8a : SUCCESS in 8m 20s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/16b8a1da01594865a2453e38b9a3f56e : SUCCESS in 10m 37s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/094bef26f4a6446990d0d66c785f5109 : SUCCESS in 9m 38s\n- placement-nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/abd109a84baa483cb255ffce7a21faf6 : SUCCESS in 20m 30s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/32c5580b21ac41b495d9052eb731a9dd : SUCCESS in 24m 14s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/dde7d2f3fe464e4d9d125d4a70e54e30 : SUCCESS in 11m 20s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/37ce43b7763f4b66a3c72b1405b8e2a3 : SUCCESS in 48m 22s","accounts_in_message":[],"_revision_number":6},{"id":"1d3ea74a70d58bc1bcea1469df03447d8a147ff7","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2022-04-07 14:40:56.000000000","message":"Uploaded patch set 7: Patch Set 6 was rebased.","accounts_in_message":[],"_revision_number":7},{"id":"a5486eb8d4f79b5c121a81ed4ab30c8c5e590e3d","author":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"date":"2022-04-07 14:56:55.000000000","message":"Patch Set 7: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":7},{"id":"eb7a73f0363dbefeda914fa2839ec89c11d23b17","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-07 16:09:52.000000000","message":"Patch Set 7: Verified+1\n\nBuild succeeded (check pipeline).\n\n- grenade https://zuul.opendev.org/t/openstack/build/26496e97ee694b8195f90c253fa51310 : SUCCESS in 1h 08m 27s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/fd14aea187ad477bb7c820a9789dce01 : SUCCESS in 1h 23m 18s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/d6e906070338470da4fed5d9a7242039 : SUCCESS in 52m 58s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/56bd05c834d04301926d8664ff1e3e7b : SUCCESS in 6m 44s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/8611590c9cb84cadba5b2c5effe42481 : SUCCESS in 7m 58s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/0b29dadc802a472da64ac05c037e8f57 : SUCCESS in 6m 11s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/7c603d71f6f1463880d6e314af326b98 : SUCCESS in 5m 45s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/1791fd28873c4f528ffb524ad58aa66e : SUCCESS in 6m 02s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/69536b7be5354568976aed0c15c125eb : RETRY_LIMIT in 4m 54s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/27297867380d449f9f51ec1cbad1464c : SUCCESS in 9m 10s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/c3e87d4eca524110b3ae4af5b5676ccc : SUCCESS in 6m 37s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/7a2037dda48d4a019fb386ddf5e7ccb6 : SUCCESS in 7m 17s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/c1c404681ee34d0dbd424f81c8aa5a8c : SUCCESS in 6m 13s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/527464952fd548ea9e154f6601ff497a : SUCCESS in 7m 24s\n- placement-nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/716c7f8399ee482aa976c7dcac165292 : SUCCESS in 18m 58s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/5a5f3ef87d3341f99d8498399e49a512 : SUCCESS in 23m 28s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/1308dc0bf4c84276a0e71a134399be35 : SUCCESS in 9m 09s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/a32c62b6c59442898f9d8cb5892d2e53 : SUCCESS in 52m 36s","accounts_in_message":[],"_revision_number":7},{"id":"8dc9f67c21fe759eb59f3e5e05363278003efad9","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-14 09:03:25.000000000","message":"Patch Set 7: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":7},{"id":"7ca8314d402c6708217ae94db4dbe35613e42182","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-14 10:32:47.000000000","message":"Patch Set 7: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- grenade https://zuul.opendev.org/t/openstack/build/582b4f7a1e9445b79cc89e308ae95e16 : SUCCESS in 1h 02m 34s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/8680d8c478b647d2b4151ae3fb435907 : SUCCESS in 1h 24m 57s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/e4feef465e71474b8495786a46a44732 : SUCCESS in 56m 36s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/f6faacf680e94800b4ad385769432d1b : SUCCESS in 7m 45s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/af0a8c544ccc49bc85e132cd1975a280 : SUCCESS in 5m 55s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/8be675569e1941e0878fe192173a758d : SUCCESS in 6m 10s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/740c864f5bb542748de2432b91ea24d1 : SUCCESS in 6m 15s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/ba26d2f2839a4e2ea74a7b4a99f84d31 : SUCCESS in 8m 20s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/fcddffe7bc984f1c9efbb710274ae720 : SUCCESS in 6m 28s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/1317067c23be48a394155750d1610ab1 : SUCCESS in 6m 53s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/bf56660f0eaf4e8cafb85fb74304ac7c : SUCCESS in 6m 31s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/45c08d4ded244414bfd7f20bc4af06da : SUCCESS in 6m 57s\n- placement-nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/d4da8dca26324a08b1f8b594494ca218 : SUCCESS in 17m 24s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/ee50c72d9a0a4f60bf397d031b21b741 : SUCCESS in 54m 52s","accounts_in_message":[],"_revision_number":7},{"id":"96a8429584750689505f37159137038e4616ca2a","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-14 10:32:47.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":7},{"id":"d5b339021f49315f365c4efedb7ccd53f7f971eb","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-14 10:34:36.000000000","message":"Patch Set 7:\n\nBuild succeeded (promote pipeline).\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/8f9ea2423c814068845d05414b300d97 : SUCCESS in 1m 18s","accounts_in_message":[],"_revision_number":7}],"current_revision_number":7,"current_revision":"932988e8bf546834c10e9b33c83ddc56c01d8ef4","revisions":{"571a5c181b29db013aa869c69a380dd66dcdfd0b":{"kind":"REWORK","_number":1,"created":"2021-07-16 16:50:39.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"ref":"refs/changes/00/801100/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/00/801100/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/00/801100/1"}}},"commit":{"parents":[{"commit":"97d5249b786cbbad57c13efdb08a453e1153dc53","subject":"db: Replace implicit conversion of SELECT into FROM","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/97d5249b786cbbad57c13efdb08a453e1153dc53"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-15 10:54:58.000000000","tz":60},"committer":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-16 16:35:48.000000000","tz":60},"subject":"db: Replace \u0027as_scalar()\u0027 with \u0027scalar_subquery()\u0027","message":"db: Replace \u0027as_scalar()\u0027 with \u0027scalar_subquery()\u0027\n\nResolve another deprecation warning for a feature being removed in\nSQLAlchemy 2.0.\n\n  SADeprecationWarning: The SelectBase.as_scalar() method is deprecated\n  and will be removed in a future release.  Please refer to\n  SelectBase.scalar_subquery(). (deprecated since: 1.4)\n\nChange-Id: Ia62493017758db218a57c3e48a7b4dbe9c5494ee\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/571a5c181b29db013aa869c69a380dd66dcdfd0b"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/571a5c181b29db013aa869c69a380dd66dcdfd0b"}]},"branch":"refs/heads/master"},"8b59cc36699e2610d1ac32b2a6cb9a4edfc3f190":{"kind":"TRIVIAL_REBASE","_number":2,"created":"2021-07-27 17:28:35.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"ref":"refs/changes/00/801100/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/00/801100/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/00/801100/2"}}},"commit":{"parents":[{"commit":"092dd108b880acc8d272b66d1a1c58e06ebf02cf","subject":"db: Replace implicit conversion of SELECT into FROM","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/092dd108b880acc8d272b66d1a1c58e06ebf02cf"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-15 10:54:58.000000000","tz":60},"committer":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-27 17:19:41.000000000","tz":60},"subject":"db: Replace \u0027as_scalar()\u0027 with \u0027scalar_subquery()\u0027","message":"db: Replace \u0027as_scalar()\u0027 with \u0027scalar_subquery()\u0027\n\nResolve another deprecation warning for a feature being removed in\nSQLAlchemy 2.0.\n\n  SADeprecationWarning: The SelectBase.as_scalar() method is deprecated\n  and will be removed in a future release.  Please refer to\n  SelectBase.scalar_subquery(). (deprecated since: 1.4)\n\nChange-Id: Ia62493017758db218a57c3e48a7b4dbe9c5494ee\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/8b59cc36699e2610d1ac32b2a6cb9a4edfc3f190"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/8b59cc36699e2610d1ac32b2a6cb9a4edfc3f190"}]},"branch":"refs/heads/master"},"7b086ee3781f817d6b067113ea695bc147a20d6e":{"kind":"TRIVIAL_REBASE","_number":3,"created":"2021-07-28 09:44:06.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"ref":"refs/changes/00/801100/3","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/00/801100/3","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/3 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/3 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/3 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/00/801100/3"}}},"commit":{"parents":[{"commit":"ee5f08b1a0d2b22abf56cdfdbd91517f8cc31c88","subject":"db: Replace implicit conversion of SELECT into FROM","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/ee5f08b1a0d2b22abf56cdfdbd91517f8cc31c88"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-15 10:54:58.000000000","tz":60},"committer":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-28 09:43:57.000000000","tz":60},"subject":"db: Replace \u0027as_scalar()\u0027 with \u0027scalar_subquery()\u0027","message":"db: Replace \u0027as_scalar()\u0027 with \u0027scalar_subquery()\u0027\n\nResolve another deprecation warning for a feature being removed in\nSQLAlchemy 2.0.\n\n  SADeprecationWarning: The SelectBase.as_scalar() method is deprecated\n  and will be removed in a future release.  Please refer to\n  SelectBase.scalar_subquery(). (deprecated since: 1.4)\n\nChange-Id: Ia62493017758db218a57c3e48a7b4dbe9c5494ee\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/7b086ee3781f817d6b067113ea695bc147a20d6e"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/7b086ee3781f817d6b067113ea695bc147a20d6e"}]},"branch":"refs/heads/master"},"3e0e29ba964b81cb947b35322074eb33688baf64":{"kind":"TRIVIAL_REBASE","_number":4,"created":"2022-02-05 16:54:49.000000000","uploader":{"_account_id":9816,"name":"Takashi Kajinami","email":"kajinamit@oss.nttdata.com","username":"kajinamit"},"ref":"refs/changes/00/801100/4","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/00/801100/4","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/4 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/4 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/4 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/00/801100/4"}}},"commit":{"parents":[{"commit":"a3200cae7812a788d1564254b61db390ae723098","subject":"db: Replace implicit conversion of SELECT into FROM","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/a3200cae7812a788d1564254b61db390ae723098"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-15 10:54:58.000000000","tz":60},"committer":{"name":"Takashi Kajinami","email":"tkajinam@redhat.com","date":"2022-02-05 16:54:49.000000000","tz":0},"subject":"db: Replace \u0027as_scalar()\u0027 with \u0027scalar_subquery()\u0027","message":"db: Replace \u0027as_scalar()\u0027 with \u0027scalar_subquery()\u0027\n\nResolve another deprecation warning for a feature being removed in\nSQLAlchemy 2.0.\n\n  SADeprecationWarning: The SelectBase.as_scalar() method is deprecated\n  and will be removed in a future release.  Please refer to\n  SelectBase.scalar_subquery(). (deprecated since: 1.4)\n\nChange-Id: Ia62493017758db218a57c3e48a7b4dbe9c5494ee\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/3e0e29ba964b81cb947b35322074eb33688baf64"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/3e0e29ba964b81cb947b35322074eb33688baf64"}]},"branch":"refs/heads/master","description":"Rebase"},"9fcdcd9b3a2a76cc5674fbbf74cc2bc7e91ed475":{"kind":"TRIVIAL_REBASE","_number":5,"created":"2022-02-05 17:00:57.000000000","uploader":{"_account_id":9816,"name":"Takashi Kajinami","email":"kajinamit@oss.nttdata.com","username":"kajinamit"},"ref":"refs/changes/00/801100/5","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/00/801100/5","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/5 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/5 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/5 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/00/801100/5"}}},"commit":{"parents":[{"commit":"c492f9cc52337884390edd663d38cf1ad1da8ff4","subject":"db: Replace implicit conversion of SELECT into FROM","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/c492f9cc52337884390edd663d38cf1ad1da8ff4"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-15 10:54:58.000000000","tz":60},"committer":{"name":"Takashi Kajinami","email":"tkajinam@redhat.com","date":"2022-02-05 17:00:06.000000000","tz":540},"subject":"db: Replace \u0027as_scalar()\u0027 with \u0027scalar_subquery()\u0027","message":"db: Replace \u0027as_scalar()\u0027 with \u0027scalar_subquery()\u0027\n\nResolve another deprecation warning for a feature being removed in\nSQLAlchemy 2.0.\n\n  SADeprecationWarning: The SelectBase.as_scalar() method is deprecated\n  and will be removed in a future release.  Please refer to\n  SelectBase.scalar_subquery(). (deprecated since: 1.4)\n\nChange-Id: Ia62493017758db218a57c3e48a7b4dbe9c5494ee\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/9fcdcd9b3a2a76cc5674fbbf74cc2bc7e91ed475"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/9fcdcd9b3a2a76cc5674fbbf74cc2bc7e91ed475"}]},"branch":"refs/heads/master"},"0eeaf46b4853f0fb576a0a108d768cb668005777":{"kind":"TRIVIAL_REBASE","_number":6,"created":"2022-03-24 15:54:52.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"ref":"refs/changes/00/801100/6","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/00/801100/6","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/6 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/6 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/6 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/00/801100/6"}}},"commit":{"parents":[{"commit":"e130eea3827bb48cd35c115f5fb3026b266848c7","subject":"db: Replace implicit conversion of SELECT into FROM","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/e130eea3827bb48cd35c115f5fb3026b266848c7"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-15 10:54:58.000000000","tz":60},"committer":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2022-03-24 15:41:42.000000000","tz":0},"subject":"db: Replace \u0027as_scalar()\u0027 with \u0027scalar_subquery()\u0027","message":"db: Replace \u0027as_scalar()\u0027 with \u0027scalar_subquery()\u0027\n\nResolve another deprecation warning for a feature being removed in\nSQLAlchemy 2.0.\n\n  SADeprecationWarning: The SelectBase.as_scalar() method is deprecated\n  and will be removed in a future release.  Please refer to\n  SelectBase.scalar_subquery(). (deprecated since: 1.4)\n\nChange-Id: Ia62493017758db218a57c3e48a7b4dbe9c5494ee\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/0eeaf46b4853f0fb576a0a108d768cb668005777"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/0eeaf46b4853f0fb576a0a108d768cb668005777"}]},"branch":"refs/heads/master"},"932988e8bf546834c10e9b33c83ddc56c01d8ef4":{"kind":"TRIVIAL_REBASE","_number":7,"created":"2022-04-07 14:40:56.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"ref":"refs/changes/00/801100/7","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/00/801100/7","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/7 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/7 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/00/801100/7 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/00/801100/7"}}},"commit":{"parents":[{"commit":"5a97e855f595bd0f2d4b1d493e06b1124b81757e","subject":"db: Replace implicit conversion of SELECT into FROM","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/5a97e855f595bd0f2d4b1d493e06b1124b81757e"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-15 10:54:58.000000000","tz":60},"committer":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2022-04-07 14:31:53.000000000","tz":60},"subject":"db: Replace \u0027as_scalar()\u0027 with \u0027scalar_subquery()\u0027","message":"db: Replace \u0027as_scalar()\u0027 with \u0027scalar_subquery()\u0027\n\nResolve another deprecation warning for a feature being removed in\nSQLAlchemy 2.0.\n\n  SADeprecationWarning: The SelectBase.as_scalar() method is deprecated\n  and will be removed in a future release.  Please refer to\n  SelectBase.scalar_subquery(). (deprecated since: 1.4)\n\nChange-Id: Ia62493017758db218a57c3e48a7b4dbe9c5494ee\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/932988e8bf546834c10e9b33c83ddc56c01d8ef4"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/932988e8bf546834c10e9b33c83ddc56c01d8ef4"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[{"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":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"}},{"label":"Workflow","status":"OK","applied_by":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"}},{"label":"Review-Priority","status":"MAY"}]}],"submit_requirements":[{"name":"Verified","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Verified\u003dCustom-Rule","fulfilled":true,"status":"PASS","passing_atoms":["label:Verified\u003dCustom-Rule"],"failing_atoms":[],"atom_explanations":{}}},{"name":"Workflow","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Workflow\u003dCustom-Rule","fulfilled":true,"status":"PASS","passing_atoms":["label:Workflow\u003dCustom-Rule"],"failing_atoms":[],"atom_explanations":{}}},{"name":"Code-Review","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Code-Review\u003dCustom-Rule","fulfilled":true,"status":"PASS","passing_atoms":["label:Code-Review\u003dCustom-Rule"],"failing_atoms":[],"atom_explanations":{}}}]}