From fda9374b797ca13a9d11cee4f74c0de34e531f6e Mon Sep 17 00:00:00 2001 From: Daniele Varrazzo Date: Mon, 18 Apr 2022 00:44:43 +0200 Subject: [PATCH] test(enum): more idiomatic sql composition --- tests/types/test_enum.py | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/tests/types/test_enum.py b/tests/types/test_enum.py index 78b9e0580..128afa760 100644 --- a/tests/types/test_enum.py +++ b/tests/types/test_enum.py @@ -29,14 +29,14 @@ encodings = ["utf8", "latin1"] @pytest.fixture(scope="session", params=enum_cases) def testenum(request, svcconn): name, enum, labels = request.param - quoted_labels = [sql.quote(label) for label in labels] - cur = svcconn.cursor() cur.execute( - f""" - drop type if exists {name} cascade; - create type {name} as enum({','.join(quoted_labels)}); - """ + sql.SQL( + """ + drop type if exists {name} cascade; + create type {name} as enum ({labels}); + """ + ).format(name=sql.Identifier(name), labels=sql.SQL(",").join(labels)) ) return name, enum, labels -- 2.47.2