Changeset 38602 for trunk/ippToPsps/jython/diffbatch.py

Timestamp:

Jul 18, 2015, 9:55:43 PM (11 years ago)

Author:

heather

Message:

SAS39 final tweaks (added infoFlag3)

File:

• trunk/ippToPsps/jython/diffbatch.py (modified) (5 diffs)

trunk/ippToPsps/jython/diffbatch.py

@@ -163 +163 @@
       
        # make some generic tables
-           sql = "CREATE TABLE DiffMeta_"+str(num)+" like DiffMeta"
-           try: self.scratchDb.execute(sql)
-           except: raise
-           sql = "CREATE TABLE DiffToImage_"+str(num)+" like DiffToImage"
-           try: self.scratchDb.execute(sql)
-           except: raise
-           sql = "CREATE TABLE DiffDetection_"+str(num)+" like DiffDetection"
-           try: self.scratchDb.execute(sql)
-           except: raise
+           #sql = "CREATE TABLE DiffMeta_"+str(num)+" like DiffMeta"
+           #try: self.scratchDb.execute(sql)
+           #except: raise
+           #sql = "CREATE TABLE DiffToImage_"+str(num)+" like DiffToImage"
+           #try: self.scratchDb.execute(sql)
+           #except: raise
+           #sql = "CREATE TABLE DiffDetection_"+str(num)+" like DiffDetection"
+           #try: self.scratchDb.execute(sql)
+           #except: raise
 
 
@@ -199 +199 @@
         diffSkyFileID = self.number[num]
         self.logger.infoPair("Proccesing table", "DiffMeta_"+str(num))
+
+        sql = "CREATE TABLE DiffMeta_"+str(num)+" like DiffMeta"
+        try: self.scratchDb.execute(sql)
+        except: raise
 
         sqlLine = sqlUtility("INSERT INTO DiffMeta_"+str(num)+" (")
@@ -246 +250 @@
         ippTableName =  "SkyChip_psf_"+str(num)
         diffSkyFileID = self.number[num]
+        sql = "CREATE TABLE DiffDetection_"+str(num)+" like DiffDetection"
+        try: self.scratchDb.execute(sql)
+        except: raise
         #results['ORIGINALTOTAL'] = self.scratchDb.getRowCount(ippTableName)
 
@@ -405 +412 @@
         self.logger.infoPair("Procesing table", "DiffToImage")
 
+        sql = "CREATE TABLE DiffToImage_"+str(num)+" like DiffToImage"
+        try: self.scratchDb.execute(sql)
+        except: raise
+        #sql = "CREATE TABLE DiffDetection_"+str(num)+" like DiffDetection"
+        #try: self.scratchDb.execute(sql)
+        #except: raise
         imageIDs = self.gpc1Db.getImageIDsForThisDiffID(int(diffSkyFileID))
 
@@ -481 +494 @@
                a.airmass      = b.airmass, \
                a.expTime      = b.expTime, \
-               a.infoFlag2    = (b.flags << 13) | a.infoFlag2 \
+               a.infoFlag3    = b.flags  \
                WHERE a.ippDetectID = b.ippDetectID \
                AND b.imageID = " + str(imageID)