Changeset 33385

Timestamp:

Feb 29, 2012, 7:44:16 AM (14 years ago)

Author:

bills

Message:

in staticskytool -result add -num_filters and select where num_filters >=
so that one can say things like
staticskytool -result -skycell_id skycell.0866.051 -num_filters 5

Location:

trunk/ippTools/src

Files:

• staticskytool.c (modified) (2 diffs)
• staticskytoolConfig.c (modified) (1 diff)

trunk/ippTools/src/staticskytool.c

@@ -638 +638 @@
     PXOPT_COPY_STR(config->args, where, "-skycell_id", "stackRun.skycell_id", "LIKE");
     PXOPT_COPY_S16(config->args, where, "-fault",      "staticskyResult.fault", "==");
+    PXOPT_LOOKUP_S32(num_filters, config->args, "-num_filters", false, false);
 
     PXOPT_LOOKUP_BOOL(all, config->args, "-all", false);
@@ -662 +663 @@
 
     psStringAppend(&query, "\nGROUP BY sky_id");
+    if (num_filters) {
+        psStringAppend(&query, "\nHAVING COUNT(filter) >= %d", num_filters);
+    }
+        
 
     // treat limit == 0 as "no limit"

trunk/ippTools/src/staticskytoolConfig.c

@@ -112 +112 @@
     psMetadataAddStr(resultArgs, PS_LIST_TAIL, "-label", 0, "search by label", NULL);
     psMetadataAddStr(resultArgs, PS_LIST_TAIL, "-data_group", 0, "search by data_group (LIKE comparison)", NULL);
+    psMetadataAddS16(resultArgs, PS_LIST_TAIL, "-num_filters", 0, "search by number of filters in the inputs (>=)", 0);
     psMetadataAddS16(resultArgs, PS_LIST_TAIL, "-fault", 0, "search by fault code", 0);
     psMetadataAddU64(resultArgs, PS_LIST_TAIL, "-limit", 0, "limit result set to N items", 0);