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

trunk/ippTools/share/dettool_addprocessedexp.sql

@@ -25 +25 @@
   AND detProcessedExp.exp_id IS NULL
   AND detInputExp.include = 1
-  AND detRun.det_id = %s
-  AND detProcessedImfile.exp_id = '%s'
+  AND detRun.det_id = %lld
+  AND detProcessedImfile.exp_id = %lld
 GROUP BY
    detProcessedImfile.class_id,