Changeset 108

Timestamp:

11/26/05 04:29:39

Author:

fumanchu

Message:

New "version" method for db SM's.

Files:

• trunk/storage/storeado.py (modified) (2 diffs)
• trunk/storage/storemysql.py (modified) (1 diff)
• trunk/storage/storepypgsql.py (modified) (1 diff)
• trunk/storage/storeshelve.py (modified) (1 diff)
• trunk/storage/storesqlite.py (modified) (1 diff)
• trunk/test/zoo_fixture.py (modified) (1 diff)

trunk/storage/storeado.py

@@ -398 +398 @@
-        
-        return data, columns
+        
+    def version(self):
+        adoconn = win32com.client.Dispatch(r'ADODB.Connection')
+        return "ADO Version: %s" % adoconn.Version
-
-
@@ -648 +652 @@
-            os.remove(self.dbname)
-
+
-def gen_py():
-
-
++
++
-    CLSID = '{EF53050B-882E-4776-B643-EDA472E8E3F2}'
-    return win32com.client.gencache.EnsureModule(CLSID, 0, 2, 7)

trunk/storage/storemysql.py

@@ -193 +193 @@
-        conn.close()
-    
+    def version(self):
+        conn = self._template_conn()
+        rowdata, cols = self.fetch("SELECT version();", conn)
+        conn.close()
+        return "MySQL Version: %s" % rowdata[0][0]
+    
-    def create_storage(self, unitClass):
-        # MySQL won't allow indexes on a BLOB field without a specific length.

trunk/storage/storepypgsql.py

@@ -88 +88 @@
-        c.finish()
-    
+    def version(self):
+        c = self._template_conn()
+        v = c.version
+        c.finish()
+        return v
+    
-    def fetch(self, query, conn=None):
-        """fetch(query, conn=None) -> rowdata, columns."""

trunk/storage/storeshelve.py

@@ -117 +117 @@
-            os.remove(tbl)
-    
+    def version(self):
+        import sys
+        return "Shelve version: %s" % sys.version
+    
-    def create_storage(self, unitClass):
-        pass

trunk/storage/storesqlite.py

@@ -171 +171 @@
-        # This should accept relative or absolute paths
-        os.remove(self.database)
+    
+    def version(self):
+        return "SQLite Version: %s" % _sqlite.sqlite_version()
-    
-    def execute(self, query, conn=None):

trunk/test/zoo_fixture.py

@@ -513 +513 @@
-    global arena
-    arena.add_store('testSM', SM_class, opts)
+    v = getattr(arena.stores['testSM'], "version", None)
+    if v:
+        print v()
+    
-    arena.register_all(globals())
-