Changeset 25493 for trunk/ippTools/share/disttool_pendingfileset.sql

Timestamp:

Sep 23, 2009, 10:22:33 AM (17 years ago)

Author:

bills

Message:

In distribution server merge rcDSProduct into rcDestination. It was illogical for
a product to be shared by multiple destinations.
In defineinterest define by query to allow destination names and target parameters
to be used. Much more administrator friendly.
Add a label to pstampRequest. Not used yet.
Split reverting of faults in distRuns from faults building components.

File:

• trunk/ippTools/share/disttool_pendingfileset.sql (modified) (1 diff)

trunk/ippTools/share/disttool_pendingfileset.sql

@@ -5 +5 @@
     stage_id,
     CONCAT_WS('.', distRun.outroot, CONVERT(distRun.dist_id, CHAR)) as dist_dir,
-    rcDSProduct.name AS product_name,
-    rcDSProduct.prod_id,
-    rcDSProduct.dbname AS ds_dbname,
-    rcDSProduct.dbhost AS ds_dbhost
+    rcDestination.name AS product_name,
+    rcDestination.prod_id,
+    rcDestination.dbname AS ds_dbname,
+    rcDestination.dbhost AS ds_dbhost
 FROM rcDestination 
 JOIN rcInterest USING(dest_id) 
 JOIN distTarget USING(target_id) 
-JOIN rcDSProduct USING(prod_id)
 JOIN distRun USING(target_id) 
-LEFT JOIN rcDSFileset USING(prod_id, dist_id)
+LEFT JOIN rcDSFileset USING(dest_id, dist_id)
 WHERE distRun.state = 'full'
     AND rcDestination.state = 'enabled'