Changeset 32571

Timestamp:

Oct 27, 2011, 11:17:59 AM (15 years ago)

Author:

bills

Message:

handle case where quality has changed for a chip since a run was first processed

Location:

tags/ipp-20110622/ippTools/share

Files:

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

tags/ipp-20110622/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

tags/ipp-20110622/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