Changeset 14018 for trunk/ippTools/share/camtool_queue_chip_id.sql

Timestamp:

Jul 5, 2007, 10:15:41 AM (19 years ago)

Author:

jhoblitt

Message:

merge backtrack branch

File:

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

trunk/ippTools/share/camtool_queue_chip_id.sql

@@ -1 +1 @@
 -- camtool only operates on exposures so we can safely queue more then one at a
 -- time without worrying about losing the track of the generated cam_id
-INSERT INTO camPendingExp
+INSERT INTO camRun
     SElECT
         0,              -- cam_id
         chip_id,        -- chip_id
+        '%s',           -- state
         '%s',           -- workdir
+        '%s',           -- workdir_state
         '%s',           -- label
-        '%s',           -- recipe
+        '%s',           -- reduction
         '%s',           -- expgroup
         '%s'            -- dvodb 
-    FROM chipProcessedExp
+    FROM chipRun
     WHERE
-        chipProcessedExp.chip_id = %lld
+        chipRun.state = 'stop'
+        AND chipRun.chip_id = %lld