)]}'
{"id":"openstack%2Fplacement~675302","triplet_id":"openstack%2Fplacement~master~Iefbb38f1f328b4d7a51cfec360c81369a977461e","project":"openstack/placement","branch":"master","topic":"cd/usages-bindparam","hashtags":[],"change_id":"Iefbb38f1f328b4d7a51cfec360c81369a977461e","subject":"Correct SQL docstring on _get_usages_by_provider_trees","status":"MERGED","created":"2019-08-08 11:43:24.000000000","updated":"2019-08-09 03:40:47.000000000","submitted":"2019-08-09 03:40:46.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":"675302-1565322047131-92a0a85e","meta_rev_id":"dca05a6ad4b3d790ec9f9acf3e0c60712c5c030c","_number":675302,"virtual_id_number":675302,"owner":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":2,"date":"2019-08-09 03:40:46.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"},{"value":0,"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"}],"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":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"},"all":[{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":2,"date":"2019-08-09 01:58:28.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"},{"value":2,"date":"2019-08-08 14:55:13.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"}],"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":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"},"all":[{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":1,"date":"2019-08-09 01:58:28.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"},{"value":0,"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"}],"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":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"},{"value":0,"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"}],"values":{" 0":"Default Priority","+1":"Contributor Review Promise","+2":"Core Review Promise"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2019-08-08 14:55:13.000000000","updated_by":{"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},"reviewer":{"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},"state":"REVIEWER"},{"updated":"2019-08-09 01:58:28.000000000","updated_by":{"_account_id":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"},"reviewer":{"_account_id":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"},"state":"REVIEWER"},{"updated":"2019-08-09 03:40:46.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"}],"messages":[{"id":"5bee6b76d47d0db12f3a201e04f5a72a1557d8eb","author":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"date":"2019-08-08 11:43:24.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"abe59540990516b50467e30d6dfdb0e5dd49e9e1","author":{"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},"date":"2019-08-08 14:55:13.000000000","message":"Patch Set 1: Code-Review+2","accounts_in_message":[],"_revision_number":1},{"id":"1208d31967ead8e25934d0a176ad8bb681328140","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-08-08 15:08:37.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- grenade-py3 https://logs.opendev.org/02/675302/1/check/grenade-py3/7bce904/ : SUCCESS in 1h 16m 57s\n- tempest-integrated-placement https://logs.opendev.org/02/675302/1/check/tempest-integrated-placement/f392e65/ : SUCCESS in 1h 25m 28s\n- openstack-tox-docs https://logs.opendev.org/02/675302/1/check/openstack-tox-docs/5716dac/html/ : SUCCESS in 5m 07s\n- openstack-tox-cover https://logs.opendev.org/02/675302/1/check/openstack-tox-cover/1c71f32/cover/ : SUCCESS in 8m 32s\n- openstack-tox-lower-constraints https://logs.opendev.org/02/675302/1/check/openstack-tox-lower-constraints/ee7a808/ : SUCCESS in 5m 13s\n- openstack-tox-pep8 https://logs.opendev.org/02/675302/1/check/openstack-tox-pep8/b9a7a84/ : SUCCESS in 6m 23s\n- openstack-tox-py27 https://logs.opendev.org/02/675302/1/check/openstack-tox-py27/d8c14b8/ : SUCCESS in 6m 35s\n- openstack-tox-py36 https://logs.opendev.org/02/675302/1/check/openstack-tox-py36/7dff704/ : SUCCESS in 4m 17s\n- openstack-tox-py37 https://logs.opendev.org/02/675302/1/check/openstack-tox-py37/b0e0f7b/ : SUCCESS in 6m 33s\n- openstack-tox-functional https://logs.opendev.org/02/675302/1/check/openstack-tox-functional/b6df82e/ : SUCCESS in 5m 15s\n- openstack-tox-functional-py36 https://logs.opendev.org/02/675302/1/check/openstack-tox-functional-py36/436e895/ : SUCCESS in 4m 58s\n- openstack-tox-functional-py37 https://logs.opendev.org/02/675302/1/check/openstack-tox-functional-py37/4b95a2d/ : SUCCESS in 6m 23s\n- placement-nova-tox-functional-py37 https://logs.opendev.org/02/675302/1/check/placement-nova-tox-functional-py37/75694f0/ : SUCCESS in 14m 56s\n- placement-nested-perfload https://logs.opendev.org/02/675302/1/check/placement-nested-perfload/99d9070/ : SUCCESS in 14m 15s (non-voting)\n- placement-perfload https://logs.opendev.org/02/675302/1/check/placement-perfload/2577c1f/ : SUCCESS in 8m 03s (non-voting)\n- tempest-ipv6-only https://logs.opendev.org/02/675302/1/check/tempest-ipv6-only/a590c9b/ : SUCCESS in 1h 17m 26s","accounts_in_message":[],"_revision_number":1},{"id":"9fe1b68d3f450144b3097397deeec26985f2652f","author":{"_account_id":25625,"name":"Tetsuro Nakamura","email":"tetsuro.nakamura.bc@hco.ntt.co.jp","username":"tetsuro0907"},"date":"2019-08-09 01:58:28.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1\n\nThanks!","accounts_in_message":[],"_revision_number":1},{"id":"fb0617f420c5ec0e10dec327d14be5263f34bdf0","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-08-09 01:58:49.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"36b99d1f866bfcfec0ac0e754d16a43b31fd1380","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-08-09 03:40:46.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- grenade-py3 https://logs.opendev.org/02/675302/1/gate/grenade-py3/25ec893/ : SUCCESS in 1h 06m 40s\n- tempest-integrated-placement https://logs.opendev.org/02/675302/1/gate/tempest-integrated-placement/6d2eb81/ : SUCCESS in 1h 20m 58s\n- openstack-tox-docs https://logs.opendev.org/02/675302/1/gate/openstack-tox-docs/970fcf4/html/ : SUCCESS in 5m 02s\n- openstack-tox-lower-constraints https://logs.opendev.org/02/675302/1/gate/openstack-tox-lower-constraints/018f3c9/ : SUCCESS in 4m 34s\n- openstack-tox-pep8 https://logs.opendev.org/02/675302/1/gate/openstack-tox-pep8/be7696e/ : SUCCESS in 7m 30s\n- openstack-tox-py27 https://logs.opendev.org/02/675302/1/gate/openstack-tox-py27/db5f462/ : SUCCESS in 4m 25s\n- openstack-tox-py36 https://logs.opendev.org/02/675302/1/gate/openstack-tox-py36/8ff1f93/ : SUCCESS in 3m 56s\n- openstack-tox-py37 https://logs.opendev.org/02/675302/1/gate/openstack-tox-py37/1a9e740/ : SUCCESS in 7m 41s\n- openstack-tox-functional https://logs.opendev.org/02/675302/1/gate/openstack-tox-functional/9a91ce9/ : SUCCESS in 6m 37s\n- openstack-tox-functional-py36 https://logs.opendev.org/02/675302/1/gate/openstack-tox-functional-py36/3b062fc/ : SUCCESS in 8m 03s\n- openstack-tox-functional-py37 https://logs.opendev.org/02/675302/1/gate/openstack-tox-functional-py37/31b620b/ : SUCCESS in 7m 52s\n- placement-nova-tox-functional-py37 https://logs.opendev.org/02/675302/1/gate/placement-nova-tox-functional-py37/99049f9/ : SUCCESS in 11m 48s\n- tempest-ipv6-only https://logs.opendev.org/02/675302/1/gate/tempest-ipv6-only/d5033d1/ : SUCCESS in 1h 11m 56s","accounts_in_message":[],"_revision_number":1},{"id":"a10e3951dba2a895e318d6979f33ad1c896ed00e","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-08-09 03:40:47.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"b16b48ad6341dc90a2fae8be47ba5cc20df97fff","revisions":{"b16b48ad6341dc90a2fae8be47ba5cc20df97fff":{"kind":"REWORK","_number":1,"created":"2019-08-08 11:43:24.000000000","uploader":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"ref":"refs/changes/02/675302/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/02/675302/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/02/675302/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/02/675302/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/02/675302/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/02/675302/1"}}},"commit":{"parents":[{"commit":"f69f584577eedf07b45862d65fce2c7217634b8f","subject":"Use another expanding bindparam in _get_usages_by_provider_trees","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/f69f584577eedf07b45862d65fce2c7217634b8f"}]}],"author":{"name":"Chris Dent","email":"cdent@anticdent.org","date":"2019-08-08 11:26:00.000000000","tz":60},"committer":{"name":"Chris Dent","email":"cdent@anticdent.org","date":"2019-08-08 11:26:00.000000000","tz":60},"subject":"Correct SQL docstring on _get_usages_by_provider_trees","message":"Correct SQL docstring on _get_usages_by_provider_trees\n\nWe updated the SQL when getting rid of null root provider\nprotections [1] but did not update the docstring. This does.\n\nI confirmed it was accurate by printing the generated SQL\nand doing a compare.\n\n[1] I84baff29505550f3f20069ad5817784d0d1aaea6\n\nChange-Id: Iefbb38f1f328b4d7a51cfec360c81369a977461e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/b16b48ad6341dc90a2fae8be47ba5cc20df97fff"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/b16b48ad6341dc90a2fae8be47ba5cc20df97fff"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}