Changeset 26192

Timestamp:

Nov 19, 2009, 10:07:55 AM (17 years ago)

Author:

bills

Message:

accept -filter as paramter to disttool -updateinterest

Location:

trunk/ippTools/src

Files:

• disttool.c (modified) (3 diffs)
• disttoolConfig.c (modified) (1 diff)

trunk/ippTools/src/disttool.c

@@ -1611 +1611 @@
     PXOPT_COPY_S64(config->args, where, "-dest_id",   "dest_id", "==");
     PXOPT_COPY_S64(config->args, where, "-target_id", "target_id", "==");
+    PXOPT_COPY_STR(config->args, where, "-filter", "filter", "LIKE");
 
     PXOPT_LOOKUP_STR(state, config->args, "-set_state", false, false);
@@ -1619 +1620 @@
     }
     psString query = NULL;
-    psStringAppend(&query, "UPDATE rcInterest SET state = '%s'", state);
+    psStringAppend(&query, "UPDATE rcInterest join distTarget using(target_id) SET rcInterest.state = '%s'", state);
 
     if (psListLength(where->list)) {
@@ -1639 +1640 @@
     }
     psFree(query);
+
+    psS64 numUpdated = psDBAffectedRows(config->dbh);
+    printf("updated %" PRId64 " interests\n", numUpdated);
 
     return true;

trunk/ippTools/src/disttoolConfig.c

@@ -293 +293 @@
     psMetadataAddS64(updateinterestArgs, PS_LIST_TAIL, "-target_id", 0, "define target_id", 0);
     psMetadataAddStr(updateinterestArgs, PS_LIST_TAIL, "-set_state", 0, "define state (required)", NULL);
+    psMetadataAddStr(updateinterestArgs, PS_LIST_TAIL, "-filter",    0, "define filter (LIKE comparison)", NULL);
 
     // -listinterests