Changeset 25929 for trunk/ippTools/share

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.

Location:

trunk/ippTools/share

Files:

• pubtool_definerun.sql (modified) (2 diffs)
• pubtool_pending.sql (modified) (2 diffs)
• pubtool_revert.sql (modified) (1 diff)
• pxadmin_create_tables.sql (modified) (1 diff)

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

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'

trunk/ippTools/share/pubtool_revert.sql

@@ -3 +3 @@
 WHERE publishDone.pub_id = publishRun.pub_id
     AND publishRun.client_id = publishClient.client_id
+    AND publishClient.active = 1
     AND publishDone.fault != 0

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1485 +1485 @@
 CREATE TABLE publishClient (
     client_id BIGINT AUTO_INCREMENT, -- unique identifier
+    active TINYINT DEFAULT 0,        -- whether we should worry about this or not
     product VARCHAR(64),             -- product name
     stage VARCHAR(64) NOT NULL, -- stage of interest (chip, camera, diff, etc.)