Changeset 24858

Timestamp:

Jul 20, 2009, 10:16:44 AM (17 years ago)

Author:

eugene

Message:

add option to order by date

Location:

trunk/ippTools/src

Files:

• regtool.c (modified) (2 diffs)
• regtoolConfig.c (modified) (1 diff)

trunk/ippTools/src/regtool.c

@@ -331 +331 @@
     PXOPT_LOOKUP_BOOL(faulted, config->args, "-faulted", false);
     PXOPT_LOOKUP_BOOL(simple, config->args, "-simple", false);
+    PXOPT_LOOKUP_BOOL(ordered_by_date, config->args, "-ordered_by_date", false);
 
     psString query = pxDataGet("regtool_processedimfile.sql");
@@ -352 +353 @@
         // don't list faulted rows
         psStringAppend(&query, " %s", "AND rawImfile.fault = 0");
+    }
+
+    // add the ORDER BY statement if desired
+    if (ordered_by_date) {
+        psStringAppend(&query, " ORDER BY dateobs");
     }
 

trunk/ippTools/src/regtoolConfig.c

@@ -138 +138 @@
     ADD_OPT(Bool, processedimfileArgs, "-faulted",   "only return imfiles with a fault status set", false);
     ADD_OPT(Bool, processedimfileArgs, "-simple",    "use the simple output format",          false);
+    ADD_OPT(Bool, processedimfileArgs, "-ordered_by_date", "force output to be in DATE order", false);
 
     // -revertprocessedimfile