Changeset 32595

Timestamp:

Oct 28, 2011, 1:51:17 PM (15 years ago)

Author:

bills

Message:

in camtool -pendingimfile only output chips whose rawImfile is not ignored.
This handles the case where we discover a lost rawImfile because chip processing
has failed, ignore it, without deleting the faulted chipProcessedImfile

File:

• tags/ipp-20110622/ippTools/share/camtool_find_pendingimfile.sql (modified) (2 diffs, 1 prop)

tags/ipp-20110622/ippTools/share/camtool_find_pendingimfile.sql

@@ -13 +13 @@
     USING (chip_id)
 JOIN chipProcessedImfile
-    USING (chip_id)
+    USING (chip_id, exp_id)
 JOIN rawExp
-  ON chipProcessedImfile.exp_id = rawExp.exp_id
+    USING(exp_id)
+JOIN rawImfile
+    USING(exp_id, class_id, exp_time)
 LEFT JOIN camProcessedExp
     USING(cam_id)
@@ -22 +24 @@
 WHERE
     camMask.label IS NULL
+    AND rawImfile.ignored = 0