Changeset 32570

Timestamp:

Oct 27, 2011, 11:16:13 AM (15 years ago)

Author:

bills

Message:

handle case where the quality of a chip has changed since it was first processed.
Omit chips with non-zero quality

Location:

trunk/ippTools/share

Files:

• warptool_scmap.sql (modified) (1 diff)
• warptool_towarped.sql (modified) (1 diff)

trunk/ippTools/share/warptool_scmap.sql

@@ -29 +29 @@
     ON chipRun.chip_id = chipProcessedImfile.chip_id
     AND warpSkyCellMap.class_id = chipProcessedImfile.class_id
+    AND chipProcessedImfile.quality = 0
 JOIN rawImfile
     ON chipRun.exp_id = rawImfile.exp_id

trunk/ippTools/share/warptool_towarped.sql

@@ -100 +100 @@
         AND warpSkyfile.fault = 0
         AND camRun.state = 'full'
+        AND chipProcessedImfile.quality = 0
+        -- Maybe add this to solve the if any chip is bad a whole warp can't be updated problem?
+        -- AND (chipProcessedImfile.fault = 0 OR chipProcessedImfile.fault = 26)
         AND (Label.active OR Label.active IS NULL)
         -- where hook 2 %s