Changeset 35134 for trunk/ippTools/share

Timestamp:

Feb 8, 2013, 11:50:49 AM (13 years ago)

Author:

bills

Message:

For warp_bg stage add column alt_cam_label. If set use the smf file
from that cam run for the astrometry. This is intended to be a
camRun with the nomal backckground subtraction.

Location:

trunk/ippTools/share

Files:

• bgtool_towarp.sql (modified) (1 diff)
• bgtool_warp.sql (modified) (1 diff)
• pxadmin_create_tables.sql (modified) (1 diff)

trunk/ippTools/share/bgtool_towarp.sql

@@ -24 +24 @@
     AND (Label.active OR Label.active IS NULL)
 -- WHERE hook %s
-ORDER BY priority DESC, chip_bg_id
+ORDER BY priority DESC, warp_bg_id, skycell_id

trunk/ippTools/share/bgtool_warp.sql

@@ -4 +4 @@
     warpBackgroundRun.workdir,
     warpBackgroundRun.label,
+    warpBackgroundRun.alt_cam_label,
     rawExp.exp_id,
     rawExp.exp_name,

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1843 +1843 @@
     data_group VARCHAR(64),           -- group for data
     dist_group VARCHAR(64),           -- group for distribution
-    reduction VARCHAR(64),    -- reduction class (for altering recipe)
+    reduction VARCHAR(64),            -- reduction class (for altering recipe)
+    alt_cam_label VARCHAR(64),        -- label for alternate version of astrometry (optional)
     note VARCHAR(255),        -- note
     registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered