Changeset 31681 for trunk/ippTools/share

Timestamp:

Jun 22, 2011, 2:29:09 PM (15 years ago)

Author:

bills

Message:

Change staticskytool -definebyquery to only queue a run if an existing run for the stacks with
given label and data_group does not exist. This allows it to work properly for single filter
staticskyRuns for nightly stacks and to support use in a survey task. Add a -rerun flag to override
that restriction

File:

• trunk/ippTools/share/staticskytool_definebyquery_select.sql (modified) (3 diffs)

trunk/ippTools/share/staticskytool_definebyquery_select.sql

@@ -1 +1 @@
 SELECT 
        tess_id, 
-       skycell_id, 
+       skycell_id,
+       data_group,
+       label,
        num_filter 
 FROM (
@@ -7 +9 @@
       tess_id,
       skycell_id,
+      label,
+      data_group,
       COUNT(DISTINCT filter) AS num_filter
   FROM stackRun
@@ -17 +21 @@
   GROUP BY
       tess_id,
-      skycell_id
+      skycell_id,
+      data_group
   ) AS TMP
+LEFT JOIN (
+  SELECT DISTINCT sky_id,
+    stackRun.skycell_id,
+    stackRun.label,
+    stackRun.data_group,
+    COUNT(stack_id) AS num_filter
+  FROM staticskyRun
+    JOIN staticskyInput USING(sky_id)
+    JOIN stackRun USING(stack_id)
+    JOIN stackSumSkyfile USING(stack_id)
+    WHERE 1
+    -- WHERE hook 2 %s
+  GROUP BY sky_id
+ ) AS oldRuns
+USING(label, data_group, num_filter, skycell_id)
 WHERE num_filter = %d
-
+-- WHERE hook 3 %s