From d3b951970f1a78bcae0db519da978460c856d4f5 Mon Sep 17 00:00:00 2001 From: Daniele Varrazzo Date: Fri, 13 May 2022 02:29:38 +0200 Subject: [PATCH] test: test multi-statement parametric queries with client-side binding --- tests/test_client_cursor.py | 2 +- tests/test_client_cursor_async.py | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/tests/test_client_cursor.py b/tests/test_client_cursor.py index 8b403c182..da813e774 100644 --- a/tests/test_client_cursor.py +++ b/tests/test_client_cursor.py @@ -158,7 +158,7 @@ def test_execute_many_results(conn): cur = conn.cursor() assert cur.nextset() is None - rv = cur.execute("select 'foo'; select generate_series(1,3)") + rv = cur.execute("select %s; select generate_series(1,%s)", ("foo", 3)) assert rv is cur assert cur.fetchall() == [("foo",)] assert cur.rowcount == 1 diff --git a/tests/test_client_cursor_async.py b/tests/test_client_cursor_async.py index 780d81706..fe8631803 100644 --- a/tests/test_client_cursor_async.py +++ b/tests/test_client_cursor_async.py @@ -161,7 +161,7 @@ async def test_execute_many_results(aconn): cur = aconn.cursor() assert cur.nextset() is None - rv = await cur.execute("select 'foo'; select generate_series(1,3)") + rv = await cur.execute("select %s; select generate_series(1,%s)", ("foo", 3)) assert rv is cur assert (await cur.fetchall()) == [("foo",)] assert cur.rowcount == 1 -- 2.47.3