Changeset 35154 for trunk/ippTools/share/bgtool_definechip.sql

Timestamp:

Feb 12, 2013, 4:24:02 PM (13 years ago)

Author:

bills

Message:

Further changes to background spur in the pipeline.

1. Add chipBackgroundRun.cam_id
2. Use camera stage mask instead of chip stage mask
3. Drop warpBackgroundRun.alt_cam_label use chipBackgroundRun.cam_id to find the astrometry
4. Fix broken processing of chipBackground stats output

File:

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

trunk/ippTools/share/bgtool_definechip.sql

@@ -1 +1 @@
 SELECT
-    chipRun.*
+    chipRun.*,
+    camRun.cam_id,
+    chip_bg_id,
+    CURRENT_TIMESTAMP AS registered
 FROM chipRun
 JOIN rawExp USING(exp_id)
-LEFT JOIN chipBackgroundRun USING(chip_id)
-WHERE chipRun.state = 'full'
+JOIN chipRun as altChipRun USING(exp_id)
+JOIN camRun ON altChipRun.chip_id = camRun.chip_id
+JOIN camProcessedExp USING(cam_id)
+LEFT JOIN chipBackgroundRun ON chipBackgroundRun.chip_id = chipRun.chip_id -- labelHook %s
+WHERE chipRun.state = 'full' AND camRun.state ='full' AND camProcessedExp.quality = 0