Changeset 20071 for trunk/ippTools/share/difftool_skyfile.sql

Timestamp:

Oct 12, 2008, 12:27:17 PM (18 years ago)

Author:

bills

Message:

the minuend image (template = 0) is not necessarily a warp so we can't
get the warp_id or camera information in this query.
Instead list the warp and stack ids for template = 0 and template = 1
using sub-queries. The postage stamp request parser will need to determine
the warp and exposure information using warptool when it is appropriate.

File:

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

trunk/ippTools/share/difftool_skyfile.sql

@@ -4 +4 @@
     diffRun.state,
     diffSkyfile.*,
-    rawExp.exp_id,
-    rawExp.camera,
-    warpRun.warp_id
+    (SELECT warp_id FROM diffInputSkyfile WHERE diffInputSkyfile.diff_id = diffRun.diff_id
+        AND diffInputSkyfile.template = 0 ) AS warp_id_temp_0,
+    (SELECT stack_id FROM diffInputSkyfile WHERE diffInputSkyfile.diff_id = diffRun.diff_id
+        AND diffInputSkyfile.template = 0 ) AS stack_id_temp_0,
+    (SELECT warp_id FROM diffInputSkyfile WHERE diffInputSkyfile.diff_id = diffRun.diff_id
+        AND diffInputSkyfile.template = 1 ) AS warp_id_temp_1,
+    (SELECT stack_id FROM diffInputSkyfile WHERE diffInputSkyfile.diff_id = diffRun.diff_id
+        AND diffInputSkyfile.template = 1 ) AS stack_id_temp_1
 FROM diffRun
 JOIN diffSkyfile
     USING(diff_id)
--- WS: my new stuff begins here
 JOIN diffInputSkyfile
     ON diffInputSkyfile.diff_id = diffRun.diff_id
     AND diffInputSkyfile.template = 0
-JOIN warpRun
-    ON diffInputSkyfile.warp_id = warpRun.warp_id
-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