Changeset 14147 for trunk/ippTools/share

Timestamp:

Jul 11, 2007, 3:01:27 PM (19 years ago)

Author:

jhoblitt

Message:

properly constraint camtool -addprocessexp sanity checking SQL

File:

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

trunk/ippTools/share/camtool_find_pendingexp.sql

@@ -2 +2 @@
 -- does a little more work then is necessary for -addprocessed but it seems
 -- "cleaner" to use the same query for both cases 
-SELECT
-    camRun.*,
-    rawExp.exp_tag,
-    rawExp.exp_id,
-    rawExp.exp_name,
-    rawExp.camera,
-    rawExp.telescope,
-    rawExp.filelevel
-FROM camRun
-JOIN chipRun
-    USING(chip_id)
-JOIN chipProcessedImfile
-    USING(chip_id)
-JOIN rawExp
-    ON chipProcessedImfile.exp_id = rawExp.exp_id
-LEFT JOIN camProcessedExp
-    ON camRun.cam_id = camProcessedExp.cam_id
-LEFT JOIN camMask
-    ON camRun.label = camMask.label
-WHERE
-    chipRun.state = 'stop'
-    AND camRun.state = 'run'
-    AND camMask.label IS NULL
-    AND camProcessedExp.cam_id IS NULL
+SELECT * FROM
+    (SELECT
+        camRun.*,
+        rawExp.exp_tag,
+        rawExp.exp_id,
+        rawExp.exp_name,
+        rawExp.camera,
+        rawExp.telescope,
+        rawExp.filelevel
+    FROM camRun
+    JOIN chipRun
+        USING(chip_id)
+    JOIN chipProcessedImfile
+        USING(chip_id)
+    JOIN rawExp
+        ON chipProcessedImfile.exp_id = rawExp.exp_id
+    LEFT JOIN camProcessedExp
+        ON camRun.cam_id = camProcessedExp.cam_id
+    LEFT JOIN camMask
+        ON camRun.label = camMask.label
+    WHERE
+        chipRun.state = 'stop'
+        AND camRun.state = 'run'
+        AND camMask.label IS NULL
+        AND camProcessedExp.cam_id IS NULL
+    ) as Foo