Changeset 24427 for branches/pap_mops/ippTools/share/difftool_skyfile.sql

Timestamp:

Jun 15, 2009, 5:28:09 PM (17 years ago)

Author:

Paul Price

Message:

Adding script to do the actual publishing to DataStore. Decided to bundle all components into the same script (we're working with detections, it's serial, should be fast) to simply things (can remove the 'advance' mode for pubtool). Everything compiles, not tested yet.

File:

• branches/pap_mops/ippTools/share/difftool_skyfile.sql (modified) (2 diffs)

branches/pap_mops/ippTools/share/difftool_skyfile.sql

@@ -6 +6 @@
     diffRun.workdir,
     diffRun.bothways,
+    camProcessedExp.zpt_obs,
+    camProcessedExp.zpt_stdev,
+    camProcessedExp.zpt_lq,
+    camProcessedExp.zpt_uq,
     warp1,
     stack1,
@@ -14 +18 @@
 JOIN diffInputSkyfile USING(diff_id, skycell_id)
 JOIN warpRun
-    ON warpRun.warp_id = diffInputSkyfile.warp1
+    ON warpRun.warp_id = diffInputSkyfile.warp1 -- NOTE: joining input only!
 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)