Changeset 12226

Timestamp:

Mar 5, 2007, 11:55:25 AM (19 years ago)

Author:

jhoblitt

Message:

add additional information to the output of chiptool -pendingimfile & -processedexp

Location:

trunk/ippTools/share

Files:

• chiptool_pendingimfile.sql (modified) (1 diff)
• chiptool_processedimfile.sql (modified) (1 diff)

trunk/ippTools/share/chiptool_pendingimfile.sql

@@ -1 +1 @@
 SELECT
-    chipPendingImfile.*,
-    rawExp.exp_tag,
+    chipPendingExp.*,
+    chipPendingImfile.class_id,
+    chipPendingImfile.uri,
     rawExp.exp_id,
     rawExp.camera,
-    rawExp.telescope,
-    rawExp.workdir
+    rawExp.telescope
 FROM chipPendingImfile
 JOIN chipPendingExp

trunk/ippTools/share/chiptool_processedimfile.sql

@@ -1 +1 @@
 SELECT
-    chipProcessedImfile.*,
-    rawExp.camera,
-    rawExp.exp_tag,
+    chipProcessedExp.*,
+    chipProcessedImfile.class_id,
+    chipProcessedImfile.uri,
+    chipProcessedImfile.bg,
+    chipProcessedImfile.bg_stdev,
+    chipProcessedImfile.bg_mean_stdev,
+    chipProcessedImfile.path_base,
     rawExp.exp_id,
     rawExp.camera,
-    rawExp.telescope,
-    rawExp.workdir
+    rawExp.telescope
 FROM chipProcessedImfile
+JOIN chipProcessedExp
+    USING(chip_id)
 JOIN rawExp
-    USING(exp_tag)
+    ON chipProcessedExp.exp_tag = rawExp.exp_tag
 WHERE
 -- bogus test; just here so there there is a 'WHERE' stmt to append conditionals too