)]}'
{"/PATCHSET_LEVEL":[{"author":{"_account_id":5572,"name":"Don Kehn","display_name":"DEKehn","email":"dekehn@gmail.com","username":"dekehn"},"change_message_id":"9ea36d3e9dfde6136f492d688bc87deac68e0f95","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"283d090b_ae01f88e","updated":"2022-09-28 21:10:17.000000000","message":"LGTM\nfrom the DB POV:\nmysql: [Warning] Using a password on the command line interface can be insecure.\n+----------+\n| count(*) |\n+----------+\n|       75 |\n+----------+\n[stack@ospr1-069 designate] (master) \u003e sudo mysql -u root -poctavia2password -e\"select count(*) from designate.zones\"\nmysql: [Warning] Using a password on the command line interface can be insecure.\n+----------+\n| count(*) |\n+----------+\n|       76 |\n+----------+\n[stack@ospr1-069 designate] (master) \u003e ^C\n[stack@ospr1-069 designate] (master) \u003e sudo mysql -u root -poctavia2password -e\"select count(*) from designate.zones\"\nmysql: [Warning] Using a password on the command line interface can be insecure.\n+----------+\n| count(*) |\n+----------+\n|       77 |\n+----------+\nmysql: [Warning] Using a password on the command line interface can be insecure.\n+----------------------------------+---------+------------+---------------------+----------------------------------------------------------------------+------------------------------------------------------------------------------------------+\n| id                               | version | updated_at | created_at          | pattern                                                              | description                                                                              |\n+----------------------------------+---------+------------+---------------------+----------------------------------------------------------------------+------------------------------------------------------------------------------------------+\n| 126005db6b234dd181bb1634afb1cefb |       1 | NULL       | 2022-09-28 21:08:01 | ^a.*                                                                 | Zone starts with \"a\" char                                                                |\n| 48592c512c994ef99eecdb4a66e49a4c |       1 | NULL       | 2022-09-28 21:08:01 | rand-deny_by_name-731076157.rand-BaseBlacklistsTest-1724618456.test. | Deny if Zone named:rand-deny_by_name-731076157.rand-BaseBlacklistsTest-1724618456.test.  |\n| f7bbdebbec1c47c7b977b4ea37a85953 |       1 | NULL       | 2022-05-12 16:24:19 | ^blacklistnameregextest2.*                                           | Zone starts with \"a\" char                                                                |\n+----------------------------------+---------+------------+---------------------+----------------------------------------------------------------------+------------------------------------------------------------------------------------------+\n[stack@ospr1-069 designate-tempest-plugin] (review/853873) \u003e sudo mysql -u root -poctavia2password designate -e \"select * from blacklists;\"\nmysql: [Warning] Using a password on the command line interface can be insecure.\n+----------------------------------+---------+------------+---------------------+----------------------------+--------------------------------------------+\n| id                               | version | updated_at | created_at          | pattern                    | description                                |\n+----------------------------------+---------+------------+---------------------+----------------------------+--------------------------------------------+\n| e4853fa7f6134673817c3c00ab8989e3 |       1 | NULL       | 2022-09-28 21:08:16 | ^blacklistregextest.*      | Zone starts with \"blacklistregextest\" char |\n| f7bbdebbec1c47c7b977b4ea37a85953 |       1 | NULL       | 2022-05-12 16:24:19 | ^blacklistnameregextest2.* | Zone starts with \"a\" char                  |\n+----------------------------------+---------+------------+---------------------+----------------------------+--------------------------------------------+\n[stack@ospr1-069 designate-tempest-plugin] (review/853873) \u003e sudo mysql -u root -poctavia2password designate -e \"select * from blacklists;\"\nmysql: [Warning] Using a password on the command line interface can be insecure.\n+----------------------------------+---------+------------+---------------------+----------------------------+---------------------------+\n| id                               | version | updated_at | created_at          | pattern                    | description               |\n+----------------------------------+---------+------------+---------------------+----------------------------+---------------------------+\n| f7bbdebbec1c47c7b977b4ea37a85953 |       1 | NULL       | 2022-05-12 16:24:19 | ^blacklistnameregextest2.* | Zone starts with \"a\" char |\n+----------------------------------+---------+------------+---------------------+----------------------------+---------------------------+\nAll are deleted upon exit.\n\nmysql: [Warning] Using a password on the command line interface can be insecure.\n+----------------------------------+---------+------------+---------------------+----------------------------------------------------------------------+------------------------------------------------------------------------------------------+\n| id                               | version | updated_at | created_at          | pattern                                                              | description                                                                              |\n+----------------------------------+---------+------------+---------------------+----------------------------------------------------------------------+------------------------------------------------------------------------------------------+\n| 126005db6b234dd181bb1634afb1cefb |       1 | NULL       | 2022-09-28 21:08:01 | ^a.*                                                                 | Zone starts with \"a\" char                                                                |\n| 48592c512c994ef99eecdb4a66e49a4c |       1 | NULL       | 2022-09-28 21:08:01 | rand-deny_by_name-731076157.rand-BaseBlacklistsTest-1724618456.test. | Deny if Zone named:rand-deny_by_name-731076157.rand-BaseBlacklistsTest-1724618456.test.  |\n| f7bbdebbec1c47c7b977b4ea37a85953 |       1 | NULL       | 2022-05-12 16:24:19 | ^blacklistnameregextest2.*                                           | Zone starts with \"a\" char                                                                |\n+----------------------------------+---------+------------+---------------------+----------------------------------------------------------------------+------------------------------------------------------------------------------------------+\n[stack@ospr1-069 designate-tempest-plugin] (review/853873) \u003e sudo mysql -u root -poctavia2password designate -e \"select * from blacklists;\"\nmysql: [Warning] Using a password on the command line interface can be insecure.\n+----------------------------------+---------+------------+---------------------+----------------------------+--------------------------------------------+\n| id                               | version | updated_at | created_at          | pattern                    | description                                |\n+----------------------------------+---------+------------+---------------------+----------------------------+--------------------------------------------+\n| e4853fa7f6134673817c3c00ab8989e3 |       1 | NULL       | 2022-09-28 21:08:16 | ^blacklistregextest.*      | Zone starts with \"blacklistregextest\" char |\n| f7bbdebbec1c47c7b977b4ea37a85953 |       1 | NULL       | 2022-05-12 16:24:19 | ^blacklistnameregextest2.* | Zone starts with \"a\" char                  |\n+----------------------------------+---------+------------+---------------------+----------------------------+--------------------------------------------+\n[stack@ospr1-069 designate-tempest-plugin] (review/853873) \u003e sudo mysql -u root -poctavia2password designate -e \"select * from blacklists;\"\nmysql: [Warning] Using a password on the command line interface can be insecure.\n+----------------------------------+---------+------------+---------------------+----------------------------+---------------------------+\n| id                               | version | updated_at | created_at          | pattern                    | description               |\n+----------------------------------+---------+------------+---------------------+----------------------------+---------------------------+\n| f7bbdebbec1c47c7b977b4ea37a85953 |       1 | NULL       | 2022-05-12 16:24:19 | ^blacklistnameregextest2.* | Zone starts with \"a\" char |\n+----------------------------------+---------+------------+---------------------+----------------------------+---------------------------+\n","commit_id":"25d20e6650f4fc84e9ea384cf50619746df2984b"}],"designate_tempest_plugin/tests/scenario/v2/test_blacklists.py":[{"author":{"_account_id":11628,"name":"Michael Johnson","email":"johnsomor@gmail.com","username":"johnsom"},"change_message_id":"795ae0246ef08fd14762c2fc435c149885fc9f2a","unresolved":true,"context_lines":[{"line_number":112,"context_line":"        zone_name_to_deny \u003d dns_data_utils.rand_zone_name("},{"line_number":113,"context_line":"            name\u003d\"deny_by_name\", suffix\u003dself.tld_name)"},{"line_number":114,"context_line":"        blacklists \u003d ["},{"line_number":115,"context_line":"            {\u0027pattern\u0027: \u0027^a.*\u0027,"},{"line_number":116,"context_line":"             \u0027description\u0027: \u0027Zone starts with \"a\" char\u0027},"},{"line_number":117,"context_line":"            {\u0027pattern\u0027: zone_name_to_deny,"},{"line_number":118,"context_line":"             \u0027description\u0027: \u0027Deny if Zone named:{} \u0027.format("}],"source_content_type":"text/x-python","patch_set":1,"id":"dbbe19b1_ed749779","line":115,"updated":"2022-10-12 21:44:21.000000000","message":"This is too broad and causing test failures.","commit_id":"25d20e6650f4fc84e9ea384cf50619746df2984b"}]}