Changeset 25929 for trunk/ippTools/share/pubtool_pending.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_pending.sql (modified) (2 diffs)

trunk/ippTools/share/pubtool_pending.sql

@@ -24 +24 @@
     JOIN rawExp USING(exp_id)
     WHERE publishClient.stage = 'diff'
+        AND publishClient.active = 1
         AND publishRun.state = 'new'
         AND diffRun.state = 'full'
@@ -43 +44 @@
     JOIN rawExp USING(exp_id)
     WHERE publishClient.stage = 'camera'
+        AND publishClient.active = 1
         AND publishRun.state ='new'
         AND camRun.state = 'full'