Changeset 43102

Timestamp:

Sep 22, 2026, 3:25:11 PM (41 hours ago)

Author:

eugene

Message:

the query to warpStageSkyfiles was using the warpSkyCellMap and not selecting the skycells, so there was a lot of duplication

File:

• branches/eam_branches/ipp-pstamp-20260421/ippMonitor/def/warpStageSkyfiles.d (modified) (3 diffs)

branches/eam_branches/ipp-pstamp-20260421/ippMonitor/def/warpStageSkyfiles.d

@@ -1 @@
-TABLE warpSkyCellMap JOIN warpRun USING (warp_id) JOIN fakeRun USING (fake_id) JOIN camRun USING (cam_id) JOIN chipRun USING (chip_id) JOIN rawExp USING (exp_id)
+TABLE warpSkyfile JOIN warpRun USING (warp_id) JOIN fakeRun USING (fake_id) JOIN camRun USING (cam_id) JOIN chipRun USING (chip_id) JOIN rawExp USING (exp_id)
 TITLE Warp Stage Skyfiles
 FILE  warpStageSkyfiles.php
@@ -12 +12 @@
 ARGS  ARG4  fakeRun.fake_id=$fakeRun.fake_id
 ARGS  ARG5  warpRun.warp_id=$warpRun.warp_id
-ARGS  ARG6  warpSkyfile.skycell_id=$warpSkyCellMap.skycell_id
 
 OP   OP1  $rawExp.ra * 57.295783
@@ -24 +23 @@
 FIELD fakeRun.fake_id,            7, %d,     Fake ID,      value,  fakeProcessedImfile.php, ARG4
 FIELD warpRun.warp_id,            7, %d,     Warp ID,      value,  warpStageExp.php, ARG5
-FIELD warpSkyCellMap.skycell_id, 10, %s,     skycell,      value,  warpProcessedSkyfiles.php, ARG6
+FIELD warpSkyfile.skycell_id,    10, %s,     skycell,      value,  warpProcessedSkyfiles.php, ARG6
 FIELD warpRun.state,              7, %s,     state
 FIELD warpRun.label,              7, %s,     label
 FIELD warpRun.data_group,         7, %s,     data grp
 FIELD warpRun.dist_group,         7, %s,     dist grp
-FIELD warpSkyCellMap.tess_id,    10, %s,     tess
-FIELD warpSkyCellMap.fault,      10, %s,     fault
+FIELD warpSkyfile.tess_id,       10, %s,     tess
+FIELD warpSkyfile.fault,         10, %s,     fault
 FIELD rawExp.telescope,          10, %s,     Telescope
 FIELD rawExp.camera,             10, %s,     Camera