From 4ff4760fade8020df0418005e0fdd130ed3589a4 Mon Sep 17 00:00:00 2001 From: Gord Thompson Date: Sun, 4 Jul 2021 15:56:40 -0600 Subject: Modernize tests - select(whereclause) Change-Id: I306cfbea9920b35100e3087dcc21d7ffa6c39c55 --- lib/sqlalchemy/testing/suite/test_select.py | 4 ++-- lib/sqlalchemy/testing/warnings.py | 7 ------- 2 files changed, 2 insertions(+), 9 deletions(-) (limited to 'lib/sqlalchemy') diff --git a/lib/sqlalchemy/testing/suite/test_select.py b/lib/sqlalchemy/testing/suite/test_select.py index 1605033a0..0a1227e58 100644 --- a/lib/sqlalchemy/testing/suite/test_select.py +++ b/lib/sqlalchemy/testing/suite/test_select.py @@ -1663,7 +1663,7 @@ class IsOrIsNotDistinctFromTest(fixtures.TablesTest): ) result = connection.execute( - tbl.select(tbl.c.col_a.is_distinct_from(tbl.c.col_b)) + tbl.select().where(tbl.c.col_a.is_distinct_from(tbl.c.col_b)) ).fetchall() eq_( len(result), @@ -1674,7 +1674,7 @@ class IsOrIsNotDistinctFromTest(fixtures.TablesTest): 1 if expected_row_count_for_is == 0 else 0 ) result = connection.execute( - tbl.select(tbl.c.col_a.is_not_distinct_from(tbl.c.col_b)) + tbl.select().where(tbl.c.col_a.is_not_distinct_from(tbl.c.col_b)) ).fetchall() eq_( len(result), diff --git a/lib/sqlalchemy/testing/warnings.py b/lib/sqlalchemy/testing/warnings.py index df0e5aa5e..8f9273b30 100644 --- a/lib/sqlalchemy/testing/warnings.py +++ b/lib/sqlalchemy/testing/warnings.py @@ -65,16 +65,9 @@ def setup_filters(): # be "error" however for I98b8defdf7c37b818b3824d02f7668e3f5f31c94 # we are moving one at a time for msg in [ - # - # Core execution - # - # r".*DefaultGenerator.execute\(\)", - # - # # # Core SQL constructs # - r"The FromClause\.select\(\).whereclause parameter is deprecated", r"Set functions such as union\(\), union_all\(\), extract\(\),", r"The legacy calling style of select\(\) is deprecated and will be " "removed", -- cgit v1.2.1