Changeset 27799

Timestamp:

Apr 28, 2010, 3:32:34 PM (16 years ago)

Author:

rhenders

Message:

Getting dist_group for single exposure case

File:

• trunk/ippToPsps/scripts/ippToPsps_run.pl (modified) (3 diffs)

trunk/ippToPsps/scripts/ippToPsps_run.pl

@@ -128 +128 @@
             WHERE camRun.chip_id = chipRun.chip_id
             AND chipRun.exp_id = rawExp.exp_id
-            AND camRun.label like '%$label%'
+            AND camRun.label LIKE '%$label%'
             ORDER BY rawExp.exp_id ASC
 SQL
+            #AND rawExp.exp_id > 136561
             #AND camRun.dist_group LIKE 'sas'
             #AND rawExp.decl >= '-0.157079633' AND rawExp.decl <= '0.157079633' Jims Dec range
@@ -138 +139 @@
         $query = $db->prepare(<<SQL);
 
-        SELECT DISTINCT exp_id FROM rawExp WHERE rawExp.exp_id = $singleExpId
+        SELECT DISTINCT rawExp.exp_id, dist_group FROM rawExp, chipRun WHERE chipRun.exp_id = rawExp.exp_id AND rawExp.exp_id = $singleExpId
 SQL
     }
@@ -176 +177 @@
         my $batchOutputPath = sprintf("$jobOutputPath/%s", $batchDir);
 
-        print "* Preparing exposure as job '$job'...\n";
+        print "* Preparing exposure $expId as job '$job'...\n";
 
         # make directories