Changeset 19092 for trunk/ippTools/share/camtool_reset_faulted_runs.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/camtool_reset_faulted_runs.sql (modified) (1 diff)

trunk/ippTools/share/camtool_reset_faulted_runs.sql

@@ -1 +1 @@
 UPDATE camRun, camProcessedExp, chipRun, rawExp
-SET camRun.state = 'run'
+SET camRun.state = 'new'
 WHERE
     camRun.cam_id = camProcessedExp.cam_id