correct for "autocommit" deprecation warning

Ensure no autocommit warnings occur internally or
within tests.

Also includes fixes for SQL Server full text tests
which apparently have not been working at all for a long
time, as it used long removed APIs.  CI has not had
fulltext running for some years and is now installed.

Change-Id: Id806e1856c9da9f0a9eac88cebc7a94ecc95eb96

1 files changed, 4 insertions, 4 deletions

diff --git a/test/engine/test_reflection.py b/test/engine/test_reflection.py
index b19836c84..48b6c40d7 100644
--- a/test/engine/test_reflection.py
+++ b/test/engine/test_reflection.py
@@ -2016,7 +2016,7 @@ def createIndexes(con, schema=None):
 
 @testing.requires.views
 def _create_views(con, schema=None):
-    with testing.db.connect() as conn:
+    with testing.db.begin() as conn:
         for table_name in ("users", "email_addresses"):
             fullname = table_name
             if schema:
@@ -2031,7 +2031,7 @@ def _create_views(con, schema=None):
 
 @testing.requires.views
 def _drop_views(con, schema=None):
-    with testing.db.connect() as conn:
+    with testing.db.begin() as conn:
         for table_name in ("email_addresses", "users"):
             fullname = table_name
             if schema:
@@ -2047,7 +2047,7 @@ class ReverseCasingReflectTest(fixtures.TestBase, AssertsCompiledSQL):
 
     @testing.requires.denormalized_names
     def setup(self):
-        with testing.db.connect() as conn:
+        with testing.db.begin() as conn:
             conn.exec_driver_sql(
                 """
             CREATE TABLE weird_casing(
@@ -2060,7 +2060,7 @@ class ReverseCasingReflectTest(fixtures.TestBase, AssertsCompiledSQL):
 
     @testing.requires.denormalized_names
     def teardown(self):
-        with testing.db.connect() as conn:
+        with testing.db.begin() as conn:
             conn.exec_driver_sql("drop table weird_casing")
 
     @testing.requires.denormalized_names