)]}'
{"id":"openstack%2Faodh~896096","triplet_id":"openstack%2Faodh~master~I46f3277ea17e814e7b631750b2739f25e4395e22","project":"openstack/aodh","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":"2024-03-13 17:51:50.000000000","reason":"Change was submitted"}},"hashtags":[],"change_id":"I46f3277ea17e814e7b631750b2739f25e4395e22","subject":"db: Replace use of Engine.execute() method","status":"MERGED","created":"2023-09-21 13:18:49.000000000","updated":"2024-03-13 17:53:26.000000000","submitted":"2024-03-13 17:51:50.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":2,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"896096-sqlalchemy-20","meta_rev_id":"a374a8240ff1c017818abba9ce63a56383f5f946","_number":896096,"virtual_id_number":896096,"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":5202,"name":"Erno Kuvaja","email":"jokke@usr.fi","username":"jokke"},{"value":0,"_account_id":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2024-03-13 17:51:50.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":5202,"name":"Erno Kuvaja","email":"jokke@usr.fi","username":"jokke"},"all":[{"value":2,"date":"2024-03-13 16:28:32.000000000","_account_id":5202,"name":"Erno Kuvaja","email":"jokke@usr.fi","username":"jokke"},{"value":2,"date":"2024-03-13 16:30:08.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},{"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":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},"all":[{"value":0,"_account_id":5202,"name":"Erno Kuvaja","email":"jokke@usr.fi","username":"jokke"},{"value":1,"date":"2024-03-13 16:30:13.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},{"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":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},{"_account_id":5202,"name":"Erno Kuvaja","email":"jokke@usr.fi","username":"jokke"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2023-09-21 14:27:51.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":"2024-03-11 15:08:19.000000000","updated_by":{"_account_id":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},"reviewer":{"_account_id":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},"state":"CC"},{"updated":"2024-03-13 16:28:32.000000000","updated_by":{"_account_id":5202,"name":"Erno Kuvaja","email":"jokke@usr.fi","username":"jokke"},"reviewer":{"_account_id":5202,"name":"Erno Kuvaja","email":"jokke@usr.fi","username":"jokke"},"state":"REVIEWER"},{"updated":"2024-03-13 16:30:08.000000000","updated_by":{"_account_id":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},"reviewer":{"_account_id":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},"state":"REVIEWER"}],"messages":[{"id":"b48aa69c77ca087d7043478fb4dd54fd259f64ea","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2023-09-21 13:18:49.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"34ddb49178fa7c523877a7049a2f36eff9c25f42","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-21 14:27:51.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\nhttps://zuul.opendev.org/t/openstack/buildset/653befd99a9c4fcbbd6599272334a96a\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/f5450523e33d49c6ab8c15fda8982766 : SUCCESS in 4m 32s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/331a0513cde4466fbdd63a3aa9869ebb : SUCCESS in 7m 20s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/4ea6671ec3ad4582ba6fdb507eddf973 : TIMED_OUT in 41m 07s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/9b4b8104704c41258616b6a819ca6fff : SUCCESS in 7m 48s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/632252a2171844bfacd03c6d320e325d : RETRY_LIMIT in 2m 36s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/39461fa5c1834a8b96ef6ee0bb36c8b1 : FAILURE in 5m 31s\n- aodh-tempest-plugin-mysql https://zuul.opendev.org/t/openstack/build/4ece224d852d4b5da0aae08c7e8f3f4d : FAILURE in 20m 45s\n- aodh-tempest-plugin-postgresql https://zuul.opendev.org/t/openstack/build/306f5c1760f946cebb23ecec4a0d881f : FAILURE in 40m 10s\n- telemetry-dsvm-integration https://zuul.opendev.org/t/openstack/build/62f287a1565f435aa33c83ed3c3e6914 : FAILURE in 35m 30s\n- telemetry-dsvm-integration-ipv6-only https://zuul.opendev.org/t/openstack/build/c9b0b49f1cfe404387e2288926a49175 : FAILURE in 23m 31s\n- telemetry-dsvm-integration-centos-9s https://zuul.opendev.org/t/openstack/build/0170fcd24bc34da7a1955f06eaa98e89 : SUCCESS in 55m 57s\n- telemetry-dsvm-integration-centos-9s-fips https://zuul.opendev.org/t/openstack/build/ac12ba02cc4c406d8e48a8bd9237de7f : SUCCESS in 1h 03m 07s","accounts_in_message":[],"_revision_number":1},{"id":"a2fa59b3834e3c06b64bef41b3af1b14e644a948","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2023-09-22 11:48:57.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"47edebdd8924adb0b8d2d284b0f05d9ce5b384af","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-22 13:01:19.000000000","message":"Patch Set 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\nhttps://zuul.opendev.org/t/openstack/buildset/5f94edc3cc254a3397a34670d3cb0b0c\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/516e533107434b7dbd3d75694979c565 : SUCCESS in 4m 55s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/d3c849ff59374a95aaace3655ab8016c : SUCCESS in 6m 47s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/3fa9052752d64a07938587f559db554e : SUCCESS in 8m 07s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/8c07257ae3024b7b8859f89a89c33e50 : SUCCESS in 7m 38s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/5846ead1912444048e33fe921fa704d9 : RETRY_LIMIT in 2m 10s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/78565b5cf0544e4da1bca6e1e77dd49b : SUCCESS in 9m 07s\n- aodh-tempest-plugin-mysql https://zuul.opendev.org/t/openstack/build/9cc86231de7d45c9a072cc49ee89c106 : FAILURE in 37m 22s\n- aodh-tempest-plugin-postgresql https://zuul.opendev.org/t/openstack/build/aec4e8770bc04ec684b382503c0295bd : FAILURE in 40m 00s\n- telemetry-dsvm-integration https://zuul.opendev.org/t/openstack/build/06be214ec1014a2f8c855b4a3629873e : FAILURE in 36m 31s\n- telemetry-dsvm-integration-ipv6-only https://zuul.opendev.org/t/openstack/build/635515c34bd845f5a69e2823b49efd19 : FAILURE in 35m 30s\n- telemetry-dsvm-integration-centos-9s https://zuul.opendev.org/t/openstack/build/31e3bab5191c438dbedbd07ae6854fce : SUCCESS in 1h 01m 07s\n- telemetry-dsvm-integration-centos-9s-fips https://zuul.opendev.org/t/openstack/build/eb5b24c1ed4b4c108b2b805e249f5afc : SUCCESS in 1h 07m 07s","accounts_in_message":[],"_revision_number":1},{"id":"5eb6cace425e24a9cb8c8e3beffbe081b4b1be26","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2023-11-16 14:53:11.000000000","message":"Uploaded patch set 2: Patch Set 1 was rebased.\n\nOutdated Votes:\n* Verified-1\n","accounts_in_message":[],"_revision_number":2},{"id":"d8455e3a5a4bb3100d579513853784b1d81c308b","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-11-16 16:17:19.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/0edb2533e27749169b6b15c2bb4831df\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/9577c902474f4f64bf48787e9664dde9 : SUCCESS in 4m 09s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/54f619feb06c47aa8042dba2e4f52233 : SUCCESS in 7m 18s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/808c9a76a7454b23a4140c8a3e11286f : SUCCESS in 7m 41s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/2a41f5139b004721a8290d431591bc3f : SUCCESS in 7m 40s\n- aodh-tempest-plugin-mysql https://zuul.opendev.org/t/openstack/build/7f4c4649ea87489d8759f74345dec510 : SUCCESS in 53m 10s\n- aodh-tempest-plugin-postgresql https://zuul.opendev.org/t/openstack/build/c5f1e42a9540415ba69f0a77bd5bc9f8 : SUCCESS in 43m 59s\n- telemetry-dsvm-integration https://zuul.opendev.org/t/openstack/build/656de33bf7ea4a3f9fcbf8d54623cc3a : SUCCESS in 1h 03m 12s\n- telemetry-dsvm-integration-ipv6-only https://zuul.opendev.org/t/openstack/build/38cbcaa300c8475ea8a40f6439fe57f4 : SUCCESS in 54m 43s\n- telemetry-dsvm-integration-centos-9s https://zuul.opendev.org/t/openstack/build/4d951b07d1c846c28402935cac179d24 : SUCCESS in 1h 05m 47s\n- telemetry-dsvm-integration-centos-9s-fips https://zuul.opendev.org/t/openstack/build/9de45e6a61b947f9aff6b4d70f416756 : SUCCESS in 1h 15m 05s","accounts_in_message":[],"_revision_number":2},{"id":"9a918ae052a6fcf7b2e20d5873253474bd720740","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"real_author":{"_account_id":9816,"name":"Takashi Kajinami","email":"kajinamit@oss.nttdata.com","username":"kajinamit"},"date":"2024-03-11 13:58:49.000000000","message":"Patch Set 3: Patch Set 2 was rebased on behalf of \u003cGERRIT_ACCOUNT_15334\u003e\n\nOutdated Votes:\n* Verified+1\n","accounts_in_message":[{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"}],"_revision_number":3},{"id":"0941363a4b0eb4c10e60fafde1977f72423a4eda","author":{"_account_id":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},"date":"2024-03-11 15:08:19.000000000","message":"Patch Set 3:\n\n(1 comment)","accounts_in_message":[],"_revision_number":3},{"id":"76263a9e402183d46c56ce962951e773f0b72f36","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2024-03-11 15:12:43.000000000","message":"Patch Set 3: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/1a9cbe9db6b147ae8c247f9b42aaf3e9\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/d4943b39b8054dd1a01673ce629242f1 : SUCCESS in 5m 31s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/fc34af2996d44416b4ab0be1cacd6d9c : SUCCESS in 4m 46s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/10fa15c55ad543cf8a9aa91689a665bb : SUCCESS in 5m 22s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/c4c4f0e0bc6946b98d6de0ea511a5217 : SUCCESS in 6m 50s\n- aodh-tempest-plugin-mysql https://zuul.opendev.org/t/openstack/build/fc4d4194d6f04265ac5837f25d3d65f9 : SUCCESS in 50m 14s\n- aodh-tempest-plugin-postgresql https://zuul.opendev.org/t/openstack/build/2c5cd8f1e1ad4976a66931185a79a398 : SUCCESS in 45m 29s\n- telemetry-dsvm-integration https://zuul.opendev.org/t/openstack/build/ba727701cda643c883a34e48badf12cb : SUCCESS in 55m 11s\n- telemetry-dsvm-integration-ipv6-only https://zuul.opendev.org/t/openstack/build/40c65ea2e595488b96f2ec3a90b9d68f : SUCCESS in 56m 42s\n- telemetry-dsvm-integration-centos-9s https://zuul.opendev.org/t/openstack/build/258d31f3a3a046199dfbcab9c215adf9 : FAILURE in 21m 33s (non-voting)\n- telemetry-dsvm-integration-centos-9s-fips https://zuul.opendev.org/t/openstack/build/d8803861b4cc4b5f9c5c40a09bc90684 : SUCCESS in 1h 07m 58s (non-voting)","accounts_in_message":[],"_revision_number":3},{"id":"bfe418e34c16d12afbbca099b01851a1c1c34986","author":{"_account_id":5202,"name":"Erno Kuvaja","email":"jokke@usr.fi","username":"jokke"},"date":"2024-03-13 16:28:32.000000000","message":"Patch Set 3: Code-Review+2","accounts_in_message":[],"_revision_number":3},{"id":"b4c42ca9d91a090ab0e4190b96deb6a167724418","author":{"_account_id":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},"date":"2024-03-13 16:30:08.000000000","message":"Patch Set 3: Code-Review+2","accounts_in_message":[],"_revision_number":3},{"id":"41b33137333bce4f203ed76684ac83d3565f79da","author":{"_account_id":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"},"date":"2024-03-13 16:30:13.000000000","message":"Patch Set 3: Workflow+1","accounts_in_message":[],"_revision_number":3},{"id":"89c99d1cfc38664eeb570e80ebfccc3425574a57","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2024-03-13 16:32:32.000000000","message":"Patch Set 3: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":3},{"id":"8ab352e80c7be9fbaa64cca4e58b2388ed51ec07","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2024-03-13 17:51:50.000000000","message":"Patch Set 3: Verified+2\n\nBuild succeeded (gate pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/b53f5dba796e4aa6b1f958799f9fa2e0\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/fe5fe58c39104290b59fc987011dc983 : SUCCESS in 4m 43s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/c9962a60cacb4fb3b4abb1ea59669a65 : SUCCESS in 4m 53s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/ad10161c29624f51ad9b7c5f4e52fc52 : SUCCESS in 5m 31s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/fe46a19e79e844ed9b4313f18cc8a980 : SUCCESS in 7m 03s\n- aodh-tempest-plugin-mysql https://zuul.opendev.org/t/openstack/build/34599c074beb4d1bb3c72b42f4ab95cf : SUCCESS in 46m 25s\n- aodh-tempest-plugin-postgresql https://zuul.opendev.org/t/openstack/build/6f4207ee1a484f57a8575aa18b4adc67 : SUCCESS in 1h 18m 51s\n- telemetry-dsvm-integration https://zuul.opendev.org/t/openstack/build/6fbb1e01368b45a5b1e2812606860353 : SUCCESS in 49m 30s\n- telemetry-dsvm-integration-ipv6-only https://zuul.opendev.org/t/openstack/build/2669ad773967476688a981e63150cf87 : SUCCESS in 43m 55s\n- telemetry-dsvm-integration-centos-9s https://zuul.opendev.org/t/openstack/build/bf299e8fa4034e34beac962fe74f3f12 : SUCCESS in 51m 21s (non-voting)\n- telemetry-dsvm-integration-centos-9s-fips https://zuul.opendev.org/t/openstack/build/1298693182ff443291ec0c6f4830e3bf : SUCCESS in 59m 11s (non-voting)","accounts_in_message":[],"_revision_number":3},{"id":"12426986cb27e644ac0442fd32151672cace1969","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2024-03-13 17:51:50.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":3},{"id":"a374a8240ff1c017818abba9ce63a56383f5f946","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2024-03-13 17:53:26.000000000","message":"Patch Set 3:\n\nBuild succeeded (promote pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/0f5beac3e4b24c549c0813f9e31cc143\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/88faf5444bdc48f596ad3c7421d3d248 : SUCCESS in 38s","accounts_in_message":[],"_revision_number":3}],"current_revision_number":3,"current_revision":"947c7b4ffddd693382c89e48db264d1cf508d96c","revisions":{"e44a5a389a35c447685c9a41c01812572ac27715":{"kind":"REWORK","_number":1,"created":"2023-09-21 13:18:49.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"ref":"refs/changes/96/896096/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/aodh","ref":"refs/changes/96/896096/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/aodh refs/changes/96/896096/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/aodh refs/changes/96/896096/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/aodh refs/changes/96/896096/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/aodh refs/changes/96/896096/1"}}},"commit":{"parents":[{"commit":"c8697de7249c2e148c0426e839aff7ac9d829067","subject":"tests: Enable SQLAlchemy 2.0 deprecation warnings","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/aodh/commit/c8697de7249c2e148c0426e839aff7ac9d829067"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2023-09-21 12:42:45.000000000","tz":60},"committer":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2023-09-21 13:01:38.000000000","tz":60},"subject":"db: Replace use of Engine.execute() method","message":"db: Replace use of Engine.execute() method\n\nResolve the following RemovedIn20Warning warning:\n\n  The Engine.execute() method is considered legacy as of the 1.x\n  series of SQLAlchemy and will be removed in 2.0.\n\nThis also allows us to resolve the following RemovedIn20Warning warning:\n\n  The current statement is being autocommitted using implicit\n  autocommit, which will be removed in SQLAlchemy 2.0. Use the .begin()\n  method of Engine or Connection in order to use an explicit transaction\n  for DML and DDL statements.\n\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\nChange-Id: I46f3277ea17e814e7b631750b2739f25e4395e22\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/aodh/commit/e44a5a389a35c447685c9a41c01812572ac27715"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/aodh/commit/e44a5a389a35c447685c9a41c01812572ac27715"}]},"branch":"refs/heads/master"},"aedaeae3667b847671193d2c248326cc0d87f5fd":{"kind":"TRIVIAL_REBASE","_number":2,"created":"2023-11-16 14:53:11.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"ref":"refs/changes/96/896096/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/aodh","ref":"refs/changes/96/896096/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/aodh refs/changes/96/896096/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/aodh refs/changes/96/896096/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/aodh refs/changes/96/896096/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/aodh refs/changes/96/896096/2"}}},"commit":{"parents":[{"commit":"57579dca46951c6f7549a82d0e77c3f9f5b06d85","subject":"tests: Enable SQLAlchemy 2.0 deprecation warnings","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/aodh/commit/57579dca46951c6f7549a82d0e77c3f9f5b06d85"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2023-09-21 12:42:45.000000000","tz":60},"committer":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2023-11-16 14:52:35.000000000","tz":0},"subject":"db: Replace use of Engine.execute() method","message":"db: Replace use of Engine.execute() method\n\nResolve the following RemovedIn20Warning warning:\n\n  The Engine.execute() method is considered legacy as of the 1.x\n  series of SQLAlchemy and will be removed in 2.0.\n\nThis also allows us to resolve the following RemovedIn20Warning warning:\n\n  The current statement is being autocommitted using implicit\n  autocommit, which will be removed in SQLAlchemy 2.0. Use the .begin()\n  method of Engine or Connection in order to use an explicit transaction\n  for DML and DDL statements.\n\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\nChange-Id: I46f3277ea17e814e7b631750b2739f25e4395e22\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/aodh/commit/aedaeae3667b847671193d2c248326cc0d87f5fd"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/aodh/commit/aedaeae3667b847671193d2c248326cc0d87f5fd"}]},"branch":"refs/heads/master"},"947c7b4ffddd693382c89e48db264d1cf508d96c":{"kind":"TRIVIAL_REBASE","_number":3,"created":"2024-03-11 13:58:49.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"real_uploader":{"_account_id":9816,"name":"Takashi Kajinami","email":"kajinamit@oss.nttdata.com","username":"kajinamit"},"ref":"refs/changes/96/896096/3","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/aodh","ref":"refs/changes/96/896096/3","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/aodh refs/changes/96/896096/3 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/aodh refs/changes/96/896096/3 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/aodh refs/changes/96/896096/3 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/aodh refs/changes/96/896096/3"}}},"commit":{"parents":[{"commit":"9a66301aef981c4090f41cdfd585355647370565","subject":"tests: Enable SQLAlchemy 2.0 deprecation warnings","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/aodh/commit/9a66301aef981c4090f41cdfd585355647370565"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2023-09-21 12:42:45.000000000","tz":60},"committer":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2024-03-11 13:58:49.000000000","tz":0},"subject":"db: Replace use of Engine.execute() method","message":"db: Replace use of Engine.execute() method\n\nResolve the following RemovedIn20Warning warning:\n\n  The Engine.execute() method is considered legacy as of the 1.x\n  series of SQLAlchemy and will be removed in 2.0.\n\nThis also allows us to resolve the following RemovedIn20Warning warning:\n\n  The current statement is being autocommitted using implicit\n  autocommit, which will be removed in SQLAlchemy 2.0. Use the .begin()\n  method of Engine or Connection in order to use an explicit transaction\n  for DML and DDL statements.\n\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\nChange-Id: I46f3277ea17e814e7b631750b2739f25e4395e22\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/aodh/commit/947c7b4ffddd693382c89e48db264d1cf508d96c"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/aodh/commit/947c7b4ffddd693382c89e48db264d1cf508d96c"}]},"branch":"refs/heads/master","description":"Rebase"}},"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":5202,"name":"Erno Kuvaja","email":"jokke@usr.fi","username":"jokke"}},{"label":"Workflow","status":"MAY","applied_by":{"_account_id":4264,"name":"Matthias Runge","email":"mrunge@redhat.com","username":"mrunge"}}]}],"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":{}}}]}