Changeset 38802 for trunk/ippToPsps/jython/stackbatch.py
- Timestamp:
- Oct 6, 2015, 4:13:12 PM (11 years ago)
- File:
-
- 1 edited
-
trunk/ippToPsps/jython/stackbatch.py (modified) (6 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/ippToPsps/jython/stackbatch.py
r38801 r38802 361 361 raise 362 362 363 # insert values coming from the CMF, not carried by DVO364 header = self.headerSet[filter]365 exptime = self.getKeyFloat(header, "%.5f", "EXPTIME")366 367 363 sqlLine = sqlUtility("UPDATE StackObjectThin AS a , " + filter + "SkyChip_psf AS b SET") 368 364 … … 424 420 header = self.headerSet[filter] 425 421 exptime = self.getKeyFloat(header, "%.5f", "EXPTIME") 422 expTimeString = str(exptime) 426 423 427 424 # insert all the detections … … 447 444 sqlLine.group("a."+filter+"momentR1", "b.MOMENTS_R1 * b.PLTSCALE") 448 445 sqlLine.group("a."+filter+"momentRH", "b.MOMENTS_RH * b.PLTSCALE") 449 sqlLine.group("a."+filter+"PSFFlux", "b.PSF_INST_FLUX / " + str(exptime))450 sqlLine.group("a."+filter+"PSFFluxErr", "b.PSF_INST_FLUX_SIG / " + str(exptime))451 sqlLine.group("a."+filter+"ApFlux", "b.AP_FLUX / " + str(exptime))452 sqlLine.group("a."+filter+"ApFluxErr", "b.AP_FLUX_SIG / " + str(exptime))453 sqlLine.group("a."+filter+"KronFlux", "b.KRON_FLUX / " + str(exptime))454 sqlLine.group("a."+filter+"KronFluxErr", "b.KRON_FLUX_ERR / " + str(exptime))446 sqlLine.group("a."+filter+"PSFFlux", "b.PSF_INST_FLUX / " + expTimeString) 447 sqlLine.group("a."+filter+"PSFFluxErr", "b.PSF_INST_FLUX_SIG / " + expTimeString) 448 sqlLine.group("a."+filter+"ApFlux", "b.AP_FLUX / " + expTimeString) 449 sqlLine.group("a."+filter+"ApFluxErr", "b.AP_FLUX_SIG / " + expTimeString) 450 sqlLine.group("a."+filter+"KronFlux", "b.KRON_FLUX / " + expTimeString) 451 sqlLine.group("a."+filter+"KronFluxErr", "b.KRON_FLUX_ERR / " + expTimeString) 455 452 sqlLine.group("a."+filter+"ApFillFac", "b.AP_NPIX / (3.14159265359 * POW(b.AP_MAG_RADIUS - 0.5, 2))") 456 453 sqlLine.group("a."+filter+"ApRadius", "b.AP_MAG_RADIUS") … … 458 455 sqlLine.group("a."+filter+"PlateScale", "b.PLTSCALE") 459 456 sqlLine.group("a."+filter+"ExtNSigma", "b.EXT_NSIGMA") 460 sqlLine.group("a."+filter+"sky", "b.SKY / " + str(exptime))461 sqlLine.group("a."+filter+"skyErr", "b.SKY_SIGMA / " + str(exptime))457 sqlLine.group("a."+filter+"sky", "b.SKY / " + expTimeString) 458 sqlLine.group("a."+filter+"skyErr", "b.SKY_SIGMA / " + expTimeString) 462 459 463 460 sql = sqlLine.makeEquals("WHERE a." + filter + "ippDetectID = b.IPP_IDET") … … 531 528 continue 532 529 533 header = self.headerSet[filter]534 exptime = self.getKeyFloat(header, "%.5f", "EXPTIME")535 536 530 # insert all the detections 537 531 sqlLine = sqlUtility("UPDATE " + tablename + " AS a , " + filter + "SkyChip_xsrc AS b SET") 538 532 539 sqlLine.group("a."+filter+"haveData", "'1'")540 sqlLine.group("a."+filter+"S2", "b.G_S2")533 sqlLine.group("a."+filter+"haveData", "'1'") 534 sqlLine.group("a."+filter+"S2", "b.G_S2") 541 535 sqlLine.group("a."+filter+"logRT", "b.G_RT") 542 536 sqlLine.group("a."+filter+"logRA", "b.G_RA") 543 537 sqlLine.group("a."+filter+"bumpy", "b.G_BUMPY") 544 sqlLine.group("a."+filter+"halfLightRad", "b.HALF_LIGHT_RADIUS") 538 sqlLine.group("a."+filter+"halfLightRad", "b.HALF_LIGHT_RADIUS") 539 545 540 sql = sqlLine.makeEquals("WHERE a." + filter + "ippDetectID = b.IPP_IDET") 546 541 … … 781 776 # PETRO_MAG is instrumental + 2.5log(exptime) + FPA.ZP 782 777 # we want to apply the DVO zero point, so remove FPA.ZP: 778 ## XXX is this statement true: is FPA.ZP + 2.5log(exptime) applied to PETRO_MAG? 783 779 784 780 hdrZP = "%.5f" % float(header['FPA.ZP']) 785 #magtime = "%.5f" % (2.5*math.log10(float(header['EXPTIME'])))781 magtime = "%.5f" % (2.5*math.log10(float(header['EXPTIME']))) 786 782 787 783 self.logger.infoPair("Adding", "petrosians for extended sources")
Note:
See TracChangeset
for help on using the changeset viewer.
