Changeset 29668

Timestamp:

Nov 4, 2010, 12:40:31 PM (16 years ago)

Author:

watersc1

Message:

Forgot the sql files.

Location:

tags/ipp-20101029/ippTools/share

Files:

• difftool_definestackstack_part0.sql (modified) (2 diffs, 1 prop)
• difftool_definestackstack_part1.sql (modified) (3 diffs, 1 prop)

tags/ipp-20101029/ippTools/share/difftool_definestackstack_part0.sql

@@ -22 +22 @@
            stackRun.state = 'full' AND
            stackSumSkyfile.fault = 0 AND stackSumSkyfile.quality = 0
-           -- template where hook %s
+           @STACK2_QUERY@ -- template condition
      GROUP BY
            skycell_id,
@@ -38 +38 @@
           JOIN stackSumSkyfile USING(stack_id)
           WHERE 1
-          -- input where hook %s
+          @STACK1_QUERY@ -- input condition
 ) AS diffExp ON diffExp.stack1 = stackRun.stack_id AND diffExp.stack2 = template.max_stack_id
 WHERE
         stackSumSkyfile.fault = 0 AND stackSumSkyfile.quality = 0
-        -- diff where hook %s
-        -- input where hook again %s
+        @DIFF0_QUERY@  -- diff constraint
+        @STACK1_QUERY@ -- input constraint
 ORDER BY stackRun.data_group,stackRun.filter

tags/ipp-20101029/ippTools/share/difftool_definestackstack_part1.sql

@@ -23 +23 @@
            stackRun.state = 'full' AND
            stackSumSkyfile.fault = 0 AND stackSumSkyfile.quality = 0
-           -- template where hook %s
+           @STACK2_QUERY@ -- template constraint
      GROUP BY
            skycell_id,
@@ -39 +39 @@
           JOIN stackSumSkyfile USING(stack_id)
           WHERE 1
-          -- input where hook %s
+          @STACK1_QUERY@ -- input constraint
 ) AS diffExp ON diffExp.stack1 = stackRun.stack_id AND diffExp.stack2 = template.max_stack_id
 WHERE
         stackSumSkyfile.fault = 0 AND stackSumSkyfile.quality = 0
-        -- diff where hook %s
-        -- input where hook again %s
+        @STACK1_QUERY@ -- input constraint
 group by stackRun.stack_id,
        stackRun.data_group,
@@ -54 +53 @@
        template.max_stack_id,
        template.template_label
+       @DIFF1_QUERY@  -- diff constraint
 ORDER BY stackRun.data_group,stackRun.filter,stackRun.skycell_id