Changeset 20792 for trunk/ippTools/share/magicdstool_todestreak.sql

Timestamp:

Nov 17, 2008, 3:57:56 PM (18 years ago)

Author:

bills

Message:

changed some names

File:

• trunk/ippTools/share/magicdstool_todestreak.sql (modified) (7 diffs)

trunk/ippTools/share/magicdstool_todestreak.sql

@@ -32 +32 @@
 JOIN camProcessedExp USING(cam_id)
 JOIN rawImfile ON magicRun.exp_id = rawImfile.exp_id
-LEFT JOIN magicDSImfile
-    ON magicDSRun.magic_ds_id = magicDSImfile.magic_ds_id
-    AND magicDSImfile.component = rawImfile.class_id
+LEFT JOIN magicDSFile
+    ON magicDSRun.magic_ds_id = magicDSFile.magic_ds_id
+    AND magicDSFile.component = rawImfile.class_id
 WHERE
     magicDSRun.state = 'run'
     AND magicDSRun.stage = 'raw'
-    AND magicDSImfile.component IS NULL
+    AND magicDSFile.component IS NULL
 UNION
   -- chipProcesedImfiles
@@ -75 +75 @@
 JOIN chipProcessedImfile USING(chip_id)
 JOIN rawExp ON chipRun.exp_id = rawExp.exp_id
-LEFT JOIN magicDSImfile
-    ON magicDSRun.magic_ds_id = magicDSImfile.magic_ds_id
-    AND magicDSImfile.component = chipProcessedImfile.class_id
+LEFT JOIN magicDSFile
+    ON magicDSRun.magic_ds_id = magicDSFile.magic_ds_id
+    AND magicDSFile.component = chipProcessedImfile.class_id
 WHERE
     magicDSRun.state = 'run'
@@ -83 +83 @@
     AND chipRun.state = 'full'
     AND chipProcessedImfile.fault = 0
-    AND magicDSImfile.component IS NULL
+    AND magicDSFile.component IS NULL
 UNION
 -- warpSkyfiles
@@ -116 +116 @@
 JOIN warpRun USING(warp_id)
 JOIN rawExp ON magicRun.exp_id = rawExp.exp_id
-LEFT JOIN magicDSImfile
-    ON magicDSRun.magic_ds_id = magicDSImfile.magic_ds_id
-    AND magicDSImfile.component = warpSkyfile.skycell_id
+LEFT JOIN magicDSFile
+    ON magicDSRun.magic_ds_id = magicDSFile.magic_ds_id
+    AND magicDSFile.component = warpSkyfile.skycell_id
 WHERE
     magicDSRun.state = 'run'
@@ -124 +124 @@
     AND warpRun.state = 'full'
     AND warpSkyfile.fault = 0
-    AND magicDSImfile.component IS NULL
+    AND warpSkyfile.ignored = 0
+    AND magicDSFile.component IS NULL
 UNION
 -- diffSkyfiles
@@ -151 +152 @@
 JOIN diffSkyfile USING(diff_id)
 JOIN diffInputSkyfile USING(diff_id)
-LEFT JOIN magicDSImfile
-    ON magicDSRun.magic_ds_id = magicDSImfile.magic_ds_id
-    AND magicDSImfile.component = diffInputSkyfile.skycell_id
+LEFT JOIN magicDSFile
+    ON magicDSRun.magic_ds_id = magicDSFile.magic_ds_id
+    AND magicDSFile.component = diffInputSkyfile.skycell_id
 WHERE
     magicDSRun.state = 'run'
@@ -159 +160 @@
     AND diffRun.state = 'full'
     AND diffSkyfile.fault = 0
-    AND magicDSImfile.component IS NULL
+    AND magicDSFile.component IS NULL
 ) as Foo