Add support for aiosqlite

Added support for the aiosqlite database driver for use with the
SQLAlchemy asyncio extension.

Fixes: #5920
Change-Id: Id11a320516a44e886a6f518d2866a0f992413e55

1 files changed, 16 insertions, 1 deletions

diff --git a/test/engine/test_pool.py b/test/engine/test_pool.py
index 3c2257331..1c3880504 100644
--- a/test/engine/test_pool.py
+++ b/test/engine/test_pool.py
@@ -329,7 +329,7 @@ class PoolDialectTest(PoolTestBase):
         self._do_test(pool.NullPool, ["R", "CL", "R", "CL"])
 
     def test_static_pool(self):
-        self._do_test(pool.StaticPool, ["R", "R"])
+        self._do_test(pool.StaticPool, ["R", "CL", "R"])
 
 
 class PoolEventsTest(PoolTestBase):
@@ -1960,6 +1960,21 @@ class StaticPoolTest(PoolTestBase):
         p2 = p.recreate()
         assert p._creator is p2._creator
 
+    def test_connect(self):
+        dbapi = MockDBAPI()
+
+        def creator():
+            return dbapi.connect("foo.db")
+
+        p = pool.StaticPool(creator)
+
+        c1 = p.connect()
+        conn = c1.connection
+        c1.close()
+
+        c2 = p.connect()
+        is_(conn, c2.connection)
+
 
 class CreatorCompatibilityTest(PoolTestBase):
     def test_creator_callable_outside_noarg(self):