Changeset 19521

Timestamp:

Sep 11, 2008, 3:24:32 PM (18 years ago)

Author:

bills

Message:

Changes to support goto_cleaned, goto_purged, and update for warp stage

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (2 diffs)
• warptool_change_run_state.sql (added)
• warptool_change_skyfile_data_state.sql (added)
• warptool_pendingcleanuprun.sql (modified) (1 diff)
• warptool_pendingcleanupskyfile.sql (modified) (1 diff)
• warptool_updateskyfile.sql (added)

trunk/ippTools/share/Makefile.am

@@ -146 +146 @@
      stacktool_sumskyfile.sql \
      stacktool_tosum.sql \
+     warptool_change_skyfile_data_state.sql \
+     warptool_change_run_state.sql \
      warptool_definebyquery.sql \
      warptool_donecleanup.sql \
@@ -156 +158 @@
      warptool_tooverlap.sql \
      warptool_towarped.sql \
+     warptool_updateskyfile.sql \
      warptool_warped.sql

trunk/ippTools/share/warptool_pendingcleanuprun.sql

@@ -13 +13 @@
 USING (exp_id)
 WHERE
-    warpRun.state = 'goto_cleaned'
+    (warpRun.state = 'goto_cleaned' OR warpRun.state = 'goto_purged')

trunk/ippTools/share/warptool_pendingcleanupskyfile.sql

@@ -10 +10 @@
     USING(warp_id)
 WHERE
-    warpRun.state = 'goto_cleaned'
+    (warpRun.state = 'goto_cleaned' AND warpSkyfile.data_state = 'full')
+    OR
+    (warpRun.state = 'goto_purged' AND warpSkyfile.data_state != 'purged')