Changeset 24112

Timestamp:

May 8, 2009, 9:58:00 AM (17 years ago)

Author:

bills

Message:

add *Run.workdir to the listing modes. This will be used by the distribution server to
make the manifest file

Location:

trunk/ippTools/share

Files:

• camtool_find_processedexp.sql (modified) (1 diff)
• chiptool_processedimfile.sql (modified) (1 diff)
• difftool_skyfile.sql (modified) (1 diff)
• faketool_processedimfile.sql (modified) (1 diff)
• receivetool_pendingfile.sql (modified) (2 diffs)
• regtool_processedimfile.sql (modified) (1 diff)
• stacktool_sumskyfile.sql (modified) (1 diff)
• warptool_warped.sql (modified) (1 diff)

trunk/ippTools/share/camtool_find_processedexp.sql

@@ -1 +1 @@
 SELECT
     camProcessedExp.*,
+    camRun.workdir,
     chipRun.chip_id,
     rawExp.exp_tag,

trunk/ippTools/share/chiptool_processedimfile.sql

@@ -9 +9 @@
     chipProcessedImfile.path_base,
     chipRun.state,
+    chipRun.workdir,
     rawExp.exp_id,
     rawExp.exp_tag,

trunk/ippTools/share/difftool_skyfile.sql

@@ -4 +4 @@
     diffRun.tess_id,
     diffRun.state,
+    diffRun.workdir,
     warp1,
     stack1,

trunk/ippTools/share/faketool_processedimfile.sql

@@ -1 +1 @@
 SELECT DISTINCT
     fakeProcessedImfile.*,
+    fakeRun.workdir,
     rawExp.exp_tag,
     rawExp.exp_name,

trunk/ippTools/share/receivetool_pendingfile.sql

@@ -4 +4 @@
     product,
     workdir,
+    destdir,
     fileset,
     fileset_id,
@@ -17 +18 @@
     ON receiveResult.file_id = receiveFile.file_id
 WHERE
-    receiveFileset.state = 'new'
+    ((receiveFileset.state = 'new') OR (receiveFileset.state = 'listed' AND receiveFile.component = 'dbinfo'))
+    AND receiveFileset.fault = 0
     AND receiveResult.file_id IS NULL

trunk/ippTools/share/regtool_processedimfile.sql

@@ -1 +1 @@
 SELECT
     rawImfile.*,
+    rawExp.workdir,
     newExp.tmp_exp_name,
     newExp.tmp_camera,
     newExp.tmp_telescope
 FROM rawImfile
+JOIN rawExp
+    USING(exp_id)
 JOIN newExp
     USING(exp_id)

trunk/ippTools/share/stacktool_sumskyfile.sql

@@ -2 +2 @@
     stackSumSkyfile.*,
     stackRun.state,
+    stackRun.workdir,
     (SELECT rawExp.camera FROM 
         stackInputSkyfile 

trunk/ippTools/share/warptool_warped.sql

@@ -2 +2 @@
     warpSkyfile.*,
     warpRun.state,
+    warpRun.workdir,
     warpImfile.warp_skyfile_id,
     rawExp.exp_id,