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

Timestamp:

Jul 31, 2014, 10:59:37 AM (12 years ago)

Author:

eugene

Message:

adding stack mags to dvopsps detection output; adding option to reset the dvoDetections table; adding makeEquals to sqlUtilities; intelligently(?) select photcode ranges for dvopsps; massive re-work of stackbatch.py

File:

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

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

@@ -21 +21 @@
         return
 
+    # result is startString + fields + middleString + values + endString
     def makeRaw(self,middleString,endString):
 
-        output = self.startString
+        output = self.startString + " "
 
         for i in range(len(self.fields)):
@@ -30 +31 @@
                 output += ", "
 
-        output += middleString
+        output += " " + middleString + "  "
 
         for i in range(len(self.values)):
@@ -37 +38 @@
                 output += ", "
         
-        output += endString
+        output += " " + endString
 
         return output
 
+    # result is startString + fields + middleString + values + endString (each value surrounded by '')
     def make(self,middleString,endString):
 
-        output = self.startString
+        output = self.startString + " "
 
         for i in range(len(self.fields)):
@@ -50 +52 @@
                 output += ", "
 
-        output += middleString
+        output += " " + middleString + " "
 
         for i in range(len(self.values)):
@@ -57 +59 @@
                 output += ", "
         
-        output += endString
+        output += " " + endString
+
+        return output
+
+    # result is startString + field = value,... + endString
+    def makeEquals(self,endString):
+
+        output = self.startString + " "
+
+        for i in range(len(self.fields)):
+            output += self.fields[i] + " = " + self.values[i]
+            if (i < len(self.fields) - 1):
+                output += ", "
+        
+        output += " " + endString
 
         return output