From 02ae6ab3fdf2c0c07910d06aa1d7d5048cdabd9d Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Mon, 13 Feb 2017 14:17:11 -0500
Subject: [PATCH] - add a test suite that ensures textual autocommit works for
 correct expressions

Change-Id: I17d35169be914924828487abba05658dff380f2a
---
 test/engine/test_execute.py | 56 +++++++++++++++++++++++++++++++++++++
 1 file changed, 56 insertions(+)

diff --git a/test/engine/test_execute.py b/test/engine/test_execute.py
index 145877dd34..32834f950b 100644
--- a/test/engine/test_execute.py
+++ b/test/engine/test_execute.py
@@ -2635,3 +2635,59 @@ class DialectEventTest(fixtures.TestBase):
         conn.connection.invalidate()
         conn = e.connect()
         eq_(conn.info['boom'], "one")
+
+
+class AutocommitTextTest(fixtures.TestBase):
+    __backend__ = True
+
+    def _test_keyword(self, keyword, expected=True):
+        dbapi = Mock(
+            connect=Mock(
+                return_value=Mock(
+                    cursor=Mock(
+                        return_value=Mock(
+                            description=()
+                        )
+                    )
+                )
+            )
+        )
+        engine = engines.testing_engine(
+            options={
+                "_initialize": False,
+                "pool_reset_on_return": None
+            })
+        engine.dialect.dbapi = dbapi
+        engine.execute("%s something table something" % keyword)
+        if expected:
+            eq_(
+                dbapi.connect().mock_calls,
+                [call.cursor(), call.commit()]
+            )
+        else:
+            eq_(
+                dbapi.connect().mock_calls,
+                [call.cursor()]
+            )
+
+    def test_update(self):
+        self._test_keyword("UPDATE")
+
+    def test_insert(self):
+        self._test_keyword("INSERT")
+
+    def test_delete(self):
+        self._test_keyword("DELETE")
+
+    def test_alter(self):
+        self._test_keyword("ALTER TABLE")
+
+    def test_create(self):
+        self._test_keyword("CREATE TABLE foobar")
+
+    def test_drop(self):
+        self._test_keyword("DROP TABLE foobar")
+
+    def test_select(self):
+        self._test_keyword("SELECT foo FROM table", False)
+
-- 
2.47.2