Changeset 26915 for trunk/ippTools/share/addtool_find_cam_id.sql

Timestamp:

Feb 11, 2010, 3:01:34 PM (16 years ago)

Author:

bills

Message:

In addtool -definebyquery prevent queuing a new addRun if one already exists
for the given exposure in the target dvo database

File:

• trunk/ippTools/share/addtool_find_cam_id.sql (modified) (1 diff)

trunk/ippTools/share/addtool_find_cam_id.sql

@@ -6 +6 @@
 JOIN rawExp
     USING(exp_id)
+LEFT JOIN (SELECT exp_id       AS added_exp_id,
+                  addRun.dvodb AS previous_dvodb
+           FROM addRun
+           JOIN camRun USING(cam_id)
+           JOIN chipRun USING(chip_id)
+          ) as foo
+     ON exp_id = added_exp_id
+     -- hook for qualifying the join on the previous_dvodb
+     AND %s
 WHERE
     camRun.state = 'full'
+    AND added_exp_id IS NULL
+    -- addtool adds checks on exposure being added to the dvodb previously