Changeset 39149 for trunk/tools

Timestamp:

Nov 17, 2015, 9:59:05 AM (11 years ago)

Author:

bills

Message:

add option to skip the joins to the xsrc and xfit tables. In this case
just add the stack_id and other columns that we need

File:

• trunk/tools/bills/joinstackcmf (modified) (4 diffs)

trunk/tools/bills/joinstackcmf

@@ -23 +23 @@
 # for now just all or one
 
-my ($stack_id, $skycal_id);
+my ($stack_id, $skycal_id, $skip_joins);
 my $test;
 my ($save_temps, $verbose);
@@ -30 +30 @@
 GetOptions(
     "stack_id|s=s"      =>  \$stack_id,
+    "skip-joins"        =>  \$skip_joins,
     "test"              =>  \$test,
     "ofmt=s"            =>  \$ofmt,
@@ -83 +84 @@
 my $exthead = 'SkyChip';
 
-my $cmd = "$stilts tmatchn nin=5 matcher=exact values1=IPP_IDET values2=IPP_IDET values3=IPP_IDET"
+my $cmd;
+if ($skip_joins) {
+    $cmd = "$stilts tpipe in=$path cmd='"
+    .         "addcol -after IPP_IDET STACK_ID $stack_id;"
+    .         "addcol -after STACK_ID SKYCAL_ID $skycal_id;"
+    .         "addcol -after SKYCAL_ID PROJ_ID $proj;"
+    .         "addcol -after PROJ_ID CELL_ID $cell;"
+    . "'"
+    . " out=$output";
+} else {
+    $cmd = "$stilts tmatchn nin=5 matcher=exact values1=IPP_IDET values2=IPP_IDET values3=IPP_IDET"
     . " values4=IPP_IDET values5=IPP_IDET"
     . " fixcols=all suffix1='' suffix2=_exp suffix3=_dev suffix4=_ser suffix5='_xsrc'"
@@ -107 +118 @@
     . " progress=none"
     ;
+}
 
 $cmd .= " ofmt=$ofmt" if $ofmt;