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

Timestamp:

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

Author:

bills

Message:

Fix bug in staticskytool -result. It was listing the filter in the
output which causes num_filters entries when a staticskyRun has
multiple filters. Change the sql to group by sky_id and list num_filters
instead. Also allow selection by tess_id and skycell_id

File:

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

trunk/ippTools/src/staticskytool.c

@@ -635 +635 @@
     PXOPT_COPY_STR(config->args, where, "-label",      "staticskyRun.label", "==");
     PXOPT_COPY_STR(config->args, where, "-data_group", "staticskyRun.data_group", "LIKE");
+    PXOPT_COPY_STR(config->args, where, "-tess_id", "stackRun.tess_id", "LIKE");
+    PXOPT_COPY_STR(config->args, where, "-skycell_id", "stackRun.skycell_id", "LIKE");
     PXOPT_COPY_S16(config->args, where, "-fault",      "staticskyResult.fault", "==");
 
@@ -659 +661 @@
     psFree(where);
 
+    psStringAppend(&query, "\nGROUP BY sky_id");
+
     // treat limit == 0 as "no limit"
     if (limit) {
         psString limitString = psDBGenerateLimitSQL(limit);
-        psStringAppend(&query, " %s", limitString);
+        psStringAppend(&query, "\n%s", limitString);
         psFree(limitString);
     }