Changeset 42699 for branches/eam_branches/ipp-20230313/ippTools/share

Timestamp:

Jun 24, 2024, 9:16:02 AM (2 years ago)

Author:

eugene

Message:

shakedown the xcstack-related tools; make staticsky definebyquery skycell_id selection a LIKE

Location:

branches/eam_branches/ipp-20230313/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• xcstacktool_addbyquery_select.sql (modified) (1 diff)
• xcstacktool_definebyquery_select.sql (modified) (1 diff)
• xcstacktool_definebyquery_select_XC.sql (added)

branches/eam_branches/ipp-20230313/ippTools/share/Makefile.am

@@ -556 +556 @@
         fpcamtool_revertupdatedexp.sql \
         xcstacktool_definebyquery_select.sql \
+        xcstacktool_definebyquery_select_XC.sql \
         xcstacktool_addbyquery_select.sql \
         xcstacktool_addcamera.sql \

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

@@ -26 +26 @@
   ) AS TMP
     LEFT JOIN xcstackInputSkyfile
-    ON (TMP.stack_id = xcstackInputSkyfile.stack_id)
+    ON (TMP.xcstack_id = xcstackInputSkyfile.xcstack_id)
     AND (camera_id = %d)
     WHERE xcstackInputSkyfile.xcstack_id IS NULL

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

@@ -5 +5 @@
     xcstack_id,
     stackRun.stack_id,
-    tess_id,
-    skycell_id,
-    filter
+    stackRun.tess_id,
+    stackRun.skycell_id,
+    stackRun.filter
     FROM %s.stackRun
     JOIN %s.stackSumSkyfile USING (stack_id)
-    LEFT JOIN xcstackInputSkyfile
-    ON (stackRun.stack_id = xcstackInputSkyfile.stack_id)
-    AND (xcstackInputSkyfile.camera_id = %d)
-    WHERE xcstack_id IS NULL
+    LEFT JOIN
+