r6412 - trunk/gnue-common/src/datasources/drivers/DBSIG2

[johannes]

Author: johannes
Date: 2004-09-28 02:57:50 -0500 (Tue, 28 Sep 2004)
New Revision: 6412

Modified:
   trunk/gnue-common/src/datasources/drivers/DBSIG2/DataObject.py
   trunk/gnue-common/src/datasources/drivers/DBSIG2/ResultSet.py
Log:
lower down cursor description's field names


Modified: trunk/gnue-common/src/datasources/drivers/DBSIG2/DataObject.py
===================================================================
--- trunk/gnue-common/src/datasources/drivers/DBSIG2/DataObject.py      
2004-09-27 20:36:02 UTC (rev 6411)
+++ trunk/gnue-common/src/datasources/drivers/DBSIG2/DataObject.py      
2004-09-28 07:57:50 UTC (rev 6412)
@@ -301,7 +301,7 @@
 class DataObject_Object(DataObject):
 
   def _buildQuery(self, conditions={}, forDetail=None, additionalSQL=""):
-    gDebug (7, 'Implicit Fields: %s' % self._fieldReferences)
+    gDebug (7, 'DBSIG2-DO::Implicit Fields: %s' % self._fieldReferences)
     if self.distinct:
       distinct = "distinct "
     else:

Modified: trunk/gnue-common/src/datasources/drivers/DBSIG2/ResultSet.py
===================================================================
--- trunk/gnue-common/src/datasources/drivers/DBSIG2/ResultSet.py       
2004-09-27 20:36:02 UTC (rev 6411)
+++ trunk/gnue-common/src/datasources/drivers/DBSIG2/ResultSet.py       
2004-09-28 07:57:50 UTC (rev 6412)
@@ -54,14 +54,19 @@
     self._fieldNames = []
 
     if self._cursor:
-      for t in(self._cursor.description):
-        if type(t[0])==types.UnicodeType:
-          self._fieldNames.append(t[0])
-        else:
-          self._fieldNames.append(unicode(t[0], 
self._dataObject._connection._encoding))
-        self._dataObject._fieldReferences[t[0]] = ""
-      gDebug (5, "Field names set to %s" % self._fieldNames)
+      for t in (self._cursor.description):
+        name = t [0].lower ()
 
+        if not isinstance (t [0], types.UnicodeType):
+          name = unicode (name, self._dataObject._connection._encoding)
+
+        gDebug (6, "Field from Cursordescription: %s new %s" % (t [0], name))
+
+        self._fieldNames.append (name)
+        self._dataObject._fieldReferences [name] = ""
+
+      gDebug (5, "DBSIG2::Fields from cursor set to %s" % self._fieldNames)
+
     self._recordCount = self._cursor.rowcount or 0
 
     gDebug (5, 'ResultSet created')