Changeset 38237 for trunk/ippToPsps/jython/detectionbatch.py

Timestamp:

May 6, 2015, 5:54:23 PM (11 years ago)

Author:

heather

Message:

small changes for schema 20 - expect p2s to work now

File:

• trunk/ippToPsps/jython/detectionbatch.py (modified) (2 diffs)

trunk/ippToPsps/jython/detectionbatch.py

@@ -323 +323 @@
 
         sqlLine.group("frameID",          str(self.expID))
-        sqlLine.group("magref",           self.getKeyFloat(header,"%.8f","MAGREF")
+        sqlLine.group("magref",           self.getKeyFloat(header,"%.8f","MAGREF"))
         sql = sqlLine.make(") VALUES ( ", ")")
+                      
         try: self.scratchDb.execute(sql)
         except:
@@ -340 +341 @@
                       stringint.rjust(2, '0')
                       sqlLine = sqlUtility("INSERT INTO " + tableName + "(")
-                      sqlLine.group("offset"+stringint", "OFFSET")
-                      sqlLine.group("counts"+stringint", "COUNTS")
-                      sqlLine.group("diffMean"+stringint", "DIFF.MEAN")
-                      sqlLine.group("diffStdev01"+stringint", "DIFF.STDEV")
-                      sqlLine.group("errMean01"+stringing", "ERR.MEAN")
-                      sql = sqlLine.makeRaw(") SELECT ", "FROM " + ippTableName + " WHERE table_index = " + str(i)")
+                      sqlLine.group("offset"+stringint, "OFFSET")
+                      sqlLine.group("counts"+stringint, "COUNTS")
+                      sqlLine.group("diffMean"+stringint, "DIFF.MEAN")
+                      sqlLine.group("diffStdev01"+stringint, "DIFF.STDEV")
+                      sqlLine.group("errMean01"+stringing, "ERR.MEAN")
+                      sql = sqlLine.makeRaw(") SELECT ", "FROM " + ippTableName + " WHERE table_index = " + str(i))
                       try: self.scratchDb.execute(sql)
                       except: