Changeset 16733 for trunk/ippTools/share/warptool_imfile.sql

Timestamp:

Feb 28, 2008, 3:06:02 PM (18 years ago)

Author:

jhoblitt

Message:

require ippdb 1.1.31
remove warpInputExp table
remove warptool -runone & -addinputexp modes
add -cam_id & -magiced options to warptool -definerun

File:

• trunk/ippTools/share/warptool_imfile.sql (modified) (1 diff)

trunk/ippTools/share/warptool_imfile.sql

@@ -1 +1 @@
 SELECT DISTINCT
     rawImfile.*,
-    warpInputExp.cam_id,
+    warpRun.cam_id,
     chipProcessedImfile.uri as chip_uri,
     chipProcessedImfile.path_base as chip_path_base,
     camProcessedExp.path_base as cam_path_base
 FROM warpRun
-JOIN warpInputExp
-    USING(warp_id)
 JOIN camProcessedExp
-    ON warpInputExp.cam_id = camProcessedExp.cam_id
+    USING(cam_id)
 JOIN chipRun
     ON camProcessedExp.chip_id = chipRun.chip_id