Changeset 23384

Timestamp:

Mar 18, 2009, 10:13:41 AM (17 years ago)

Author:

bills

Message:

add hook for updating chipProcessedImfile.magicked

File:

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

trunk/ippTools/share/chiptool_change_imfile_data_state.sql

@@ -1 +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
+-- args are new data_state, a possibly empty string for updating the magicked state,
+-- chip_id and class_id
 UPDATE chipProcessedImfile
+JOIN rawImfile USING(exp_id, class_id)
     SET 
-    data_state = '%s'
+    chipProcessedImfile.data_state = '%s'
+    -- set magicked hook %s
 WHERE
     chip_id = %lld