Changeset 14023 for trunk/ippTools/share/chiptool_pendingimfile.sql

Timestamp:

Jul 5, 2007, 3:16:08 PM (19 years ago)

Author:

jhoblitt

Message:

rename exp_id -> exp_name
rename exp_tag -> exp_id
add add rawExp.exp_tag for use as an external name only

File:

• trunk/ippTools/share/chiptool_pendingimfile.sql (modified) (3 diffs)

trunk/ippTools/share/chiptool_pendingimfile.sql

@@ -1 +1 @@
 SELECT
     chipRun.*,
-    chipInputImfile.exp_tag,
+    chipInputImfile.exp_id,
     chipInputImfile.class_id,
     rawImfile.uri,
-    rawExp.exp_id,
+    rawExp.exp_name,
     rawExp.camera,
     rawExp.telescope,
@@ -13 +13 @@
 LEFT JOIN chipProcessedImfile
     ON chipInputImfile.chip_id = chipProcessedImfile.chip_id
-    AND chipInputImfile.exp_tag = chipProcessedImfile.exp_tag
+    AND chipInputImfile.exp_id = chipProcessedImfile.exp_id
     AND chipInputImfile.class_id = chipProcessedImfile.class_id
 JOIN rawImfile
-    ON chipInputImfile.exp_tag = rawImfile.exp_tag
+    ON chipInputImfile.exp_id = rawImfile.exp_id
     AND chipInputImfile.class_id = rawImfile.class_id
 JOIN rawExp
-    ON rawImfile.exp_tag = rawExp.exp_tag
+    ON rawImfile.exp_id = rawExp.exp_id
 LEFT JOIN chipMask
     ON chipRun.label = chipMask.label
@@ -25 +25 @@
     chipRun.state = 'run'
     AND chipProcessedImfile.chip_id IS NULL
-    AND chipProcessedImfile.exp_tag IS NULL
+    AND chipProcessedImfile.exp_id IS NULL
     AND chipProcessedImfile.class_id IS NULL
     AND chipMask.label IS NULL