Changeset 33385 for trunk/ippTools/src/staticskytool.c

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

File:

• trunk/ippTools/src/staticskytool.c (modified) (2 diffs)

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"