Changeset 33171 for trunk/ippTools

Timestamp:

Jan 27, 2012, 1:58:32 PM (14 years ago)

Author:

bills

Message:

don't clean components with non-zero quality. Leave them in full state

Location:

trunk/ippTools/share

Files:

• chiptool_pendingcleanupimfile.sql (modified) (1 diff)
• difftool_pendingcleanupskyfile.sql (modified) (1 diff)
• warptool_pendingcleanupskyfile.sql (modified) (1 diff)

trunk/ippTools/share/chiptool_pendingcleanupimfile.sql

@@ -14 +14 @@
 WHERE
     ((chipRun.state = 'goto_cleaned' AND (chipProcessedImfile.data_state = 'full'
-                                       OR chipProcessedImfile.data_state = 'update'))
+                                       OR chipProcessedImfile.data_state = 'update') AND chipProcessedImfile.quality = 0)
 OR 
     (chipRun.state = 'goto_scrubbed' AND chipProcessedImfile.data_state != 'scrubbed')

trunk/ippTools/share/difftool_pendingcleanupskyfile.sql

@@ -9 +9 @@
     USING(diff_id)
 WHERE
-   ((diffRun.state = 'goto_cleaned'  AND (diffSkyfile.data_state = 'full' OR diffSkyfile.data_state = 'update'))
+   ((diffRun.state = 'goto_cleaned'  AND (diffSkyfile.data_state = 'full' OR diffSkyfile.data_state = 'update') AND diffSkyfile.quality = 0)
     OR
     (diffRun.state = 'goto_scrubbed' AND diffSkyfile.data_state != 'scrubbed')

trunk/ippTools/share/warptool_pendingcleanupskyfile.sql

@@ -11 +11 @@
 WHERE
    ((warpRun.state = 'goto_cleaned'  AND (warpSkyfile.data_state = 'full'
-                                      OR  warpSkyfile.data_state = 'update'))
+                                      OR  warpSkyfile.data_state = 'update')
+    AND warpSkyfile.quality = 0)
     OR
     (warpRun.state = 'goto_scrubbed' AND warpSkyfile.data_state != 'scrubbed')