Changeset 25929 for trunk/ippTools/share/pubtool_definerun.sql

Timestamp:

Oct 22, 2009, 4:51:58 PM (17 years ago)

Author:

Paul Price

Message:

Giving publishClient an 'active' column, and add mode to pubtool to turn this on and off. Only interested in active clients. This is so that I can do a publishing run that only sends data to particular clients.

File:

• trunk/ippTools/share/pubtool_definerun.sql (modified) (2 diffs)

trunk/ippTools/share/pubtool_definerun.sql

@@ -11 +11 @@
     JOIN diffRun
     WHERE publishClient.stage = 'diff'
+        AND publishClient.active = 1
         AND diffRun.state = 'full'
     -- WHERE hook %s
@@ -21 +22 @@
     JOIN camRun
     WHERE publishClient.stage = 'camera'
+        AND publishClient.active = 1
         AND camRun.state = 'full'
     -- WHERE hook %s