From d050193daaa8d91371c759296f3304b8641c1976 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Mon, 1 Nov 2021 15:44:44 -0400 Subject: fully implement future engine and remove legacy The major action here is to lift and move future.Connection and future.Engine fully into sqlalchemy.engine.base. This removes lots of engine concepts, including: * autocommit * Connection running without a transaction, autobegin is now present in all cases * most "autorollback" is obsolete * Core-level subtransactions (i.e. MarkerTransaction) * "branched" connections, copies of connections * execution_options() returns self, not a new connection * old argument formats, distill_params(), simplifies calling scheme between engine methods * before/after_execute() events (oriented towards compiled constructs) don't emit for exec_driver_sql(). before/after_cursor_execute() is still included for this * old helper methods superseded by context managers, connection.transaction(), engine.transaction() engine.run_callable() * ancient engine-level reflection methods has_table(), table_names() * sqlalchemy.testing.engines.proxying_engine References: #7257 Change-Id: Ib20ed816642d873b84221378a9ec34480e01e82c --- test/dialect/postgresql/test_dialect.py | 20 -------------------- 1 file changed, 20 deletions(-) (limited to 'test/dialect/postgresql/test_dialect.py') diff --git a/test/dialect/postgresql/test_dialect.py b/test/dialect/postgresql/test_dialect.py index 6e665c71b..e7c4ebb7c 100644 --- a/test/dialect/postgresql/test_dialect.py +++ b/test/dialect/postgresql/test_dialect.py @@ -53,7 +53,6 @@ from sqlalchemy.testing.assertions import eq_regex from sqlalchemy.testing.assertions import ne_ from sqlalchemy.util import u from sqlalchemy.util import ue -from ...engine import test_deprecations if True: from sqlalchemy.dialects.postgresql.psycopg2 import ( @@ -1359,22 +1358,3 @@ $$ LANGUAGE plpgsql; engine = engines.testing_engine() with engine.connect() as conn: ne_(conn.connection.status, STATUS_IN_TRANSACTION) - - -class AutocommitTextTest(test_deprecations.AutocommitTextTest): - __only_on__ = "postgresql" - - def test_grant(self): - self._test_keyword("GRANT USAGE ON SCHEMA fooschema TO foorole") - - def test_import_foreign_schema(self): - self._test_keyword("IMPORT FOREIGN SCHEMA foob") - - def test_refresh_view(self): - self._test_keyword("REFRESH MATERIALIZED VIEW fooview") - - def test_revoke(self): - self._test_keyword("REVOKE USAGE ON SCHEMA fooschema FROM foorole") - - def test_truncate(self): - self._test_keyword("TRUNCATE footable") -- cgit v1.2.1