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

1 files changed, 1 insertions, 4 deletions

diff --git a/test/dialect/test_sqlite.py b/test/dialect/test_sqlite.py
index eb68c0c6f..a2fe81a4b 100644
--- a/test/dialect/test_sqlite.py
+++ b/test/dialect/test_sqlite.py
@@ -841,6 +841,7 @@ class AttachedDBTest(fixtures.TestBase):
         self.metadata = MetaData()
 
     def teardown_test(self):
+        self.conn.rollback()
         with self.conn.begin():
             self.metadata.drop_all(self.conn)
         self.conn.close()
@@ -2468,10 +2469,6 @@ class SavepointTest(fixtures.TablesTest):
         connection.close()
 
 
-class FutureSavepointTest(fixtures.FutureEngineMixin, SavepointTest):
-    pass
-
-
 class TypeReflectionTest(fixtures.TestBase):
 
     __only_on__ = "sqlite"