From 3e6ad6f2fecc6ae36a10a5a34b5d3d393483edbb Mon Sep 17 00:00:00 2001 From: Cristian Sabaila Date: Wed, 3 Nov 2021 01:15:12 +0200 Subject: [PATCH] simplify `test_on_duplicate_key_update_expression_multirow` --- test/dialect/mysql/test_on_duplicate.py | 15 +++++++-------- 1 file changed, 7 insertions(+), 8 deletions(-) diff --git a/test/dialect/mysql/test_on_duplicate.py b/test/dialect/mysql/test_on_duplicate.py index 544227af70..5a4e6ca8d5 100644 --- a/test/dialect/mysql/test_on_duplicate.py +++ b/test/dialect/mysql/test_on_duplicate.py @@ -105,15 +105,14 @@ class OnDuplicateTest(fixtures.TablesTest): ) result = conn.execute(stmt) eq_(result.inserted_primary_key, (None,)) - # first entry triggers ON DUPLICATE eq_( - conn.execute(foos.select().where(foos.c.id == 1)).fetchall(), - [(1, "ab_foo", "ab_bz", False)], - ) - # second entry should be an insert - eq_( - conn.execute(foos.select().where(foos.c.id == 2)).fetchall(), - [(2, "b", None, False)], + conn.execute(foos.select()).fetchall(), + [ + # first entry triggers ON DUPLICATE + (1, "ab_foo", "ab_bz", False), + # second entry must be an insert + (2, "b", None, False), + ], ) def test_on_duplicate_key_update_preserve_order(self, connection): -- 2.47.3