Changeset 23737 for trunk/ippTools/share/disttool_pendingcomponent.sql

Timestamp:

Apr 7, 2009, 4:19:58 PM (17 years ago)

Author:

bills

Message:

changes to make building distribution bundles for camera and fake stages work

File:

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

trunk/ippTools/share/disttool_pendingcomponent.sql

@@ -84 +84 @@
     stage,
     stage_id,
-    chipProcessedImfile.class_id AS component,
+    'exposure' AS component,
+--    chipProcessedImfile.class_id AS component,
     clean,
     rawExp.camera,
     outroot,
     camProcessedExp.path_base,
-    chipProcessedImfile.path_base as chip_path_base,
+    NULL as chip_path_base,
     camRun.state,
     NULL,
     camProcessedExp.quality,
     distRun.no_magic,
-    chipProcessedImfile.magicked
+    chipRun.magicked
 FROM distRun
 JOIN camRun ON camRun.cam_id = distRun.stage_id
 JOIN camProcessedExp USING(cam_id)
 JOIN chipRun USING(chip_id)
-JOIN chipProcessedImfile USING(exp_id, chip_id)
-JOIN rawExp using(exp_id)
-LEFT JOIN distComponent 
-    ON distRun.dist_id = distComponent.dist_id 
-    AND chipProcessedImfile.class_id = distComponent.component
+-- JOIN chipProcessedImfile USING(exp_id, chip_id)
+JOIN rawExp using(exp_id)
+LEFT JOIN distComponent 
+    ON distRun.dist_id = distComponent.dist_id 
+--    AND chipProcessedImfile.class_id = distComponent.component
 WHERE
     distRun.state = 'new'