Changeset 37879 for trunk/ippScripts

Timestamp:

Jan 27, 2015, 4:39:38 PM (11 years ago)

Author:

watersc1

Message:

Allow a stack association to be used as the basis for the inputs.

File:

• trunk/ippScripts/scripts/stack_bkg_mk_mdc.pl (modified) (4 diffs)

trunk/ippScripts/scripts/stack_bkg_mk_mdc.pl

@@ -12 +12 @@
 
 
-my ($dbname,$stack_id,$label,$camera,$filter);
+my ($dbname,$stack_id,$sass_id,$label,$camera,$filter);
 
 my $ipprc =  PS::IPP::Config->new(); # IPP Configuration
@@ -21 +21 @@
 GetOptions(
     'stack_id=s'   => \$stack_id, 
+    'sass_id=s'    => \$sass_id,
     'label=s'      => \$label,
     'filter=s'     => \$filter,
@@ -26 +27 @@
     'camera=s'     => \$camera,
     ) or pod2usage ( 2 );
-pod2usage( -msg => "Required options; --stack_id | --label", -exitval => 3) unless
+pod2usage( -msg => "Required options; --stack_id | --label | --sass_id", -exitval => 3) unless
     ((defined $stack_id)||(defined $label));
 pod2usage( -msg => "Required options; --camera --dbname ", -exitval => 3) unless
@@ -49 +50 @@
 
 
-my $query = "SELECT DISTINCT chip_id,cam_id,path_base FROM stackRun JOIN stackInputSkyfile USING(stack_id) JOIN warpRun USING(warp_id) JOIN fakeRun USING(fake_id) JOIN camRun USING(cam_id) JOIN camProcessedExp USING(cam_id) JOIN chipRun USING (chip_id) WHERE 1 ";
+my $query = "SELECT DISTINCT chip_id,cam_id,path_base FROM stackRun JOIN stackInputSkyfile USING(stack_id) JOIN stackAssociationMap USING(stack_id) JOIN warpRun USING(warp_id) JOIN fakeRun USING(fake_id) JOIN camRun USING(cam_id) JOIN camProcessedExp USING(cam_id) JOIN chipRun USING (chip_id) WHERE 1 ";
 
 if (defined($label)) {    $query .= " AND stackRun.label = '${label}' "; }
 if (defined($stack_id)) { $query .= " AND stack_id = ${stack_id} "; }
 if (defined($filter)) {   $query .= " AND stackRun.filter = '${filter}' "; }
+if (defined($sass_id))  { $query .= " AND sass_id = ${sass_id} "; }
 
 my $cams = $db->selectall_arrayref( $query );