From d050193daaa8d91371c759296f3304b8641c1976 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
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
---
 lib/sqlalchemy/sql/elements.py | 26 ++++----------------------
 1 file changed, 4 insertions(+), 22 deletions(-)

(limited to 'lib/sqlalchemy/sql/elements.py')

diff --git a/lib/sqlalchemy/sql/elements.py b/lib/sqlalchemy/sql/elements.py
index c8faebbd9..a279f634d 100644
--- a/lib/sqlalchemy/sql/elements.py
+++ b/lib/sqlalchemy/sql/elements.py
@@ -29,7 +29,6 @@ from .base import Executable
 from .base import HasMemoized
 from .base import Immutable
 from .base import NO_ARG
-from .base import PARSE_AUTOCOMMIT
 from .base import SingletonConstant
 from .coercions import _document_text_coercion
 from .traversals import HasCopyInternals
@@ -319,11 +318,11 @@ class ClauseElement(
         return d
 
     def _execute_on_connection(
-        self, connection, multiparams, params, execution_options, _force=False
+        self, connection, distilled_params, execution_options, _force=False
     ):
         if _force or self.supports_execution:
             return connection._execute_clauseelement(
-                self, multiparams, params, execution_options
+                self, distilled_params, execution_options
             )
         else:
             raise exc.ObjectNotExecutableError(self)
@@ -1755,9 +1754,6 @@ class TextClause(
     _is_textual = True
 
     _bind_params_regex = re.compile(r"(?<![:\w\x5c]):(\w+)(?!:)", re.UNICODE)
-    _execution_options = Executable._execution_options.union(
-        {"autocommit": PARSE_AUTOCOMMIT}
-    )
     _is_implicitly_boolean = False
 
     _render_label_in_columns_clause = False
@@ -1860,19 +1856,8 @@ class TextClause(
         :func:`_expression.text` is also used for the construction
         of a full, standalone statement using plain text.
         As such, SQLAlchemy refers
-        to it as an :class:`.Executable` object, and it supports
-        the :meth:`Executable.execution_options` method.  For example,
-        a :func:`_expression.text`
-        construct that should be subject to "autocommit"
-        can be set explicitly so using the
-        :paramref:`.Connection.execution_options.autocommit` option::
-
-            t = text("EXEC my_procedural_thing()").\
-                    execution_options(autocommit=True)
-
-        .. deprecated:: 1.4  The "autocommit" execution option is deprecated
-           and will be removed in SQLAlchemy 2.0.  See
-           :ref:`migration_20_autocommit` for discussion.
+        to it as an :class:`.Executable` object and may be used
+        like any other statement passed to an ``.execute()`` method.
 
         :param text:
           the text of the SQL statement to be created.  Use ``:<param>``
@@ -5044,9 +5029,6 @@ class CollationClause(ColumnElement):
 class _IdentifiedClause(Executable, ClauseElement):
 
     __visit_name__ = "identified"
-    _execution_options = Executable._execution_options.union(
-        {"autocommit": False}
-    )
 
     def __init__(self, ident):
         self.ident = ident
-- 
cgit v1.2.1