Changeset 31429 for branches/czw_branch/20110406/ippTools/share/laptool_inactiveexp.sql

Timestamp:

May 3, 2011, 7:28:38 PM (15 years ago)

Author:

watersc1

Message:

Hard coded cleanup commands into the script, but it works, and triggers cleanup for the things we're done with. Edit to diff_skycell.pl to create a dummy refConv file for magic to use when we haven't convolved anything.

File:

• branches/czw_branch/20110406/ippTools/share/laptool_inactiveexp.sql (modified) (3 diffs)

branches/czw_branch/20110406/ippTools/share/laptool_inactiveexp.sql

@@ -1 +1 @@
 SELECT DISTINCT 
-    D.*,diffRun.state AS diff_state,CONVERT(sum(others.active),SIGNED) AS is_in_use FROM (
+    D.*,diffRun.state AS diff_state,coalesce(CONVERT(sum(others.active),SIGNED),0) AS is_in_use FROM (
   SELECT DISTINCT 
       W.*,IFNULL(diff1.diff_id,diff2.diff_id) AS diff_id FROM (
@@ -27 +27 @@
     WHERE lapExp.active = FALSE
     AND @WHERE@
+    AND (warpSkyfile.quality IS NULL OR
+         (warpSkyfile.quality != 8007      -- known cases where quality != 0, but everything's fine.
+          AND warpSkyfile.quality != 3006  -- known cases where quality != 0, but everything's fine.
+          ))
     GROUP BY lap_id,exp_id
     ) AS W
@@ -34 +38 @@
 ) AS D
 LEFT JOIN diffRun USING(diff_id)
-JOIN lapExp AS others ON (D.chip_id = others.chip_id AND D.lap_id != others.lap_id)
+LEFT JOIN lapExp AS others ON (D.chip_id = others.chip_id AND D.lap_id != others.lap_id)
 GROUP BY lap_id,exp_id