[SQL-CVS] r4676 - in SQLObject/branches/1.5: docs sqlobject/sqlite sqlobject/tests

[<sub...@co...>]

Author: phd
Date: Sun Dec  8 08:54:13 2013
New Revision: 4676

Log:
SQLiteConnection.close() now closes and reopens a connection
to in-memory database.

Modified:
   SQLObject/branches/1.5/docs/News.txt
   SQLObject/branches/1.5/sqlobject/sqlite/sqliteconnection.py
   SQLObject/branches/1.5/sqlobject/tests/dbtest.py
   SQLObject/branches/1.5/sqlobject/tests/test_sqlite.py

Modified: SQLObject/branches/1.5/docs/News.txt
==============================================================================
--- SQLObject/branches/1.5/docs/News.txt	Mon Oct 14 11:16:48 2013	(r4675)
+++ SQLObject/branches/1.5/docs/News.txt	Sun Dec  8 08:54:13 2013	(r4676)
@@ -7,6 +7,12 @@
 
 .. _start:
 
+SQLObject 1.5.1
+===============
+
+* SQLiteConnection.close() now closes and reopens a connection
+  to in-memory database.
+
 SQLObject 1.5.0
 ===============
 

Modified: SQLObject/branches/1.5/sqlobject/sqlite/sqliteconnection.py
==============================================================================
--- SQLObject/branches/1.5/sqlobject/sqlite/sqliteconnection.py	Mon Oct 14 11:16:48 2013	(r4675)
+++ SQLObject/branches/1.5/sqlobject/sqlite/sqliteconnection.py	Sun Dec  8 08:54:13 2013	(r4676)
@@ -89,11 +89,7 @@
         self._threadPool = {}
         self._threadOrigination = {}
         if self._memory:
-            self._memoryConn = sqlite.connect(
-                self.filename, **self._connOptions)
-            # Convert text data from SQLite to str, not unicode -
-            # SQLObject converts it to unicode itself.
-            self._memoryConn.text_factory = str
+            self.makeMemoryConnection()
 
     @classmethod
     def _connectionFromParams(cls, user, password, host, port, path, args):
@@ -184,6 +180,13 @@
             return
         conn.isolation_level = level
 
+    def makeMemoryConnection(self):
+        self._memoryConn = self.module.connect(
+            self.filename, **self._connOptions)
+        # Convert text data from SQLite to str, not unicode -
+        # SQLObject converts it to unicode itself.
+        self._memoryConn.text_factory = str
+
     def makeConnection(self):
         if self._memory:
             return self._memoryConn
@@ -194,6 +197,9 @@
     def close(self):
         DBAPI.close(self)
         self._threadPool = {}
+        if self._memory:
+            self._memoryConn.close()
+            self.makeMemoryConnection()
 
     def _executeRetry(self, conn, cursor, query):
         if self.debug:

Modified: SQLObject/branches/1.5/sqlobject/tests/dbtest.py
==============================================================================
--- SQLObject/branches/1.5/sqlobject/tests/dbtest.py	Mon Oct 14 11:16:48 2013	(r4675)
+++ SQLObject/branches/1.5/sqlobject/tests/dbtest.py	Sun Dec  8 08:54:13 2013	(r4676)
@@ -41,6 +41,7 @@
     '-emptyTable': 'mssql',
     '-limitSelect' : 'mssql',
     '+schema' : 'postgres',
+    '+memorydb': 'sqlite',
     }
 
 

Modified: SQLObject/branches/1.5/sqlobject/tests/test_sqlite.py
==============================================================================
--- SQLObject/branches/1.5/sqlobject/tests/test_sqlite.py	Mon Oct 14 11:16:48 2013	(r4675)
+++ SQLObject/branches/1.5/sqlobject/tests/test_sqlite.py	Sun Dec  8 08:54:13 2013	(r4676)
@@ -104,3 +104,16 @@
     test = TestSO1(name=None, passwd='')
     assert test.name is None
     assert test.passwd == ''
+
+def test_memorydb():
+    if not supports("memorydb"):
+        return
+    connection = getConnection()
+    if connection.dbName != "sqlite":
+        return
+    if not connection._memory:
+        return
+    setupClass(TestSO1)
+    connection.close() # create a new connection to an in-memory database
+    TestSO1.setConnection(connection)
+    TestSO1.createTable()