Changeset 25419 for trunk/ippTools/share/magictool_censor_diff.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_diff.sql (modified) (1 diff)

trunk/ippTools/share/magictool_censor_diff.sql

@@ -1 @@
-UPDATE magicRun 
-    JOIN magicDSRun USING(magic_id)
+UPDATE diffRun
+    JOIN diffSkyfile USING(diff_id)
+    JOIN magicRun USING(diff_id)
+    JOIN magicDSRun ON stage = 'diff' AND stage_id = diff_id AND re_place
     JOIN magicDSFile USING(magic_ds_id)
-    JOIN diffRun ON magic_ds_id = magicked
-    JOIN diffSkyfile ON diffRun.diff_id = diffSkyfile.diff_id
 SET diffRun.magicked = 0,
     diffSkyfile.magicked = 0,