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

Timestamp:

Oct 10, 2015, 2:11:52 PM (11 years ago)

Author:

eugene

Message:

fix test for table existence (Chip.psf vs Chip_psf)

File:

• trunk/ippToPsps/jython/stackbatch.py (modified) (9 diffs)

trunk/ippToPsps/jython/stackbatch.py

@@ -549 +549 @@
                 continue
 
-            cmfTable = filter + "SkyChip_xsrc"
+            cmfTable = filter + "SkyChip.xsrc"
+            mysTable = filter + "SkyChip_xsrc"
             if not cmfTable in self.tablesLoaded:
                 self.logger.infoPair("no xsrc data for filter" , filter) 
@@ -630 +631 @@
             return True
 
-        cmfTable = filter + "SkyChip_xfit"
+        cmfTable = filter + "SkyChip.xfit"
+        mysTable = filter + "SkyChip_xfit"
         if not cmfTable in self.tablesLoaded:
             self.logger.infoPair("no xfit data for filter" , filter) 
             return True
 
-        if self.scratchDb.getRowCount(cmfTable) <=0 :
+        if self.scratchDb.getRowCount(mysTable) <=0 :
             self.logger.infoPair("no extended source information, trying to skip",filter)
             return True
@@ -644 +646 @@
         magtime = "%.5f" % (2.5*math.log10(float(header['EXPTIME'])))
 
-        sqlLine = sqlUtility("UPDATE " + tablename + " AS a, " + cmfTable + " AS b SET")
+        sqlLine = sqlUtility("UPDATE " + tablename + " AS a, " + mysTable + " AS b SET")
 
         sqlLine.group("a."+filter+"haveData",              "'1'")
@@ -798 +800 @@
             return True
 
-        cmfTable = filter + "SkyChip_xsrc"
+        cmfTable = filter + "SkyChip.xsrc"
+        mysTable = filter + "SkyChip_xsrc"
         if not cmfTable in self.tablesLoaded:
             self.logger.infoPair("no xsrc data for filter" , filter) 
             return True
 
-        if self.scratchDb.getRowCount(cmfTable) <=0 :
+        if self.scratchDb.getRowCount(mysTable) <=0 :
             self.logger.infoPair("no extended source information, trying to skip", filter)
             return True
@@ -817 +820 @@
 
         self.logger.infoPair("Adding", "petrosians for extended sources")
-        sqlLine = sqlUtility("UPDATE " + tablename + " AS a, " + cmfTable + " AS b SET")
+        sqlLine = sqlUtility("UPDATE " + tablename + " AS a, " + mysTable + " AS b SET")
 
         sqlLine.group("a."+filter+"haveData",         "'1'")
@@ -951 +954 @@
 
         # set the flux values from the cmf file
-        cmfTable = filter + "SkyChip_xrad"
+        cmfTable = filter + "SkyChip.xrad"
+        mysTable = filter + "SkyChip_xrad"
 
         # skip this table if it was not loaded from the cmf
@@ -959 +963 @@
 
         # we have variable numbers of these columns. find out which are in use
-        sql = "DESCRIBE " + cmfTable + " 'aper_fill_%'"
+        sql = "DESCRIBE " + mysTable + " 'aper_fill_%'"
         rs = self.scratchDb.executeQuery(sql)
         rs.first()
@@ -983 +987 @@
 
         # generate the sql to do the necessary ops on the columns    
-        sqlLine = sqlUtility("UPDATE " + tablename + " AS a, " + cmfTable + " AS b SET ")
+        sqlLine = sqlUtility("UPDATE " + tablename + " AS a, " + mysTable + " AS b SET ")
 
         sqlLine.group("a."+filter+"haveData", "'1'")
@@ -1116 +1120 @@
             self.logger.infoPair("Creating indexes on", "IPP tables")
 
-            cmfTable = filter + "SkyChip_psf"
-            if cmfTable in self.tablesLoaded: self.scratchDb.createIndex(cmfTable, "IPP_IDET")
-
-            cmfTable = filter + "SkyChip_xfit"
-            if cmfTable in self.tablesLoaded: self.scratchDb.createIndex(cmfTable, "IPP_IDET")
-
-            cmfTable = filter + "SkyChip_xrad"
-            if cmfTable in self.tablesLoaded: self.scratchDb.createIndex(cmfTable, "IPP_IDET")
-
-            cmfTable = filter + "SkyChip_xsrc"
-            if cmfTable in self.tablesLoaded: self.scratchDb.createIndex(cmfTable, "IPP_IDET")
+            cmfTable = filter + "SkyChip.psf"
+            mysTable = filter + "SkyChip_psf"
+            if cmfTable in self.tablesLoaded: self.scratchDb.createIndex(mysTable, "IPP_IDET")
+
+            cmfTable = filter + "SkyChip.xfit"
+            mysTable = filter + "SkyChip_xfit"
+            if cmfTable in self.tablesLoaded: self.scratchDb.createIndex(mysTable, "IPP_IDET")
+
+            cmfTable = filter + "SkyChip.xrad"
+            mysTable = filter + "SkyChip_xrad"
+            if cmfTable in self.tablesLoaded: self.scratchDb.createIndex(mysTable, "IPP_IDET")
+
+            cmfTable = filter + "SkyChip.xsrc"
+            mysTable = filter + "SkyChip_xsrc"
+            if cmfTable in self.tablesLoaded: self.scratchDb.createIndex(mysTable, "IPP_IDET")
 
         return True