Changeset 38296 for trunk/ippTools/share/staticskytool_todo.sql

Timestamp:

May 21, 2015, 8:13:08 AM (11 years ago)

Author:

bills

Message:

Minor changes to staticskytool to support "updating" runs.
Add path_base to -todo mode. This will list NULL for new runs and
the existing path base for runs in state update.
Add -set_quality option to -updateresult

File:

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

trunk/ippTools/share/staticskytool_todo.sql

@@ -12 +12 @@
     skycell.glong,
     skycell.glat,
+    staticskyResult.path_base,
     IFNULL(Label.priority, 10000) AS priority
 FROM staticskyRun
@@ -20 +21 @@
 LEFT JOIN Label ON staticskyRun.label = Label.label
 WHERE
-   (staticskyRun.state = 'new' AND staticskyResult.sky_id IS NULL)
+   ((staticskyRun.state = 'new' AND staticskyResult.sky_id IS NULL)
+    OR (staticskyRun.state = 'update' AND staticskyResult.fault = 0))
+    
    AND (Label.active OR Label.active IS NULL)