Changeset 19181 for trunk/ippTools/share/chiptool_pendingimfile.sql

Timestamp:

Aug 23, 2008, 9:33:25 AM (18 years ago)

Author:

eugene

Message:

adding sample WHERE for update (commented out)

File:

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

trunk/ippTools/share/chiptool_pendingimfile.sql

@@ -25 +25 @@
     AND chipProcessedImfile.class_id IS NULL
     AND chipMask.label IS NULL
+
+-- new where logic for update.  we probably need to add a 'data_state'
+-- field to chipProcessedImfile and update it (full, cleaned, etc) as
+-- we cleanup or update
+--    (chipRun.state = 'new'
+--    AND chipProcessedImfile.chip_id IS NULL
+--    AND chipProcessedImfile.exp_id IS NULL
+--    AND chipProcessedImfile.class_id IS NULL
+--    AND chipMask.label IS NULL) 
+--    OR
+--    (chipRun.state = 'update'
+--    AND chipProcessedImfile.data_state = 'cleaned'