Changeset: 747c247d93a1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/747c247d93a1
Modified Files:
sql/test/miscellaneous/Tests/unlogged.py
Branch: Sep2022
Log Message:
When we get something we didn't expect, tell us what we got.
diffs (72 lines):
diff --git a/sql/test/miscellaneous/Tests/unlogged.py
b/sql/test/miscellaneous/Tests/unlogged.py
--- a/sql/test/miscellaneous/Tests/unlogged.py
+++ b/sql/test/miscellaneous/Tests/unlogged.py
@@ -19,13 +19,16 @@ with tempfile.TemporaryDirectory() as fa
node1_cur = node1_conn.cursor()
node1_cur.execute("CREATE unlogged TABLE foo (i INT)")
- if node1_cur.execute("INSERT INTO foo VALUES (10), (20)") != 2:
- sys.stderr.write("2 rows inserted expected")
- if node1_cur.execute("UPDATE foo set i = i + 20 WHERE i = 10") !=
1:
- sys.stderr.write("1 rows updated expected")
+ res = node1_cur.execute("INSERT INTO foo VALUES (10), (20)")
+ if res != 2:
+ sys.stderr.write(f"2 rows inserted expected, {res} received")
+ res = node1_cur.execute("UPDATE foo set i = i + 20 WHERE i = 10")
+ if res != 1:
+ sys.stderr.write(f"1 row updated expected, {res} received")
node1_cur.execute("SELECT i FROM foo ORDER BY i")
- if node1_cur.fetchall() != [(20,), (30,)]:
- sys.stderr.write("[(20), (30)] expected")
+ res = node1_cur.fetchall()
+ if res != [(20,), (30,)]:
+ sys.stderr.write(f"[(20), (30)] expected, {res} received")
node1_cur.close()
node1_conn.close()
@@ -40,8 +43,9 @@ with tempfile.TemporaryDirectory() as fa
node1_cur = node1_conn.cursor()
node1_cur.execute("SELECT i FROM foo ORDER BY i")
- if node1_cur.fetchall() != []:
- sys.stderr.write("[] expected")
+ res = node1_cur.fetchall()
+ if res != []:
+ sys.stderr.write(f"[] expected, {res} received")
node1_cur.close()
node1_conn.close()
@@ -59,13 +63,16 @@ with tempfile.TemporaryDirectory() as fa
node1_cur = node1_conn.cursor()
node1_cur.execute("CREATE unlogged TABLE foo (i) AS VALUES (10),
(20)")
- if node1_cur.execute("INSERT INTO foo VALUES (30), (40)") != 2:
- sys.stderr.write("2 rows inserted expected")
- if node1_cur.execute("UPDATE foo set i = 50 WHERE i = 10") != 1:
- sys.stderr.write("1 rows updated expected")
+ res = node1_cur.execute("INSERT INTO foo VALUES (30), (40)")
+ if res != 2:
+ sys.stderr.write(f"2 rows inserted expected, {res} received")
+ res = node1_cur.execute("UPDATE foo set i = 50 WHERE i = 10")
+ if res != 1:
+ sys.stderr.write(f"1 rows updated expected, {res} received")
node1_cur.execute("SELECT i FROM foo ORDER BY i")
- if node1_cur.fetchall() != [(20,), (30,), (40,), (50,)]:
- sys.stderr.write("[(20), (30), (40), (50)] expected")
+ res = node1_cur.fetchall()
+ if res != [(20,), (30,), (40,), (50,)]:
+ sys.stderr.write(f"[(20), (30), (40), (50)] expected, {res}
received")
node1_cur.close()
node1_conn.close()
@@ -80,7 +87,8 @@ with tempfile.TemporaryDirectory() as fa
node1_cur = node1_conn.cursor()
node1_cur.execute("SELECT i FROM foo ORDER BY i")
- if node1_cur.fetchall() != [(10,), (20,)]:
- sys.stderr.write("[(10), (20)] expected")
+ res = node1_cur.fetchall()
+ if res != [(10,), (20,)]:
+ sys.stderr.write(f"[(10), (20)] expected, {res} received")
node1_cur.close()
node1_conn.close()
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
