Changeset 26927 for trunk/ippTools/share

Timestamp:

Feb 12, 2010, 12:21:48 PM (16 years ago)

Author:

watersc1

Message:

Implement stackstack diff mode, based on already existing warpstack code.

Rework cleanup sql a bit to be lighter on the database server.

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• difftool_definestackstack_part0.sql (added)
• difftool_definestackstack_part1.sql (added)
• difftool_pendingcleanuprun.sql (modified) (6 diffs)

trunk/ippTools/share/Makefile.am

@@ -100 +100 @@
      difftool_definewarpwarp_select.sql \
      difftool_definewarpwarp_insert.sql \
+     difftool_definestackstack_part0.sql \
+     difftool_definestackstack_part1.sql \
      difftool_donecleanup.sql \
      difftool_export_input_skyfile.sql \

trunk/ippTools/share/difftool_pendingcleanuprun.sql

@@ -25 +25 @@
             USING(exp_id)
         WHERE
+        @INNERCONSTRAINT@
             (diffRun.state = 'goto_cleaned' OR 
              diffRun.state = 'goto_scrubbed' OR 
@@ -52 +53 @@
             USING(exp_id)
         WHERE
+        @INNERCONSTRAINT@
             (diffRun.state = 'goto_cleaned' OR 
              diffRun.state = 'goto_scrubbed' OR 
@@ -64 +66 @@
         JOIN diffInputSkyfile
             USING(diff_id)
-        JOIN stackSumSkyfile
-            ON  diffInputSkyfile.stack1 = stackSumSkyfile.stack_id
+--      JOIN stackSumSkyfile
+--          ON  diffInputSkyfile.stack1 = stackSumSkyfile.stack_id
         JOIN stackInputSkyfile
             ON diffInputSkyfile.stack1 = stackInputSkyfile.stack_id
@@ -79 +81 @@
             USING(exp_id)
         WHERE
+        @INNERCONSTRAINT@
             (diffRun.state = 'goto_cleaned' OR 
              diffRun.state = 'goto_scrubbed' OR 
@@ -91 +94 @@
         JOIN diffInputSkyfile
             USING(diff_id)
-        JOIN stackSumSkyfile
-            ON  diffInputSkyfile.stack2 = stackSumSkyfile.stack_id
+--      JOIN stackSumSkyfile
+--          ON  diffInputSkyfile.stack2 = stackSumSkyfile.stack_id
         JOIN stackInputSkyfile
             ON diffInputSkyfile.stack2 = stackInputSkyfile.stack_id
@@ -106 +109 @@
             USING(exp_id)
         WHERE
+        @INNERCONSTRAINT@
             (diffRun.state = 'goto_cleaned' OR 
              diffRun.state = 'goto_scrubbed' OR