Changeset 35039 for trunk/ippTools/share

Timestamp:

Jan 23, 2013, 4:55:10 PM (13 years ago)

Author:

bills

Message:

Add skycell args to staticskytool -todo -revert and -revertskycal to
allow selecting by coordinates.
Add -abs_glat_min and -abs_glat_max to the skycell args to make it easier
to select things away from or near the galactic plane

Location:

trunk/ippTools/share

Files:

• staticskytool_revert.sql (modified) (1 diff)
• staticskytool_revertskycal.sql (modified) (1 diff)

trunk/ippTools/share/staticskytool_revert.sql

@@ -1 +1 @@
 DELETE FROM staticskyResult
-USING staticskyResult, staticskyRun
+USING staticskyResult, staticskyRun, staticskyInput, stackRun, skycell
 WHERE staticskyRun.sky_id = staticskyResult.sky_id
+    AND staticskyRun.sky_id = staticskyInput.sky_id
+    AND staticskyInput.stack_id = stackRun.stack_id
+    AND stackRun.tess_id = skycell.tess_id
+    AND stackRun.skycell_id = skycell.skycell_id
     AND staticskyRun.state = 'new'
     AND staticskyResult.fault != 0

trunk/ippTools/share/staticskytool_revertskycal.sql

@@ -1 +1 @@
 DELETE FROM skycalResult
-USING skycalResult, skycalRun, stackRun
+USING skycalResult, skycalRun, stackRun, skycell
 WHERE skycalRun.skycal_id = skycalResult.skycal_id
     AND stackRun.stack_id = skycalRun.stack_id
     AND skycalRun.state = 'new'
     AND skycalResult.fault != 0
+    AND stackRun.tess_id = skycell.tess_id
+    AND stackRun.skycell_id = skycell.skycell_id