Changeset 28022 for trunk/ippTools/share/warptool_setskyfiletoupdate.sql

Timestamp:

May 19, 2010, 11:32:49 AM (16 years ago)

Author:

bills

Message:

Don't set run to update unless it has never been magicked or if the
magicDSFile has been cleaned

File:

• trunk/ippTools/share/warptool_setskyfiletoupdate.sql (modified) (2 diffs)

trunk/ippTools/share/warptool_setskyfiletoupdate.sql

@@ -1 +1 @@
 UPDATE warpRun
     JOIN warpSkyfile USING(warp_id)
+    LEFT JOIN magicDSRun ON (stage_id = warp_id AND stage = 'warp')
+    LEFT JOIN magicDSFile ON (magicDSRun.magic_ds_id = magicDSFile.magic_ds_id
+                              AND component = skycell_id)
 SET warpRun.state = 'update', 
     warpSkyfile.data_state = 'update'
@@ -7 +10 @@
     AND (warpRun.state = 'cleaned' OR warpRun.state = 'update')
     AND (warpSkyfile.data_state = 'cleaned')
+    AND (warpRun.magicked = 0
+      OR (magicDSRun.state = 'cleaned' OR magicDSRun.state = 'new')
+      AND magicDSFile.component IS NULL)