Changeset 42596 for branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_toadvance.sql

Timestamp:

Jan 19, 2024, 8:12:15 AM (2 years ago)

Author:

eugene

Message:

working on xcfftool

File:

• branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_toadvance.sql (modified) (1 diff)

branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_toadvance.sql

@@ -1 +1 @@
 SELECT
-    fullForceRun.*,
-    stackRun.tess_id,
-    stackRun.skycell_id,
-    stackRun.filter,
-    rawExp.camera
-FROM fullForceRun
-    JOIN fullForceInput USING(ff_id)
-    JOIN xccalRun USING(xccal_id)
-    JOIN stackRun USING(stack_id)
-    JOIN warpRun USING(warp_id, tess_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, warp_id)
-    LEFT JOIN fullForceSummary USING(ff_id)
-WHERE fullForceRun.state = 'new' AND fullForceSummary.ff_id IS NULL
+    xcForceRun.xcff_id,
+    xcForceRun.tess_id,
+    xcForceRun.skycell_id,
+    xcForceRun.workdir,
+    xcForceRun.reduction
+FROM xcForceRun
+    JOIN xcForceInput USING(xcff_id)
+    LEFT JOIN xcForceResult USING(xcff_id, warp_id)
+    LEFT JOIN xcForceSummary USING(xcff_id)
+WHERE xcForceRun.state = 'new' AND xcForceSummary.ff_id IS NULL
     -- WHERE hook %s
-    GROUP BY ff_id
-    HAVING COUNT(fullForceInput.warp_id) = COUNT(fullForceResult.warp_id)
-        AND SUM(fullForceResult.fault) = 0
+    GROUP BY xcff_id
+    HAVING COUNT(xcForceInput.warp_id) = COUNT(xcForceResult.warp_id)
+        AND SUM(xcForceResult.fault) = 0