Changeset 18305

Timestamp:

Jun 23, 2008, 4:27:00 PM (18 years ago)

Author:

jhoblitt

Message:

add pztool -pending[exp|imfile] -desc flag

Location:

trunk/ippTools

Files:

• share/pztool_pendingimfile.sql (modified) (1 diff)
• src/pztool.c (modified) (4 diffs)
• src/pztoolConfig.c (modified) (2 diffs)

trunk/ippTools/share/pztool_pendingimfile.sql

@@ -18 +18 @@
         AND pzDownloadImfile.class IS NULL
         AND pzDownloadImfile.class_id IS NULL
-    ORDER BY
-        summitExp.dateobs DESC
 ) as Foo

trunk/ippTools/src/pztool.c

@@ -203 +203 @@
     PS_ASSERT_PTR_NON_NULL(config, false);
 
+    PXOPT_LOOKUP_BOOL(desc, config->args, "-desc", false);
     PXOPT_LOOKUP_U64(limit, config->args, "-limit", false, false);
     PXOPT_LOOKUP_BOOL(simple, config->args, "-simple", false);
@@ -225 +226 @@
     }
 
-    psStringAppend(&query, " ORDER BY summitExp.dateobs DESC");
+    psStringAppend(&query, " ORDER BY summitExp.dateobs");
+    if (desc) {
+        psStringAppend(&query, " DESC");
+    }
 
     // treat limit == 0 as "no limit"
@@ -268 +272 @@
     PS_ASSERT_PTR_NON_NULL(config, false);
 
+    PXOPT_LOOKUP_BOOL(desc, config->args, "-desc", false);
     PXOPT_LOOKUP_U64(limit, config->args, "-limit", false, false);
     PXOPT_LOOKUP_BOOL(simple, config->args, "-simple", false);
@@ -296 +301 @@
             psStringAppend(&query, " AND %s", whereClause);
             psFree(whereClause);
+        }
+
+        psStringAppend(&query, " ORDER BY dateobs");
+        if (desc) {
+            psStringAppend(&query, " DESC");
         }
 

trunk/ippTools/src/pztoolConfig.c

@@ -80 +80 @@
     psMetadataAddStr(pendingexpArgs, PS_LIST_TAIL, "-exp_type", 0,
             "define exposure type", NULL); 
+    psMetadataAddBool(pendingexpArgs, PS_LIST_TAIL, "-desc", 0,
+            "sort ouput in descending format", false);
     psMetadataAddU64(pendingexpArgs, PS_LIST_TAIL, "-limit",  0,
             "limit result set to N items", 0);
@@ -95 +97 @@
     psMetadataAddStr(pendingimfileArgs, PS_LIST_TAIL, "-exp_type", 0,
             "define exposure type", NULL); 
+    psMetadataAddBool(pendingimfileArgs, PS_LIST_TAIL, "-desc", 0,
+            "sort ouput in descending format", false);
     psMetadataAddU64(pendingimfileArgs, PS_LIST_TAIL, "-limit",  0,
             "limit result set to N items", 0);