Changeset 14254

Timestamp:

Jul 16, 2007, 5:33:09 PM (19 years ago)

Author:

jhoblitt

Message:

fix dettool -inputskyfile

File:

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

trunk/ippTools/share/difftool_inputskyfile.sql

@@ -1 @@
-SELECT DISTINCT
-    warpSkyfile.*,
+SELECT 
+    diffRun.diff_id,
+    diffRun.skycell_id,
+    diffRun.tess_id,
+    NULL as stack_id,
+    warpSkyfile.warp_id,
+    warpSkyfile.uri,
+    warpSkyfile.path_base,
     diffInputSkyfile.template,
     rawExp.camera
@@ -22 +28 @@
 WHERE
     diffRun.state = 'run'
+UNION
+SELECT 
+    diffRun.diff_id,
+    diffRun.skycell_id,
+    diffRun.tess_id,
+    stackSumSkyfile.stack_id,
+    NULL as warp_id,
+    stackSumSkyfile.uri,
+    stackSumSkyfile.path_base,
+    diffInputSkyfile.template,
+    rawExp.camera
+FROM diffRun
+JOIN diffInputSkyfile
+    USING(diff_id)
+JOIN stackSumSkyfile
+    ON  diffInputSkyfile.stack_id = stackSumSkyfile.stack_id
+JOIN stackInputSkyfile
+    ON diffInputSkyfile.stack_id = stackInputSkyfile.stack_id
+JOIN warpInputExp
+    ON stackInputSkyfile.warp_id = warpInputExp.warp_id
+JOIN camProcessedExp
+    ON warpInputExp.cam_id = camProcessedExp.cam_id
+JOIN chipRun
+    ON camProcessedExp.chip_id = chipRun.chip_id
+JOIN chipProcessedImfile
+    ON chipRun.chip_id = chipProcessedImfile.chip_id
+JOIN rawExp
+    ON chipProcessedImfile.exp_id = rawExp.exp_id
+WHERE
+    diffRun.state = 'run'