Changeset 18975 for trunk/ippTools/share/stacktool_sumskyfile.sql

Timestamp:

Aug 8, 2008, 12:37:49 PM (18 years ago)

Author:

bills

Message:

In the modes for difftool, stacktool, and warptool that print out results
of runs include the exp_id and camera and also allow (or fix bugs in)
selecting by exp_id

File:

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

trunk/ippTools/share/stacktool_sumskyfile.sql

@@ -1 +1 @@
 SELECT
     stackSumSkyfile.*,
-    stackRun.state
+    stackRun.state,
+    rawExp.camera
 FROM stackRun
 JOIN stackSumSkyfile
     USING(stack_id)
+JOIN warpRun
+    -- just need 1 warp to find the camera
+    ON warpRun.warp_id = (SELECT warp_id FROM stackInputSkyfile 
+                            WHERE stackInputSkyfile.stack_id = stackRun.stack_id limit 1)
+JOIN fakeRun
+    ON warpRun.fake_id = fakeRun.fake_id
+JOIN camRun
+    ON camRun.cam_id   = fakeRun.cam_id
+JOIN chipRun
+    ON camRun.chip_id  = chipRun.chip_id
+JOIN rawExp
+    ON chipRun.exp_id  = rawExp.exp_id
 WHERE
 -- bogus test; just here so there there is a 'WHERE' stmt to append conditionals too