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

Timestamp:

Jan 30, 2013, 10:52:06 AM (13 years ago)

Author:

bills

Message:

Only queue chipBackgrounRuns for chipRun's that have camRuns that completed
with good quality (0).
This aviods proceeding with bad data and also insures that the camRun has finished
when the chipBackgrounRun happens. This will allow us to update the astrometry
with the cam stage solution.

File:

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

trunk/ippTools/share/bgtool_definechip.sql

@@ -3 +3 @@
 FROM chipRun
 JOIN rawExp USING(exp_id)
+JOIN camRun USING(chip_id)
+JOIN camProcessedExp USING(cam_id)
 LEFT JOIN chipBackgroundRun USING(chip_id)
 WHERE chipRun.state = 'full'
+AND camRun.state = 'full'
+AND camProcessedExp.quality = 0