Changeset 24125 for trunk/ippTools/share

Timestamp:

May 9, 2009, 2:19:48 PM (17 years ago)

Author:

bills

Message:

Pass information about the paths from the distribution server to the client.
Use these to edit the database dump

Location:

trunk/ippTools/share

Files:

• pxadmin_create_tables.sql (modified) (1 diff)
• receivetool_pendingfile.sql (modified) (2 diffs)
• receivetool_revert.sql (modified) (1 diff)
• receivetool_toadvance.sql (modified) (1 diff)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1330 +1330 @@
     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
+    dirinfo VARCHAR(255), -- uri for directory info file for this run
+    dbinfo VARCHAR(255), -- uri for database dump file for this run
     fault SMALLINT NOT NULL DEFAULT 0, -- Fault code
     PRIMARY KEY(fileset_id),

trunk/ippTools/share/receivetool_pendingfile.sql

@@ -4 +4 @@
     product,
     workdir,
-    destdir,
+    dirinfo,
     fileset,
     fileset_id,
@@ -18 +18 @@
     ON receiveResult.file_id = receiveFile.file_id
 WHERE
-    ((receiveFileset.state = 'new') OR (receiveFileset.state = 'listed' AND receiveFile.component = 'dbinfo'))
+    ((receiveFileset.state = 'new') OR (receiveFileset.state = 'listed' AND receiveFile.component = 'dirinfo'))
     AND receiveFileset.fault = 0
     AND receiveResult.file_id IS NULL

trunk/ippTools/share/receivetool_revert.sql

@@ -4 +4 @@
     AND receiveFile.fileset_id = receiveFileset.fileset_id
     AND receiveFileset.source_id = receiveSource.source_id
-    AND fault != 0
+    AND receiveResult.fault != 0

trunk/ippTools/share/receivetool_toadvance.sql

@@ -2 +2 @@
     receiveFileset.fileset_id,
     receiveFileset.fileset,
-    receiveFileset.dbinfo_uri,
+    receiveFileset.dbinfo,
     receiveSource.status_product,
     receiveSource.ds_dbname,