Changeset 38906 for trunk/ippToPsps/jython/stackbatch.py

Timestamp:

Oct 20, 2015, 4:05:47 PM (11 years ago)

Author:

watersc1

Message:

Change to mkcmf.c to make index=2 petRadErr = NAN to exercise a case for ipp2psps. Change to stackbatch.py in ipp2psps to catch these NAN values and convert them into a best-guess of 10% of the petRad value.

File:

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

trunk/ippToPsps/jython/stackbatch.py

@@ -854 +854 @@
             raise
 
+        # modify petRadiusErr if it is not set correctlyu
+
+        sqlLine = sqlUtility("UPDATE " + tablename + " AS a SET")
+        sqlLine.group("a." + filter + "petRadiusErr", "a." + filter + "petRadius * 0.1")
+        sql = sqlLine.makeEquals("WHERE a." + filter + "petRadiusErr IS NULL")
+
+        try: self.scratchDb.execute(sql)
+        except:
+            self.logger.errorPair('failed sql',sql)
+            raise
+
+
     '''
     Populates the StackApFlx table