Changeset 27926 for trunk/ippTools

Timestamp:

May 12, 2010, 10:23:55 AM (16 years ago)

Author:

bills

Message:

When updating an image use the original path base for consistency with the database

Location:

trunk/ippTools/share

Files:

• chiptool_pendingimfile.sql (modified) (1 diff)
• warptool_towarped.sql (modified) (3 diffs)

trunk/ippTools/share/chiptool_pendingimfile.sql

@@ -11 +11 @@
     rawExp.telescope,
     rawExp.filelevel,
-    IFNULL(Label.priority, 10000) AS priority
+    IFNULL(Label.priority, 10000) AS priority,
+    chipProcessedImfile.path_base
 FROM chipRun
 JOIN rawExp

trunk/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)