Changeset 25511 for trunk/ippTools/share/magictool_restore_raw.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_raw.sql (moved) (moved from trunk/ippTools/share/magictool_censor_raw.sql ) (1 diff, 1 prop)

trunk/ippTools/share/magictool_restore_raw.sql

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