Changeset 38563 for trunk

Timestamp:

Jul 2, 2015, 9:40:59 AM (11 years ago)

Author:

bills

Message:

support for skycal updates add staticskytool_revert_update.sql

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• staticskytool_pendingskycalrun.sql (modified) (1 diff)

trunk/ippTools/share/Makefile.am

@@ -435 +435 @@
         staticskytool_result.sql \
         staticskytool_revert.sql \
+        staticskytool_revert_update.sql \
         warptool_change_skyfile_data_state.sql \
         warptool_change_run_state.sql \

trunk/ippTools/share/staticskytool_pendingskycalrun.sql

@@ -19 +19 @@
 LEFT JOIN skycalResult USING(skycal_id)
 WHERE
-   (skycalRun.state = 'new' AND skycalResult.skycal_id IS NULL)
+   ((skycalRun.state = 'new' AND skycalResult.skycal_id IS NULL)
+    OR (skycalRun.state ='update' and staticskyRun.state ='full' and skycalResult.fault = 0))