Changeset 36409 for branches/bills_branches/bills_201312/ippTools/share/fftool_definebyquery.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_definebyquery.sql (modified) (1 diff)

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

@@ -1 +1 @@
 SELECT
-    warpRun.warp_id,
     skycalRun.skycal_id,
     skycalResult.path_base,
-    skycalRun.data_group
+    skycalRun.data_group,
+    stackRun.tess_id,
+    stackRun.skycell_id,
+    stackRun.filter
 FROM skycalRun
     JOIN skycalResult USING(skycal_id)
     JOIN stackRun USING(stack_id)
     JOIN skycell USING(tess_id, skycell_id)
-    JOIN warpRun USING(tess_id)
-    JOIN warpSkyfile USING(warp_id, skycell_id)
-    JOIN fakeRun USING(fake_id)
-    JOIN camRun USING(cam_id)
-    JOIN chipRun USING(chip_id)
-    JOIN rawExp ON chipRun.exp_id = rawExp.exp_id and stackRun.filter = rawExp.filter
-    LEFT JOIN fullForceRun ON fullForceRun.skycal_id = fullForceRun.skycal_id 
-        AND fullForceRun.warp_id = warpRun.warp_id 
-        AND warpSkyfile.tess_id = stackRun.tess_id
-        AND warpSkyfile.skycell_id = stackRun.skycell_id -- join hook %s
+    -- join hook %s
 WHERE 
     skycalRun.state = 'full' AND skycalResult.quality = 0
-    AND warpRun.state = 'full' AND warpSkyfile.quality = 0
-
--- an optimization might be to do cuts on distance between rawExp.ra,decl and skycell centers within some amount
-
-