Changeset 37133 for branches/eam_branches/ipp-20140717/ippToPsps/jython/sqlUtility.py

Timestamp:

Jul 29, 2014, 9:52:00 AM (12 years ago)

Author:

eugene

Message:

scatter some debugging prints around; replace safeDictionaryAccess (terrible name) with getKeyValue; fix use of strings vs sql words in insert queries; fix detections for new schema; remove use of old dvograbber-based code; clean some avoidable errors

File:

• branches/eam_branches/ipp-20140717/ippToPsps/jython/sqlUtility.py (modified) (2 diffs)

branches/eam_branches/ipp-20140717/ippToPsps/jython/sqlUtility.py

@@ -16 +16 @@
     
     def group(self,field,value):
+        print "group field: " + field + ", value: " + value
         self.fields.append(field)
         self.values.append(value)
         return
 
-    def make(self,middleString,endString):
+    def makeRaw(self,middleString,endString):
 
         output = self.startString
@@ -40 +41 @@
         return output
 
+    def make(self,middleString,endString):
+
+        output = self.startString
+
+        for i in range(len(self.fields)):
+            output += self.fields[i]
+            if (i < len(self.fields) - 1):
+                output += ", "
+
+        output += middleString
+
+        for i in range(len(self.values)):
+            output += "'" + self.values[i] + "'"
+            if (i < len(self.values) - 1):
+                output += ", "
+        
+        output += endString
+
+        return output
+
     # when we do a sql insert, we have a command that looks like this:
     # INSERT INTO Table (field1, field2,...) OPERATION (value1, value2,...)