Merge "Remove deprecated dialects and drivers" into main

3 files changed, 4 insertions, 40 deletions

diff --git a/lib/sqlalchemy/testing/requirements.py b/lib/sqlalchemy/testing/requirements.py
index f8b5dd606..3cf5c853e 100644
--- a/lib/sqlalchemy/testing/requirements.py
+++ b/lib/sqlalchemy/testing/requirements.py
@@ -232,7 +232,7 @@ class SuiteRequirements(Requirements):
         without being in the context of a typed column.
 
         """
-        return exclusions.closed()
+        return exclusions.open()
 
     @property
     def standalone_null_binds_whereclause(self):
@@ -917,7 +917,7 @@ class SuiteRequirements(Requirements):
     def precision_numerics_enotation_large(self):
         """target backend supports Decimal() objects using E notation
         to represent very large values."""
-        return exclusions.closed()
+        return exclusions.open()
 
     @property
     def precision_numerics_many_significant_digits(self):
diff --git a/lib/sqlalchemy/testing/schema.py b/lib/sqlalchemy/testing/schema.py
index 9c6bf9e4c..9b5546ce7 100644
--- a/lib/sqlalchemy/testing/schema.py
+++ b/lib/sqlalchemy/testing/schema.py
@@ -48,37 +48,6 @@ def Table(*args, **kw):
             else:
                 kw["mariadb_engine"] = "MyISAM"
 
-    # Apply some default cascading rules for self-referential foreign keys.
-    # MySQL InnoDB has some issues around selecting self-refs too.
-    if exclusions.against(config._current, "firebird"):
-        table_name = args[0]
-        unpack = config.db.dialect.identifier_preparer.unformat_identifiers
-
-        # Only going after ForeignKeys in Columns.  May need to
-        # expand to ForeignKeyConstraint too.
-        fks = [
-            fk
-            for col in args
-            if isinstance(col, schema.Column)
-            for fk in col.foreign_keys
-        ]
-
-        for fk in fks:
-            # root around in raw spec
-            ref = fk._colspec
-            if isinstance(ref, schema.Column):
-                name = ref.table.name
-            else:
-                # take just the table name: on FB there cannot be
-                # a schema, so the first element is always the
-                # table name, possibly followed by the field name
-                name = unpack(ref)[0]
-            if name == table_name:
-                if fk.ondelete is None:
-                    fk.ondelete = "CASCADE"
-                if fk.onupdate is None:
-                    fk.onupdate = "CASCADE"
-
     return schema.Table(*args, **kw)
 
 
@@ -101,9 +70,9 @@ def Column(*args, **kw):
         # allow any test suite to pick up on this
         col.info["test_needs_autoincrement"] = True
 
-        # hardcoded rule for firebird, oracle; this should
+        # hardcoded rule for oracle; this should
         # be moved out
-        if exclusions.against(config._current, "firebird", "oracle"):
+        if exclusions.against(config._current, "oracle"):
 
             def add_seq(c, tbl):
                 c._init_items(
diff --git a/lib/sqlalchemy/testing/warnings.py b/lib/sqlalchemy/testing/warnings.py
index b5842ad69..2c41337e4 100644
--- a/lib/sqlalchemy/testing/warnings.py
+++ b/lib/sqlalchemy/testing/warnings.py
@@ -55,11 +55,6 @@ def setup_filters():
         category=sa_exc.SADeprecationWarning,
         message=r".*\(deprecated since: 2.0\)$",
     )
-    warnings.filterwarnings(
-        "ignore",
-        category=sa_exc.SADeprecationWarning,
-        message=r"^The (Sybase|firebird) dialect is deprecated and will be",
-    )
 
     try:
         import pytest