Changeset 19558 for trunk/ippTools/share/stacktool_tosum.sql

Timestamp:

Sep 15, 2008, 2:21:00 PM (18 years ago)

Author:

bills

Message:

changes to support cleanup, purge, and update processing

File:

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

trunk/ippTools/share/stacktool_tosum.sql

@@ -5 +5 @@
     stackRun.workdir,
     stackRun.label,
+    stackRun.state,
     rawExp.camera
 FROM stackRun
@@ -26 +27 @@
     USING(stack_id)
 WHERE
-    stackRun.state = 'new'
-    AND stackSumSkyfile.stack_id IS NULL
+    ((stackRun.state = 'new'
+        AND stackSumSkyfile.stack_id IS NULL)
+    OR
+    (stackRun.state = 'update' 
+        AND stackSumSkyfile.data_state = 'cleaned'))