Changeset 28339 for trunk/ippTools/src/camtool.c

Timestamp:

Jun 15, 2010, 1:57:07 PM (16 years ago)

Author:

bills

Message:

implement ordering by Label.priority for camtool -processedexp
Needed to stop sharing the sql to implement this

File:

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

trunk/ippTools/src/camtool.c

@@ -292 +292 @@
     PXOPT_LOOKUP_BOOL(simple, config->args, "-simple", false);
 
-    psString query = pxDataGet("camtool_find_pendingexp.sql");
+    psString query = pxDataGet("camtool_pendingexp.sql");
     if (!query) {
         psError(PXTOOLS_ERR_SYS, false, "failed to retreive SQL statement");
@@ -305 +305 @@
     }
     psFree(where);
+
+    psStringAppend(&query, "\nORDER BY priority DESC, cam_id");
 
     // treat limit == 0 as "no limit"
@@ -531 +533 @@
     PXOPT_COPY_S64(config->args, where, "-cam_id",   "camRun.cam_id",   "==");
 
-    psString query = pxDataGet("camtool_find_pendingexp.sql");
+    psString query = pxDataGet("camtool_addprocessedexp.sql");
     if (!query) {
         psError(PXTOOLS_ERR_SYS, false, "failed to retreive SQL statement");