Changeset 28031 for branches/czw_branch/20100427/ippTools/share/chiptool_setimfiletoupdate.sql

Timestamp:

May 19, 2010, 2:11:08 PM (16 years ago)

Author:

eugene

Message:

updates from trunk

Location:

branches/czw_branch/20100427

Files:

• . (modified) (1 prop)
• ippTools/share/chiptool_setimfiletoupdate.sql (modified) (2 diffs)

branches/czw_branch/20100427/ippTools/share/chiptool_setimfiletoupdate.sql

@@ -1 +1 @@
 UPDATE chipRun
     JOIN chipProcessedImfile USING(chip_id)
+    LEFT JOIN magicDSRun ON (stage_id = chip_id AND stage = 'chip')
+    LEFT JOIN magicDSFile ON (magicDSRun.magic_ds_id = magicDSFile.magic_ds_id
+                              AND component = class_id)
 SET chipRun.state = 'update', 
     chipProcessedImfile.data_state = 'update'
@@ -7 +10 @@
     AND (chipRun.state = 'cleaned' OR chipRun.state = 'update')
     AND (chipProcessedImfile.data_state = 'cleaned')
+    -- don't queue update if the associated magicDSFile exists
+    AND (chipRun.magicked = 0 
+      OR (magicDSRun.state = 'cleaned' OR magicDSRun.state = 'new')
+            AND magicDSFile.component IS NULL)