Changeset 19527

Timestamp:

Sep 11, 2008, 3:33:27 PM (18 years ago)

Author:

bills

Message:

forgot to look for files to purge. added some comments

Location:

trunk/ippTools/share

Files:

• chiptool_change_exp_state.sql (modified) (1 diff)
• chiptool_change_imfile_data_state.sql (modified) (1 diff)
• chiptool_pendingcleanupimfile.sql (modified) (1 diff)
• chiptool_pendingcleanuprun.sql (modified) (1 diff)

trunk/ippTools/share/chiptool_change_exp_state.sql

@@ +1 @@
+-- change state of chipRun from goto_cleaned to cleaned or goto_purged to purged
+-- when all of the consituant imfiles are in the rgith state
+-- arguments are new state (cleaned or purged) chip_id and new state again for 
+-- the chipProcessedImfile sub query
 UPDATE chipRun
     SET state = '%s'

trunk/ippTools/share/chiptool_change_imfile_data_state.sql

@@ +1 @@
+-- handle changes in data_state. Used for the modes tocleanedimfile and topurgedimfile
+-- args are new data_state, chip_id, class_id, and current expected state for chipRun
 UPDATE chipProcessedImfile
     SET 

trunk/ippTools/share/chiptool_pendingcleanupimfile.sql

@@ -13 +13 @@
     USING(chip_id)
 WHERE
-    chipRun.state = 'goto_cleaned'
-    AND chipProcessedImfile.data_state = 'full'
+    ((chipRun.state = 'goto_cleaned' AND chipProcessedImfile.data_state = 'full')
+OR 
+    (chipRun.state = 'goto_purged' AND chipProcessedImfile.data_state != 'purged'))

trunk/ippTools/share/chiptool_pendingcleanuprun.sql

@@ -7 +7 @@
 USING (exp_id)
 WHERE
-    chipRun.state = 'goto_cleaned'
+    (chipRun.state = 'goto_cleaned' OR chipRun.state = 'goto_purged')