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

trunk/ippTools/share/magicdstool_torevert_camera.sql

@@ -19 +19 @@
     JOIN rawExp using(exp_id)
 WHERE magicDSRun.stage = 'camera'
-    AND (magicDSRun.state = 'new' OR magicDSRun.state = 'censored')
-    AND magicDSFile.fault > 0
+    AND ((magicDSRun.state = 'new' AND magicDSFile.fault > 0)
+       OR magicDSRun.state = 'goto_censored'
+       OR magicDSRun.state = 'goto_restored')