Changeset 19609 for branches/eam_branch_20080918/ippTools/share/dettool_toresidimfile.sql

Timestamp:

Sep 18, 2008, 6:39:14 PM (18 years ago)

Author:

eugene

Message:

added ref_det_id, ref_iter references for verify mode and populate as needed

File:

• branches/eam_branch_20080918/ippTools/share/dettool_toresidimfile.sql (modified) (3 diffs)

branches/eam_branch_20080918/ippTools/share/dettool_toresidimfile.sql

@@ -14 +14 @@
     detProcessedImfile.uri,
     detNormalizedImfile.uri AS det_uri,
+    detRun.det_id AS ref_det_id,
+    detRun.iteration AS ref_iter,
     rawExp.camera,
     rawExp.exp_tag
@@ -56 +58 @@
     rawImfile.class_id,
     rawImfile.uri,
-    'NULL' AS det_uri,
+    detNormalizedImfile.uri AS det_uri,
+    detRun.ref_det_id,
+    detRun.ref_iter,
     rawExp.camera,
     rawExp.exp_tag
 FROM detRun
+JOIN detRun AS detRunRef
+  ON detRun.ref_det_id = detRunRef.det_id
+JOIN detNormalizedImfile
+  ON detNormalizedImfile.det_id = detRun.ref_det_id
+ AND detNormalizedImfile.iteration = detRun.ref_iter
 JOIN detInputExp
-    USING(det_id, iteration)
+  ON detInputExp.det_id = detRun.det_id
+ AND detInputExp.iteration = detRun.iteration
 JOIN rawExp
     ON detInputExp.exp_id = rawExp.exp_id
@@ -74 +84 @@
     detRun.state = 'run'
     AND detRun.mode = 'verify'
-    -- AND detNormalizedImfile.fault = 0
-    -- AND detNormalizedExp.fault = 0
+    AND detRunRef.state = 'stop'
+    AND detNormalizedImfile.fault = 0
     AND detResidImfile.det_id IS NULL
     AND detResidImfile.iteration IS NULL