Changeset 32696 for trunk

Timestamp:

Nov 17, 2011, 2:20:59 PM (14 years ago)

Author:

bills

Message:

Correctly create distRuns for static sky runs.
For multi filter runs require a distTarget with filter = 'multi'.
Single filter runs are queued with new parameter -singlefilter

Location:

trunk/ippTools

Files:

• share/Makefile.am (modified) (1 diff)
• share/disttool_definebyquery_sky.sql (modified) (1 diff)
• share/disttool_definebyquery_sky_singlefilter.sql (added)
• src/disttool.c (modified) (3 diffs)
• src/disttoolConfig.c (modified) (1 diff)

trunk/ippTools/share/Makefile.am

@@ -181 +181 @@
         disttool_definebyquery_raw_no_magic.sql \
         disttool_definebyquery_sky.sql \
+        disttool_definebyquery_sky_singlefilter.sql \
         disttool_definebyquery_stack.sql \
         disttool_definebyquery_warp.sql \

trunk/ippTools/share/disttool_definebyquery_sky.sql

@@ -22 +22 @@
 WHERE  distTarget.state = 'enabled'
     AND rcInterest.state = 'enabled'
+    AND distTarget.filter = 'multi'
     AND distRun.dist_id IS NULL
     AND ((staticskyRun.state = 'full') OR (distTarget.clean AND staticskyRun.state = 'cleaned'))

trunk/ippTools/src/disttool.c

@@ -164 +164 @@
     PXOPT_LOOKUP_STR(dist_group, config->args, "-dist_group", false, false);
 
+    PXOPT_LOOKUP_BOOL(single, config->args, "-singlefilter", false);
+
     if (use_alternate) {
         if (strcmp(stage, "raw")) {
@@ -354 +356 @@
     } else if (!strcmp(stage, "sky")) {
         magicRunType = "staticskyRun";
-        query = pxDataGet("disttool_definebyquery_sky.sql");
+        if (single) {
+            query = pxDataGet("disttool_definebyquery_sky_singlefilter.sql");
+        } else {
+            query = pxDataGet("disttool_definebyquery_sky.sql");
+        }
         if (!query) {
             psError(PXTOOLS_ERR_SYS, false, "failed to retreive SQL statement");
@@ -411 +417 @@
     if (!no_magic) {
         psStringAppend(&query, " AND (%s.magicked > 0)", magicRunType);
+    }
+
+    if (!strcmp(stage, "sky") && single) {
+        psStringAppend(&query, "\nGROUP BY sky_id HAVING count(stack_id) = 1");
     }
 

trunk/ippTools/src/disttoolConfig.c

@@ -63 +63 @@
     psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-label",         0, "select by run label", NULL);
     psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-dist_group",    0, "select by dist_group", NULL);
+    psMetadataAddBool(definebyqueryArgs, PS_LIST_TAIL, "-singlefilter", 0, "select single filter runs (sky stage only)", false);
 
     psMetadataAddU64(definebyqueryArgs, PS_LIST_TAIL, "-limit",  0,  "limit result set to N items", 0);