Changeset 28551

Timestamp:

Jun 29, 2010, 2:05:27 PM (16 years ago)

Author:

Paul Price

Message:

Only need warps to have completed, not necessarily in 'full' state, because we get all pixel inputs from chipBackgroundImfile; but we want to know which skycells have bad 'quality' so as to ignore them.

Location:

trunk/ippTools/share

Files:

• bgtool_definewarp.sql (modified) (1 diff)
• bgtool_towarp.sql (modified) (1 diff)
• bgtool_warpinputs.sql (modified) (1 diff)

trunk/ippTools/share/bgtool_definewarp.sql

@@ -10 +10 @@
 LEFT JOIN warpBackgroundRun USING(chip_bg_id)
 WHERE chipBackgroundRun.state = 'full'
+    AND warpRun.state IN ('full', 'cleaned', 'goto_cleaned') -- only need it to have been completed

trunk/ippTools/share/bgtool_towarp.sql

@@ -19 +19 @@
     AND chipBackgroundImfile.fault = 0
     AND chipBackgroundImfile.quality = 0
+    AND warpRun.state IN ('full', 'cleaned', 'goto_cleaned')
     AND warpSkyfile.fault = 0
     AND warpSkyfile.quality = 0

trunk/ippTools/share/bgtool_warpinputs.sql

@@ -11 +11 @@
 JOIN fakeRun USING(fake_id)
 JOIN camProcessedExp USING(cam_id)
-WHERE warpRun.state = 'full'
+WHERE warpRun.state IN ('full', 'cleaned', 'goto_cleaned') -- only need it to have been completed
     AND warpSkyfile.fault = 0
     AND warpSkyfile.quality = 0