Changeset 25013 for trunk/ippTools/share/magicdstool_todestreak.sql

Timestamp:

Aug 7, 2009, 10:51:43 AM (17 years ago)

Author:

bills

Message:

handle bothways (warp-warp) diffs separate from not bothways

File:

• trunk/ippTools/share/magicdstool_todestreak.sql (modified) (8 diffs)

trunk/ippTools/share/magicdstool_todestreak.sql

@@ -8 +8 @@
     camera,
     magicMask.uri as streaks_uri,
+    NULL AS inv_streaks_uri,
     stage,
     stage_id,
@@ -40 +41 @@
     camera,
     magicMask.uri as streaks_uri,
+    NULL AS inv_streaks_uri,
     stage,
     stage_id,
@@ -77 +79 @@
     camera,
     magicMask.uri as streaks_uri,
+    NULL AS inv_streaks_uri,
     stage,
     stage_id,
@@ -115 +118 @@
     camera,
     magicMask.uri as streaks_uri,
+    NULL AS inv_streaks_uri,
     stage,
     stage_id,
@@ -143 +147 @@
     AND magicDSFile.component IS NULL
 UNION
--- diffSkyfiles
+-- regular diffSkyfiles
 SELECT DISTINCT
     magicDSRun.magic_ds_id,
@@ -151 +155 @@
     rawExp.camera,
     magicMask.uri as streaks_uri,
+    NULL AS inv_streaks_uri,
     stage,
     magicRun.diff_id as stage_id,
@@ -167 +172 @@
 JOIN magicDSRun USING(magic_id)
 JOIN magicInputSkyfile USING(magic_id)
+JOIN diffRun USING(diff_id)
 JOIN diffSkyfile
     ON  magicRun.diff_id = diffSkyfile.diff_id
@@ -176 +182 @@
     magicDSRun.state = 'new'
     AND magicDSRun.stage = 'diff'
+    AND diffRun.bothways = 0
     AND diffSkyfile.fault = 0
     AND diffSkyfile.quality = 0
     AND magicDSFile.component IS NULL
+-- bothways diffSkyfiles
+UNION
+SELECT DISTINCT
+    magicDSRun.magic_ds_id,
+    magicRun.magic_id,
+    magicRun.exp_id,
+    magicDSRun.label,
+    rawExp.camera,
+    magicMask.uri as streaks_uri,
+    (SELECT uri from magicMask where magic_id = inv_magic_id) AS inv_streaks_uri,
+    stage,
+    magicRun.diff_id as stage_id,
+    diffSkyfile.skycell_id as component,
+    NULL AS uri,
+    diffSkyfile.path_base,
+    magicRun.inverse,
+    NULL as cam_path_base,
+    outroot,
+    recoveryroot,
+    re_place,
+    remove
+FROM rawExp
+JOIN magicRun USING (exp_id)
+JOIN magicMask USING (magic_id)
+JOIN magicDSRun USING(magic_id)
+JOIN magicInputSkyfile USING(magic_id)
+JOIN diffRun USING(diff_id)
+JOIN diffSkyfile
+    ON  magicRun.diff_id = diffSkyfile.diff_id
+    AND magicInputSkyfile.node = diffSkyfile.skycell_id
+LEFT JOIN magicDSFile
+    ON magicDSRun.magic_ds_id = magicDSFile.magic_ds_id
+    AND magicDSFile.component = diffSkyfile.skycell_id
+WHERE
+    magicDSRun.state = 'new'
+    AND magicDSRun.stage = 'diff'
+    AND diffRun.bothways
+    AND diffSkyfile.fault = 0
+    AND diffSkyfile.quality = 0
+    AND magicDSFile.component IS NULL
 ) as Foo