Changeset 36409 for branches/bills_branches/bills_201312/ippTools/share/fftool_todo.sql

Timestamp:

Dec 23, 2013, 2:32:53 PM (13 years ago)

Author:

bills

Message:

refinements to fullForce tables. Full force run is now for a
a collection of warps with the same skycell and filter.
warp_id is removed from fullForceRun and is now contained in table
fullForceInput. The final results of the run will be stored in the
new table fullForceSummary which is also added. Run will transition
from new to full when all inputs have been processed and the summary
object is inserted.

File:

• branches/bills_branches/bills_201312/ippTools/share/fftool_todo.sql (modified) (1 diff)

branches/bills_branches/bills_201312/ippTools/share/fftool_todo.sql

@@ -7 +7 @@
     warpSkyfile.path_base AS warp_path_base
 FROM fullForceRun
-    JOIN skycalRun using(skycal_id)
-    JOIN stackRun using(stack_id)
-    JOIN warpRun using(warp_id, tess_id)
+    JOIN fullForceInput USING(ff_id)
+    JOIN skycalRun USING(skycal_id)
+    JOIN stackRun USING(stack_id)
+    JOIN warpRun USING(warp_id, tess_id)
     JOIN warpSkyfile USING(warp_id, tess_id, skycell_id)
-    JOIN fakeRun using(fake_id)
-    JOIN camRun using(cam_id)
-    JOIN chipRun using(chip_id)
-    JOIN rawExp using(exp_id)
+    JOIN fakeRun USING(fake_id)
+    JOIN camRun USING(cam_id)
+    JOIN chipRun USING(chip_id)
+    JOIN rawExp USING(exp_id)
     LEFT JOIN fullForceResult USING(ff_id)
 WHERE fullForceRun.state = 'new'