Changeset 39519 for trunk/ippTools/src/pztool.c

Timestamp:

Apr 8, 2016, 3:11:07 PM (10 years ago)

Author:

watersc1

Message:

Change to add dateobs limits on pztool -pendingexp query.

File:

• trunk/ippTools/src/pztool.c (modified) (3 diffs)

trunk/ippTools/src/pztool.c

@@ -222 +222 @@
 
     psMetadata *where = psMetadataAlloc();
+    psMetadata *where2 = psMetadataAlloc();
     PXOPT_COPY_S64(config->args, where,  "-summit_id",    "summit_id", "==");
     PXOPT_COPY_STR(config->args, where,  "-exp_name",     "exp_name", "==");
@@ -228 +229 @@
     PXOPT_COPY_STR(config->args, where,  "-exp_type",     "exp_type", "==");
 
+    PXOPT_COPY_TIME(config->args, where2, "-dateobs_begin", "dateobs",   ">=");
+    PXOPT_COPY_TIME(config->args, where2, "-dateobs_end",   "dateobs",   "<=");
+    
     PXOPT_LOOKUP_BOOL(desc, config->args, "-desc", false);
     PXOPT_LOOKUP_U64(limit, config->args, "-limit", false, false);
@@ -251 +255 @@
     psFree(where);
 
+    if (psListLength(where2->list)) {
+      psString where2Clause = psDBGenerateWhereConditionSQL(where2, "summitExp");
+      psStringAppend(&query, " AND %s", where2Clause);
+      psFree(where2Clause);
+    }
+    psFree(where2);
+    
     psStringAppend(&query, " ORDER BY summitExp.dateobs");
     if (desc) {