Changeset 18029 for trunk/ippTools/share/warptool_scmap.sql

Timestamp:

Jun 9, 2008, 12:55:57 PM (18 years ago)

Author:

jhoblitt

Message:

merge faketool branch

File:

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

trunk/ippTools/share/warptool_scmap.sql

@@ -7 +7 @@
 JOIN warpSkyCellMap
     USING(warp_id)
+JOIN fakeRun
+    USING(fake_id)
+JOIN camRun
+    USING(cam_id)
 JOIN camProcessedExp
-    ON warpSkyCellMap.cam_id = camProcessedExp.cam_id
+    USING(cam_id)
+JOIN chipRun
+    USING(chip_id)
 JOIN chipProcessedImfile
-    ON camProcessedExp.chip_id = chipProcessedImfile.chip_id
+    ON chipRun.chip_id = chipProcessedImfile.chip_id
     AND warpSkyCellMap.class_id = chipProcessedImfile.class_id
--- move this as an option into the code
--- WHERE
+WHERE
 --    warpRun.state = 'run'
+    fakeRun.state = 'stop'
+    AND camRun.state = 'stop'
+    AND chipRun.state = 'stop'