old_contents: # testing/warnings.py
  # Copyright (C) 2005-2021 the SQLAlchemy authors and contributors
  # <see AUTHORS file>
  #
  # This module is part of SQLAlchemy and is released under
  # the MIT License: http://www.opensource.org/licenses/mit-license.php
  
  from __future__ import absolute_import
  
  import warnings
  
  from sqlalchemy import exc as sa_exc
  
  
  def setup_filters():
      """Set global warning behavior for the test suite."""
  
      warnings.resetwarnings()
  
      warnings.filterwarnings("error", category=sa_exc.SADeprecationWarning)
      warnings.filterwarnings("error", category=sa_exc.SAWarning)
  
      # some selected deprecations...
      warnings.filterwarnings("error", category=DeprecationWarning)
      try:
          import pytest
      except ImportError:
          pass
      else:
          warnings.filterwarnings(
              "once", category=pytest.PytestDeprecationWarning
          )
  
      if hasattr(sa_exc, "RemovedIn20Warning"):
          for msg in [
              #
              # Core execution - need to remove this after SQLAlchemy
              # repairs it in provisioning
              #
              r"The connection.execute\(\) method in SQLAlchemy 2.0 will accept "
              "parameters as a single dictionary or a single sequence of "
              "dictionaries only.",
          ]:
              warnings.filterwarnings(
                  "ignore",
                  message=msg,
                  category=sa_exc.RemovedIn20Warning,
              )
  
new_contents: # testing/warnings.py
  # Copyright (C) 2005-2021 the SQLAlchemy authors and contributors
  # <see AUTHORS file>
  #
  # This module is part of SQLAlchemy and is released under
  # the MIT License: http://www.opensource.org/licenses/mit-license.php
  
  from __future__ import absolute_import
  
  import warnings
  
  from sqlalchemy import exc as sa_exc
  
  
  def setup_filters():
      """Set global warning behavior for the test suite."""
  
      warnings.resetwarnings()
  
      warnings.filterwarnings("error", category=sa_exc.SADeprecationWarning)
      warnings.filterwarnings("error", category=sa_exc.SAWarning)
  
      # some selected deprecations...
      warnings.filterwarnings("error", category=DeprecationWarning)
      try:
          import pytest
      except ImportError:
          pass
      else:
          warnings.filterwarnings(
              "once", category=pytest.PytestDeprecationWarning
          )
  
subject: Remove remaining 2.0 warning