Changeset 25419 for trunk/ippTools/share/magictool_censor_raw.sql

Timestamp:

Sep 16, 2009, 9:47:16 AM (17 years ago)

Author:

bills

Message:

Change magicdstool -todestreak to query the individual stages separately.
This greatly decreases the query time.
Add support for magicDSRun.state = 'goto_restore' and 'goto_censored' which
will restore destreaked files back to their original state.
Split up ippTasks/magic.pro into magic.pro and destreak.pro so that processing
can be easily magnaged separately

File:

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

trunk/ippTools/share/magictool_censor_raw.sql

@@ -2 +2 @@
     JOIN magicDSRun USING(magic_id)
     JOIN magicDSFile USING(magic_ds_id) 
-    JOIN rawExp ON rawExp.magicked = magic_ds_id
-    JOIN rawImfile ON rawExp.exp_id = rawImfile.exp_id
+    JOIN rawImfile ON rawImfile.magicked = magic_ds_id
+--    JOIN rawExp ON rawExp.magicked = magic_ds_id
 SET rawImfile.magicked = 0, 
-    rawExp.magicked = 0, 
-    magicDSRun.state = 'censored', 
+--    rawExp.magicked = 0, 
+--    magicDSRun.state = 'censored', 
     magicDSFile.fault = 42