Changeset 28455

Timestamp:

Jun 24, 2010, 11:20:29 AM (16 years ago)

Author:

Paul Price

Message:

Need extra information to construct command-line.

Location:

branches/pap/ippTools/share

Files:

• bgtool_tochip.sql (modified) (1 diff)
• bgtool_towarp.sql (modified) (2 diffs)

branches/pap/ippTools/share/bgtool_tochip.sql

@@ -1 +1 @@
 SELECT
     chipBackgroundRun.*,
-    class_id
+    class_id,
+    rawExp.exp_tag,
+    rawExp.camera
 FROM chipBackgroundRun
 JOIN chipRun USING(chip_id)
+JOIN rawExp USING(exp_id)
 JOIN chipProcessedImfile USING(chip_id)
 LEFT JOIN chipBackgroundImfile USING(chip_bg_id, class_id)

branches/pap/ippTools/share/bgtool_towarp.sql

@@ -1 +1 @@
 SELECT
     warpBackgroundRun.*,
-    warpSkyfile.*
+    warpSkyfile.*,
+    rawExp.exp_tag,
+    rawExp.camera,
 FROM warpBackgroundRun
 JOIN warpRun USING(warp_id)
@@ -7 +9 @@
 JOIN chipBackgroundRun USING(chip_bg_id)
 JOIN chipBackgroundImfile USING(chip_bg_id, class_id)
+JOIN chipRun USING(chip_id)
+JOIN rawExp USING(exp_id)
 LEFT JOIN warpBackgroundSkycell USING(warp_bg_id, skycell_id)
 LEFT JOIN Label ON Label.label = warpBackgroundRun.label