Changeset 19972 for trunk/ippTools/share/camtool_find_pendingimfile.sql

Timestamp:

Oct 7, 2008, 4:32:14 PM (18 years ago)

Author:

eugene

Message:

need to pass all chipProcessedImfile metadata through

File:

• trunk/ippTools/share/camtool_find_pendingimfile.sql (modified) (2 diffs)

trunk/ippTools/share/camtool_find_pendingimfile.sql

@@ -3 +3 @@
      -- which table the field came from
     (SELECT
-        camRun.*,
-        chipProcessedImfile.exp_id,
-        chipProcessedImfile.class_id,
-        chipProcessedImfile.uri,
-        chipProcessedImfile.bg,
-        chipProcessedImfile.bg_stdev,
-        chipProcessedImfile.bg_mean_stdev,
-        chipProcessedImfile.fringe_0,
-        chipProcessedImfile.fringe_1,
-        chipProcessedImfile.fringe_2,
-        chipProcessedImfile.ap_resid,
-        chipProcessedImfile.ap_resid_stdev,
-        chipProcessedImfile.n_stars,
-        chipProcessedImfile.n_extended,
-        chipProcessedImfile.n_cr,
-        chipProcessedImfile.path_base,
+        camRun.cam_id,
+        chipProcessedImfile.*,
         rawExp.exp_name,
         rawExp.camera,
@@ -25 +11 @@
     FROM camRun
     JOIN chipRun
-        USING(chip_id)
+--      ON camRun.chip_id = chipRun.chip_id
+        USING (chip_id)
     JOIN chipProcessedImfile
-        USING(chip_id)
+--      ON camRun.chip_id = chipProcessedImfile.chip_id
+        USING (chip_id)
     JOIN rawExp
-        ON chipProcessedImfile.exp_id = rawExp.exp_id
+      ON chipProcessedImfile.exp_id = rawExp.exp_id
     LEFT JOIN camProcessedExp
         USING(cam_id)