Changeset 28017 for branches/czw_branch/20100427/ippTools/share/warptool_towarped.sql

Timestamp:

May 18, 2010, 5:06:01 PM (16 years ago)

Author:

watersc1

Message:

Almost working version of the mask-stats/software revision code.

Almost.

Location:

branches/czw_branch/20100427

Files:

• . (modified) (1 prop)
• ippTools/share/warptool_towarped.sql (modified) (3 diffs)

branches/czw_branch/20100427/ippTools/share/warptool_towarped.sql

@@ -11 +11 @@
     exp_tag,
     workdir,
-    magicked
+    magicked,
+    path_base
 FROM (
     SELECT DISTINCT
@@ -25 +26 @@
         rawExp.exp_tag,
         warpRun.workdir,
-        chipRun.magicked
+        chipRun.magicked,
+        CAST(NULL AS CHAR(255)) AS path_base
     FROM warpRun
     JOIN warpSkyCellMap
@@ -73 +75 @@
         rawExp.exp_tag,
         warpRun.workdir,
-        MIN(chipProcessedImfile.magicked) AS magicked
+        MIN(chipProcessedImfile.magicked) AS magicked,
+        warpSkyfile.path_base
     FROM warpRun
     JOIN warpImfile USING(warp_id)