Changeset 12114 for trunk/ippTools/src/stacktool.c

Timestamp:

Feb 27, 2007, 6:25:37 PM (19 years ago)

Author:

Paul Price

Message:

Adding additional output.

File:

• trunk/ippTools/src/stacktool.c (modified) (3 diffs)

trunk/ippTools/src/stacktool.c

@@ -321 +321 @@
     psString query = psStringCopy(
         "SELECT\n"
-        "   warpSkyfile.*\n"
+        "   warpSkyfile.*,\n"
+        "   rawExp.camera\n"
         " FROM stackRun\n"
         " JOIN stackInputSkyfile\n"
@@ -327 +328 @@
         " JOIN warpSkyfile\n"
         "   ON  stackInputSkyfile.warp_id = warpSkyfile.warp_id\n"
-        "   AND stackRun.skycell_id    = warpSkyfile.skycell_id\n"
-        "   AND stackRun.tess_id       = warpSkyfile.tess_id\n"
+        "   AND stackRun.skycell_id       = warpSkyfile.skycell_id\n"
+        "   AND stackRun.tess_id          = warpSkyfile.tess_id\n"
+        " JOIN warpInputExp\n"
+        "   ON stackInputSkyfile.warp_id  = warpInputExp.warp_id\n"
+        " JOIN rawExp\n"
+        "   ON warpInputExp.exp_tag       = rawExp.exp_tag\n"
         " WHERE\n"
         "   stackRun.state = 'run'\n"
@@ -411 +416 @@
     psString query = psStringCopy(
         "SELECT\n"
-        "   stackRun.stack_id\n"
+        "   stackRun.stack_id,\n"
+        "   stackRun.workdir\n"
         " FROM stackRun\n"
         " LEFT JOIN stackSumSkyfile\n"