Changeset 19092 for trunk/ippTools/share/difftool_inputskyfile.sql

Timestamp:

Aug 16, 2008, 1:27:58 PM (18 years ago)

Author:

eugene

Message:

extensive changes from eam_branch_20080719:

• added the 'cleanup' options to camtool, faketool, warptool, difftool, stacktool
• added corresponding sql code
• changed the states for camera, fake, warp, diff, and stack to the new set of states: new, full, goto_cleaned, cleaned, update, goto_purged, and purged
• added 'data_state' entries to the detrend tables and the detRunSummary
• added 'cleanup' options to dettool using the detRunSummary data_state as the control
• moved dettool supporting code to dettool_STAGE, where stage is processedimfile, processedexp, etc.
• converted dettool to use S64 for det_id and exp_id entries

File:

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

trunk/ippTools/share/difftool_inputskyfile.sql

@@ -30 +30 @@
         ON chipRun.exp_id = rawExp.exp_id
     WHERE
-        diffRun.state = 'run'
-        AND warpRun.state = 'stop'
-        AND fakeRun.state = 'stop'
-        AND camRun.state = 'stop'
+        diffRun.state = 'new'
+        AND warpRun.state = 'full'
+        AND fakeRun.state = 'full'
+        AND camRun.state = 'full'
         AND chipRun.state = 'full'
     UNION
@@ -66 +66 @@
         ON chipRun.exp_id = rawExp.exp_id
     WHERE
-        diffRun.state = 'run'
-        AND warpRun.state = 'stop'
-        AND fakeRun.state = 'stop'
-        AND camRun.state = 'stop'
+        diffRun.state = 'new'
+        AND warpRun.state = 'full'
+        AND fakeRun.state = 'full'
+        AND camRun.state = 'full'
         AND chipRun.state = 'full'
     ) as Foo