Changeset 40215 for trunk

Timestamp:

Nov 27, 2017, 1:24:35 PM (9 years ago)

Author:

heather

Message:

fixes -999 / ap flux bug jira ticket 6, tested with SAS42 dvo

File:

• trunk/ippToPsps/jython/stackbatch.py (modified) (1 diff)

trunk/ippToPsps/jython/stackbatch.py

@@ -1019 +1019 @@
         # care of this, but does not?
 
-        sqlLine = sqlUtility("UPDATE " + tablename + " SET")
-        for radius in [1, 2, 3, 4, 5, 6, 7, 8, 9]:
-            if radius < minRadius: continue
-            if radius > maxRadius: continue
-            pspsRadius = radius + 2
-            sqlLine.group(filter + prefix + "flxR" + str(pspsRadius),          "-999")
-            sqlLine.group(filter + prefix + "flxR" + str(pspsRadius) + "Err",  "-999")
-            sqlLine.group(filter + prefix + "flxR" + str(pspsRadius) + "Std",  "-999")
-            sqlLine.group(filter + prefix + "flxR" + str(pspsRadius) + "Fill", "-999")
-
-        sql = sqlLine.makeEquals("")
+#chopping this out to see if it still works
+
+        #sqlLine = sqlUtility("UPDATE " + tablename + " SET")
+        #for radius in [1, 2, 3, 4, 5, 6, 7, 8, 9]:
+        #    if radius < minRadius: continue
+        #    if radius > maxRadius: continue
+        #    pspsRadius = radius + 2
+        #    sqlLine.group(filter + prefix + "flxR" + str(pspsRadius),          "-999")
+        #    sqlLine.group(filter + prefix + "flxR" + str(pspsRadius) + "Err",  "-999")
+        #    sqlLine.group(filter + prefix + "flxR" + str(pspsRadius) + "Std",  "-999")
+        #    sqlLine.group(filter + prefix + "flxR" + str(pspsRadius) + "Fill", "-999")#
+
+        #sql = sqlLine.makeEquals("")
         
-        try: self.scratchDb.execute(sql)
-        except:
-            self.logger.errorPair('failed sql',sql)
-            raise
+#        try: self.scratchDb.execute(sql)
+#        except:
+#            self.logger.errorPair('failed sql',sql)
+#            raise
 
         # set the flux values from the cmf file