Changeset 19092 for trunk/ippTools/share/dettool_definebydetrun.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/dettool_definebydetrun.sql (modified) (2 diffs)

trunk/ippTools/share/dettool_definebydetrun.sql

@@ -3 +3 @@
 INSERT INTO detInputExp
    SELECT
-       %d,
+       %lld,
        0,
        detResidExp.exp_id,
@@ -10 +10 @@
    JOIN rawExp
        USING(exp_id)
-   WHERE det_id = %d
+   WHERE det_id = %lld