Changeset 19137

Timestamp:

Aug 20, 2008, 11:46:58 AM (18 years ago)

Author:

eugene

Message:

adding references back to source exposures

Location:

trunk/ippMonitor/def

Files:

• warpProcessedSkyfiles.d (modified) (3 diffs)
• warpStageSkyfileInputs.d (modified) (5 diffs)

trunk/ippMonitor/def/warpProcessedSkyfiles.d

@@ -18 +18 @@
 ARGS  ARG6  warpSkyfile.skycell_id=$warpSkyfile.skycell_id
 
+ARGS  ARG8  warpRun.warp_id=$warpRun.warp_id
+ARGS  ARG8  warpSkyCellMap.skycell_id=$warpSkyfile.skycell_id
+
 ARGS  ARG7 warpRun.warp_id=$warpRun.warp_id
 ARGS  ARG7 warpSkyfile.skycell_id=$warpSkyfile.skycell_id
@@ -27 +30 @@
 
 #     field                    size  format  name         show    link to         extras
-FIELD rawExp.exp_name,            5, %s,     Exp Name
+FIELD rawExp.exp_name,            5, %s,     Exp Name,     value,  warpStageSkyfileInputs.php, ARG8
 FIELD rawExp.exp_id,              5, %d,     Exp ID,       value,  rawImfile.php,           ARG1
 FIELD chipRun.chip_id,            7, %d,     Chip ID,      value,  chipProcessedImfile.php, ARG2
@@ -35 +38 @@
 FIELD warpSkyfile.skycell_id,    10, %s,     skycell,      value,  warpProcessedSkyfiles.php, ARG6
 FIELD warpRun.state,              7, %s,     state,        value,  warpProcessedSkyfiles.php, ARG7
+FIELD warpRun.label,              7, %s,     label,        value
 FIELD warpSkyfile.tess_id,       10, %s,     tess
 FIELD warpSkyfile.good_frac,      5, %s,     good_frac

trunk/ippMonitor/def/warpStageSkyfileInputs.d

@@ -1 @@
-TABLE warpSkyCellMap, warpRun, fakeRun, camRun, chipRun, rawExp
+TABLE warpSkyCellMap, warpRun, fakeRun, camRun, chipRun, rawExp, chipProcessedImfile
 TITLE Warp Stage Skyfile Inputs
 FILE  warpStageSkyfileInputs.php
@@ -9 +9 @@
 WHERE camRun.chip_id = chipRun.chip_id
 WHERE chipRun.exp_id = rawExp.exp_id
+WHERE chipProcessedImfile.chip_id = chipRun.chip_id
+WHERE chipProcessedImfile.class_id = warpSkyCellMap.class_id
 
 ARGS  ARG1  rawImfile.exp_id=$rawExp.exp_id
@@ -16 +18 @@
 ARGS  ARG5  warpRun.warp_id=$warpRun.warp_id
 
+ARGS  ARG6  chipRun.chip_id=$chipRun.chip_id
+ARGS  ARG6  chipProcessedImfile.class_id=$warpSkyCellMap.class_id
+ARGS  ARG6  camera=$rawExp.camera
+ARGS  ARG6  basename=$chipProcessedImfile.path_base
+ARGS  ARG6  class=$warpSkyCellMap.class_id
+
 OP   OP1  $rawExp.ra * 57.295783
 OP   OP2  $rawExp.decl * 57.295783
@@ -21 +29 @@
 #     field                    size  format  name         show    link to         extras
 FIELD rawExp.exp_name,           10, %s,     Exp Name
-FIELD warpSkyCellMap.class_id,    8, %s,     Class ID
+FIELD warpSkyCellMap.class_id,    8, %s,     Class ID,     value,  chipProcessedImfile.php, ARG6
 FIELD rawExp.exp_id,              5, %d,     Exp ID,       value,  rawImfile.php,           ARG1
 FIELD chipRun.chip_id,            7, %d,     Chip ID,      value,  chipProcessedImfile.php, ARG2
@@ -44 +52 @@
 FIELD rawExp.comment,            65, %s,     Comment
 
+FIELD chipProcessedImfile.path_base, 65, %s, path_base, none
+
 # FIELD rawExp.bg_mean_stdev,    5, %7.2f,  <backgnd>
 # FIELD chipPendingExp.reduction,    20,   reduction