Changeset 31202 for trunk/ippToPsps

Timestamp:

Apr 6, 2011, 1:07:43 PM (15 years ago)

Author:

rhenders

Message:

method to fudge objIDs for time-being

File:

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

trunk/ippToPsps/jython/stackbatch.py

@@ -32 +32 @@
        self.filter = self.filter[0:1]
 
-       # create an output filename, which is {skycellID}{filterID}.FITS
-       self.outputFitsPath = "%s%07d.FITS" % (self.filter, skyID);
+       # create an output filename, which is {filterID}{skycellID}.FITS
+       self.outputFitsFile = "%s%07d.FITS" % (self.filter, int(self.skycell));
+       self.outputFitsPath = "%s/%s" % (self.localOutPath, self.outputFitsFile);
 
        # set some constants
@@ -226 +227 @@
         self.updateFilterID("StackMeta")
         self.updateStackTypeID("StackMeta")
+        self.updateDataRelease("StackMeta")
 
     '''
@@ -386 +388 @@
 
     '''
+    '''
+    def fudgeIDs(self):
+
+        self.log("Creating bogus IDs on all detections")
+
+        sql = "INSERT INTO dvo (ippDetectID) SELECT IPP_IDET FROM SkyChip_psf";
+        self.localStmt.execute(sql)
+
+        sql = "SELECT ippDetectID FROM dvo"
+        rs = self.localStmt.executeQuery(sql)
+
+        ids = []
+        while (rs.next()):
+            ids.append(rs.getInt(1))
+
+        i = 1
+        o = 72010000000000001
+
+        for id in ids:
+            sql = "UPDATE dvo SET ippObjID = %d, objID = %d WHERE ippDetectID = %s" % (i, o, id)
+            self.localStmt.execute(sql)
+            i = i + 1
+            o = o + 1
+
+        self.updateDvoIDs("StackDetection")
+        self.updateDvoIDs("StackApFlx")
+        self.updateDvoIDs("StackModelFit")
+        
+        self.setMinMaxObjID("StackDetection")
+
+    '''
     Does the processing, i.e. pulling stuff from IPP tables into PSPS tables
     '''
@@ -405 +438 @@
 
     stackBatch = StackBatch(sky_id, file)
+    
     stackBatch.createEmptyPspsTables()
-    stackBatch.importIppTables("")
+    #stackBatch.importIppTables("")
     stackBatch.populatePspsTables()
-    stackBatch.reportNullsInAllPspsTables(False)
-    #stackBatch.replaceAllPspsNulls("-999")
+    stackBatch.fudgeIDs()
+    #stackBatch.reportNullsInAllPspsTables(False)
+    #stackBatch.replaceAllPspsNulls("-999")  
     stackBatch.exportPspsTablesToFits()
+    stackBatch.writeBatchManifest()
+
     i = i + 1
     if i > 0: break # TODO just doing one filter for now