Changeset 28854

Timestamp:

Aug 5, 2010, 2:20:59 PM (16 years ago)

Author:

bills

Message:

from trunk. fix extra output from magicdstool -torevert -stage chip (the other files just have property changes. I don't know why)

Location:

tags/ipp-20100701/ippTools/share

Files:

• . (modified) (1 prop)
• bgtool_warpinputs.sql (modified) (1 prop)
• chiptool_revertprocessedimfile.sql (modified) (1 prop)
• magicdstool_torevert_chip.sql (modified) (2 diffs, 1 prop)

tags/ipp-20100701/ippTools/share/magicdstool_torevert_chip.sql

@@ -2 +2 @@
     magic_ds_id,
     magicDSRun.state,
-    exp_id,
+    rawExp.exp_id,
     re_place,
     camera,
@@ -19 +19 @@
     JOIN camProcessedExp using(cam_id)
     JOIN chipRun ON (stage_id = chipRun.chip_id)
-    -- JOIN chipProcessedImfile ON (stage_id = chipProcessedImfile.chip_id AND component = class_id)
-    JOIN chipProcessedImfile USING(chip_id, exp_id)
-    JOIN rawExp using(exp_id)
+    JOIN chipProcessedImfile ON (stage_id = chipProcessedImfile.chip_id AND component = class_id)
+    JOIN rawExp ON chipRun.exp_id = rawExp.exp_id
 WHERE magicDSRun.stage = 'chip'
     AND ((magicDSRun.state = 'new' AND magicDSFile.fault > 0)