Changeset 19003 for branches/eam_branch_20080719/ippTools/share/difftool_skyfile.sql

Timestamp:

Aug 10, 2008, 10:32:59 AM (18 years ago)

Author:

eugene

Message:

updates from current HEAD

File:

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

branches/eam_branch_20080719/ippTools/share/difftool_skyfile.sql

@@ -2 +2 @@
     diffRun.skycell_id,
     diffRun.tess_id,
-    diffSkyfile.*
+    diffRun.state,
+    diffSkyfile.*,
+    rawExp.exp_id,
+    rawExp.camera
 FROM diffRun
 JOIN diffSkyfile
     USING(diff_id)
-WHERE
-    diffRun.state = 'new'
-
+-- 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
+-- WS: my new stuff ends here
+    WHERE
+    -- bogus test to allow appending conditionals
+    -- XXX EAM : this is not needed if we modify the difftool.c code : fix
+    diffRun.diff_id IS NOT NULL