Changeset 17145 for trunk/ippTools/share/warptool_tooverlap.sql

Timestamp:

Mar 25, 2008, 1:23:41 PM (18 years ago)

Author:

jhoblitt

Message:

add warptool -block/-masked/-unblock modes

File:

• trunk/ippTools/share/warptool_tooverlap.sql (modified) (3 diffs)

trunk/ippTools/share/warptool_tooverlap.sql

@@ -1 +1 @@
 SELECT
     warpRun.warp_id,
-    camProcessedExp.cam_id,
+    warpRun.cam_id,
+    warpRun.workdir,
     warpRun.tess_id,
-    warpRun.workdir,
+    warpRun.label,
     rawExp.camera,
-    exp_id
+    exp_id,
+    warpRun.magiced
 FROM warpRun
 JOIN camProcessedExp
@@ -15 +17 @@
 LEFT JOIN warpSkyCellMap
     USING(warp_id, cam_id)
+LEFT JOIN warpMask
+    ON warpRun.label = warpMask.label
 WHERE
     warpRun.state = 'run'
@@ -20 +24 @@
     AND warpSkyCellMap.warp_id IS NULL
     AND warpSkyCellMap.cam_id IS NULL
+    AND warpMask.label IS NULL