Changeset 31428 for branches/czw_branch/20110406/ippTools/share/laptool_definerun.sql

Timestamp:

May 3, 2011, 2:25:17 PM (15 years ago)

Author:

watersc1

Message:

difftool: add the ability to specify both the input_warp_id and the template_warp_id. This allows us to explicitly say "subtract this one from that one."
stacktool: fix stackAssociation listing to supply the information, even if stackSumSkyfile isn't populated yet.
laptool: LAP now works cleanly from -definesequence through the final stack stage for runs that do not require a quickstack.

File:

• branches/czw_branch/20110406/ippTools/share/laptool_definerun.sql (modified) (1 diff)

branches/czw_branch/20110406/ippTools/share/laptool_definerun.sql

@@ -1 @@
-SELECT exp_id, chip_id, false as private, true as active, false as pairwise
-  FROM rawExp 
-  LEFT JOIN 
-  (SELECT exp_id, chip_id
-     FROM lapExp 
-     where private IS FALSE 
-     AND data_state = 'full') AS old USING(exp_id)
+SELECT want.exp_id, have.chip_id, false as private, true as active, false as pairwise
+  FROM
+  (SELECT exp_id FROM rawExp 
      WHERE rawExp.exp_type= 'OBJECT' AND
      rawExp.dateobs >= '2009-04-01T00:00:00.000000' AND
 -- Position restriction goes here.
+     @WHERE@
+  ) AS want
+  LEFT JOIN 
+  (SELECT *
+     FROM lapExp 
+     where private IS FALSE 
+     AND chip_id IS NOT NULL
+     AND active = TRUE ) AS have USING(exp_id)
+     
+