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

Timestamp:

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

Author:

bills

Message:

changed some names

File:

• trunk/ippTools/share/magicdstool_completed_runs.sql (modified) (8 diffs)

trunk/ippTools/share/magicdstool_completed_runs.sql

@@ -20 +20 @@
     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'
@@ -30 +30 @@
         rawImfile.exp_id
     HAVING
-        COUNT(rawImfile.class_id) = COUNT(magicDSImfile.component)
-        AND SUM(magicDSImfile.fault) = 0
+        COUNT(rawImfile.class_id) = COUNT(magicDSFile.component)
+        AND SUM(magicDSFile.fault) = 0
 UNION
 -- chip stage
@@ -53 +53 @@
     JOIN chipProcessedImfile USING(chip_id)
 
-    LEFT JOIN magicDSImfile
-        ON magicDSImfile.magic_ds_id = magicDSRun.magic_ds_id
-        AND magicDSImfile.component = chipProcessedImfile.class_id
+    LEFT JOIN magicDSFile
+        ON magicDSFile.magic_ds_id = magicDSRun.magic_ds_id
+        AND magicDSFile.component = chipProcessedImfile.class_id
     WHERE
         magicDSRun.state = 'run'
@@ -63 +63 @@
         chipRun.chip_id
     HAVING
-        COUNT(chipProcessedImfile.class_id) = COUNT(magicDSImfile.component)
-        AND SUM(magicDSImfile.fault) = 0
+        COUNT(chipProcessedImfile.class_id) = COUNT(magicDSFile.component)
+        AND SUM(magicDSFile.fault) = 0
 UNION
 -- warp stage
@@ -81 +81 @@
     JOIN warpSkyfile using(warp_id)
     JOIN warpRun USING(warp_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'
@@ -93 +93 @@
         warpRun.warp_id
     HAVING
-        COUNT(warpSkyfile.skycell_id) = COUNT(magicDSImfile.component)
-        AND SUM(magicDSImfile.fault) = 0
+        COUNT(warpSkyfile.skycell_id) = COUNT(magicDSFile.component)
+        AND SUM(magicDSFile.fault) = 0
 UNION
 -- diff stage
@@ -105 +105 @@
     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'
@@ -117 +117 @@
         magicRun.magic_id
     HAVING
-        COUNT(magicInputSkyfile.node) = COUNT(magicDSImfile.component)
-        AND SUM(magicDSImfile.fault) = 0
+        COUNT(magicInputSkyfile.node) = COUNT(magicDSFile.component)
+        AND SUM(magicDSFile.fault) = 0
 
    ) as Foo