Changeset 13994 for branches/backtrack/ippTools/share/chiptool_completely_processed_exp.sql

Timestamp:

Jul 2, 2007, 3:46:36 PM (19 years ago)

Author:

jhoblitt

Message:

refactor camtool & db to preserve metadata history

File:

• branches/backtrack/ippTools/share/chiptool_completely_processed_exp.sql (modified) (2 diffs)

branches/backtrack/ippTools/share/chiptool_completely_processed_exp.sql

@@ -10 +10 @@
     dvodb
 FROM
-    (SELECT DISTINCT
+    (SELECT 
         chipRun.*,
         rawExp.imfiles,
-        chipProcessedImfile.exp_tag,
         chipProcessedImfile.class_id
     FROM chipRun
@@ -20 +19 @@
     JOIN rawExp
         ON chipPendingImfile.exp_tag = rawExp.exp_tag
-    LEFT JOIN chipProcessedImfile
-        USING(chip_id)
+    JOIN chipProcessedImfile
+        ON chipPendingImfile.chip_id = chipProcessedImfile.chip_id
+        AND chipPendingImfile.exp_tag = chipProcessedImfile.exp_tag
+        AND chipPendingImfile.class_id = chipProcessedImfile.class_id
     WHERE
-        chipProcessedImfile.chip_id IS NOT NULL
-        AND chipProcessedImfile.exp_tag IS NOT NULL
-        AND chipProcessedImfile.class_id IS NOT NULL
+        chipRun.state = 'run'
         AND chipProcessedImfile.fault = 0
     GROUP BY
-        chipProcessedImfile.class_id,
-        chipProcessedImfile.exp_tag
+        chipPendingImfile.chip_id,
+        chipPendingImfile.exp_tag
     HAVING rawExp.imfiles = COUNT(chipProcessedImfile.class_id)) as Foo