Changeset 24512 for trunk/ippTools/share/difftool_skyfile.sql

Timestamp:

Jun 19, 2009, 12:38:16 PM (17 years ago)

Author:

Paul Price

Message:

Done with development of mechanism to automatically publish detections: merging branches/pap_mops (r24510) into trunk

Location:

trunk

Files:

• . (modified) (1 prop)
• ippTools/share/difftool_skyfile.sql (modified) (2 diffs)

trunk/ippTools/share/difftool_skyfile.sql

@@ -5 +5 @@
     diffRun.state,
     diffRun.workdir,
+    diffRun.bothways,
+    camProcessedExp.zpt_obs,
+    camProcessedExp.zpt_stdev,
+    camProcessedExp.zpt_lq,
+    camProcessedExp.zpt_uq,
+    rawExp.exp_time,
+    rawExp.camera,
     warp1,
     stack1,
@@ -13 +20 @@
 JOIN diffInputSkyfile USING(diff_id, skycell_id)
 JOIN warpRun
+-- NOTE: joining input only!
+-- This is so that we can get the correct zero point
+-- XXX This needs to be more clever to handle diffs between stacks
     ON warpRun.warp_id = diffInputSkyfile.warp1
 JOIN fakeRun USING(fake_id)
 JOIN camRun USING(cam_id)
+JOIN camProcessedExp USING(cam_id)
 JOIN chipRun USING(chip_id)
 JOIN rawExp USING(exp_id)