Changeset 29349 for trunk/ippTools/share/warptool_scmap.sql

Timestamp:

Oct 7, 2010, 3:04:31 PM (16 years ago)

Author:

bills

Message:

for update processing left join back to the magicDSRun and magicDSFile and
output the run state and fault. Used by pstamp_checkdependent

File:

• trunk/ippTools/share/warptool_scmap.sql (modified) (2 diffs)

trunk/ippTools/share/warptool_scmap.sql

@@ -7 +7 @@
     chipRun.state,
     chipProcessedImfile.data_state,
+    chipProcessedImfile.fault AS chip_fault,
     chipProcessedImfile.magicked,
-    rawImfile.magicked AS raw_magicked
+    rawImfile.magicked AS raw_magicked,
+    IFNULL(magicDSRun.magic_ds_id, 0) AS magic_ds_id,
+    IFNULL(magicDSRun.state, 0) AS dsRun_state,
+    IFNULL(magicDSFile.fault, 0) as dsFile_fault
 FROM warpRun
 JOIN warpSkyCellMap
@@ -26 +30 @@
     ON chipRun.exp_id = rawImfile.exp_id
     AND chipProcessedImfile.class_id = rawImfile.class_id
+LEFT JOIN magicDSRun
+    ON chipRun.chip_id = magicDSRun.stage_id AND magicDSRun.stage = 'chip'
+LEFT JOIN magicDSFile
+    ON magicDSFile.magic_ds_id = magicDSRun.magic_ds_id 
+        AND chipProcessedImfile.class_id = magicDSFile.component
 WHERE
     1