Changeset 24038 for trunk/ippTools/share

Timestamp:

May 1, 2009, 5:28:52 PM (17 years ago)

Author:

bills

Message:

on receive side of distribution, optionally create a fileset in a status data store
defer {$stage}tool -importrun until all of the files have been downloaded
in the dist.queuruns task queue rcruns

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• pxadmin_create_tables.sql (modified) (2 diffs)
• receivetool_pendingfile.sql (modified) (1 diff)
• receivetool_toadvance.sql (added)

trunk/ippTools/share/Makefile.am

@@ -179 +179 @@
      receivetool_pendingfile.sql \
      receivetool_revert.sql \
+     receivetool_toadvance.sql \
      regtool_create_dup_table.sql \
      regtool_export_exp.sql \

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1315 +1315 @@
     comment VARCHAR(255),       -- for human memory
     fileset_last VARCHAR(128),  -- last fileset seen
+    status_product VARCHAR(64), -- status data store product
+    ds_dbname VARCHAR(64),      -- status data store's database name
+    ds_dbhost VARCHAR(64),      -- status data store's host name
     PRIMARY KEY(source_id),
     KEY(source),
@@ -1326 +1329 @@
     source_id BIGINT NOT NULL,  -- link to receiveSource
     fileset VARCHAR(128) NOT NULL, -- fileset to receive
+    state VARCHAR(64), -- new or full
+    dbinfo_uri VARCHAR(255), -- uri for database dump for this fileset's run
+    fault SMALLINT NOT NULL DEFAULT 0, -- Fault code
     PRIMARY KEY(fileset_id),
     KEY(source_id),

trunk/ippTools/share/receivetool_pendingfile.sql

@@ -5 +5 @@
     workdir,
     fileset,
+    fileset_id,
     file
 FROM receiveFile