- Timestamp:
- Mar 30, 2012, 2:49:37 PM (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/eam_branches/ipp-20111122/ippToPsps/jython/detectionbatch.py
r32592 r33638 33 33 def __init__(self, 34 34 logger, 35 configPath, 36 configDoc, 35 config, 37 36 gpc1Db, 38 37 ippToPspsDb, 38 scratchDb, 39 39 camID, 40 batchID): 40 batchID, 41 useFullTables): 41 42 42 43 super(DetectionBatch, self).__init__( 43 44 logger, 44 configPath, 45 configDoc, 45 config, 46 46 gpc1Db, 47 47 ippToPspsDb, 48 scratchDb, 48 49 camID, 49 50 batchID, 50 51 "P2", 51 gpc1Db.getCameraStageSmf(camID)) 52 gpc1Db.getCameraStageSmf(camID), 53 useFullTables) 52 54 53 55 if not self.everythingOK: return … … 73 75 74 76 # if test mode 75 if self. testMode:77 if self.config.test: 76 78 self.startX = 3 77 79 self.endX = 4 … … 219 221 self.scratchDb.updateFilterID("FrameMeta", self.filter) 220 222 self.scratchDb.updateAllRows("FrameMeta", "calibModNum", str(self.calibModNum)) 221 self.scratchDb.updateAllRows("FrameMeta", "dataRelease", str(self. dataRelease))223 self.scratchDb.updateAllRows("FrameMeta", "dataRelease", str(self.config.dataRelease)) 222 224 223 225 ''' … … 322 324 ," + self.safeDictionaryAccess(header, 'DAPMIFIT') + " \ 323 325 ,'" + self.safeDictionaryAccess(header, 'DETECTOR') + "' \ 324 ," + str(self.scratchDb.getDvoImageFlags(header[' SOURCEID'], header['IMAGEID'])) + " \326 ," + str(self.scratchDb.getDvoImageFlags(header['IMAGEID'])) + " \ 325 327 ,'" + self.safeDictionaryAccess(header, 'DETREND.MASK') + "' \ 326 328 ,'" + self.safeDictionaryAccess(header, 'DETREND.DARK') + "' \ … … 366 368 self.scratchDb.updateFilterID(tableName, self.filter) 367 369 self.scratchDb.updateAllRows(tableName, "calibModNum", str(self.calibModNum)) 368 self.scratchDb.updateAllRows(tableName, "dataRelease", str(self. dataRelease))370 self.scratchDb.updateAllRows(tableName, "dataRelease", str(self.config.dataRelease)) 369 371 if 'NASTRO' in header: self.totalNumPhotoRef = self.totalNumPhotoRef + int(header['NASTRO']) 370 372 self.scratchDb.replaceNullsInThisColumn(tableName, "polyOrder", "0") … … 416 418 ,momentYY \ 417 419 ,apMag \ 418 ,kronFlux \419 ,kronFluxErr \420 420 ,infoFlag \ 421 421 ,sky \ … … 448 448 ,MOMENTS_YY \ 449 449 ,AP_MAG \ 450 ,KRON_FLUX \451 ,KRON_FLUX_ERR \452 450 ,FLAGS\ 453 451 ,SKY \ … … 457 455 , '" + self.dateStr + "' \ 458 456 , 0 \ 459 , " + str(self. dataRelease) + "\457 , " + str(self.config.dataRelease) + "\ 460 458 FROM " + ippTableName 461 459 self.scratchDb.execute(sql) … … 501 499 self.scratchDb.execute(sql) 502 500 503 self.scratchDb.updateAllRows(tableName, "dataRelease", str(self. dataRelease))501 self.scratchDb.updateAllRows(tableName, "dataRelease", str(self.config.dataRelease)) 504 502 505 503 ''' … … 530 528 531 529 self.scratchDb.updateAllRows(tableName, "calibModNum", str(self.calibModNum)) 532 self.scratchDb.updateAllRows(tableName, "dataRelease", str(self. dataRelease))530 self.scratchDb.updateAllRows(tableName, "dataRelease", str(self.config.dataRelease)) 533 531 534 532 … … 545 543 self.populateFrameMeta() 546 544 547 # dictionary objects to hold sourceIDs and imageIDs for later 548 self.sourceIDs = {} 545 # dictionary objects to hold imageIDs for later 549 546 self.imageIDs = {} 550 547 … … 578 575 579 576 # store these for later 580 self.sourceIDs[ota] = header['SOURCEID']581 577 self.imageIDs[ota] = header['IMAGEID'] 582 578 … … 614 610 Updates provided table with DVO IDs from DVO table 615 611 ''' 616 def updateDvoIDs(self, table, sourceID,externID):617 618 imageID = self.scratchDb.getImageIDFromExternID( sourceID,externID)612 def updateDvoIDs(self, table, externID): 613 614 imageID = self.scratchDb.getImageIDFromExternID(externID) 619 615 self.logger.debug("Updating table '" + table + "' with DVO IDs using imageID = %d" % imageID) 620 616 sql = "UPDATE IGNORE " + table + " AS a, " + self.scratchDb.dvoDetectionTable + " AS b SET \ … … 624 620 a.infoFlag = b.flags << 32 | a.infoFlag \ 625 621 WHERE a.ippDetectID = b.ippDetectID \ 626 AND b.sourceID = " + str(sourceID) + " \627 622 AND b.imageID = " + str(imageID) 628 623 … … 655 650 656 651 ota = "XY%d%d" % (x, y) 657 if ota not in self. sourceIDs: continue652 if ota not in self.imageIDs: continue 658 653 659 654 #self.logger.infoTitle("Processing " + ota) … … 666 661 667 662 # now add DVO IDs 668 self.updateDvoIDs("Detection_" + ota, self. sourceIDs[ota], self.imageIDs[ota])663 self.updateDvoIDs("Detection_" + ota, self.imageIDs[ota]) 669 664 results['NULLOBJID'] = self.scratchDb.reportAndDeleteRowsWithNULLS("Detection_" + ota, "objID") 670 665 self.updateImageID("Detection_" + ota, x, y) … … 693 688 # update ImageMeta with count of detections for this OTA and photoCodeID 694 689 sql = "UPDATE ImageMeta_" + ota + " \ 695 SET nDetect = %d, photoCalID = %d" % (self.scratchDb.getRowCount("Detection_" + ota), self.scratchDb.getPhotoCalID(self. sourceIDs[ota], self.imageIDs[ota]))690 SET nDetect = %d, photoCalID = %d" % (self.scratchDb.getRowCount("Detection_" + ota), self.scratchDb.getPhotoCalID(self.imageIDs[ota])) 696 691 self.scratchDb.execute(sql) 697 692 … … 757 752 def importIppTables(self, filter=""): 758 753 759 if self. testMode: regex = "XY33.psf"754 if self.config.test: regex = "XY33.psf" 760 755 else : regex = ".*.psf" 761 756 762 columns = "IPP_IDET X_PSF Y_PSF X_PSF_SIG Y_PSF_SIG PSF_INST_MAG PSF_INST_MAG_SIG PEAK_FLUX_AS_MAG PSF_MAJOR PSF_MINOR PSF_THETA EXT_NSIGMA PSF_QF MOMENTS_XX MOMENTS_XY MOMENTS_YY AP_MAG KRON_FLUX KRON_FLUX_ERRFLAGS SKY SKY_SIGMA EXT_NSIGMA"757 columns = "IPP_IDET X_PSF Y_PSF X_PSF_SIG Y_PSF_SIG PSF_INST_MAG PSF_INST_MAG_SIG PEAK_FLUX_AS_MAG PSF_MAJOR PSF_MINOR PSF_THETA EXT_NSIGMA PSF_QF MOMENTS_XX MOMENTS_XY MOMENTS_YY AP_MAG FLAGS SKY SKY_SIGMA EXT_NSIGMA" 763 758 764 759 return super(DetectionBatch, self).importIppTables(columns, regex)
Note:
See TracChangeset
for help on using the changeset viewer.
