Changeset 25511 for trunk/ippTools/share/magictool_restore_chip.sql

Timestamp:

Sep 23, 2009, 1:45:03 PM (17 years ago)

Author:

bills

Message:

Finish implementing magictool -censorrun

File:

• trunk/ippTools/share/magictool_restore_chip.sql (moved) (moved from trunk/ippTools/share/magictool_censor_chip.sql ) (1 diff, 1 prop)

trunk/ippTools/share/magictool_restore_chip.sql

@@ -1 @@
-UPDATE chipRun 
-    JOIN chipProcessedImfile USING(chip_id, exp_id) 
-    JOIN magicDSRun ON stage_id = chip_id AND stage = 'chip' AND re_place
-    JOIN magicDSFile USING(magic_ds_id) 
-    JOIN magicRun using(magic_id)
+UPDATE magicRun
+    JOIN magicDSRun USING(magic_id)
+    JOIN chipRun ON stage = 'chip' AND stage_id = chip_id
+    JOIN chipProcessedImfile USING(chip_id)
 SET chipProcessedImfile.magicked = 0, 
     chipRun.magicked = 0, 
-    magicDSRun.state = 'censored', 
-    magicDSFile.fault = 42
+    magicDSRun.state = '@NEW_STATE@'
+WHERE re_place