Changeset 40746 for trunk/ippScripts

Timestamp:

May 17, 2019, 1:44:49 PM (7 years ago)

Author:

tdeboer

Message:

script updated to handle BRIGHT obs_modes

File:

• trunk/ippScripts/scripts/night_report.pl (modified) (8 diffs)

trunk/ippScripts/scripts/night_report.pl

@@ -68 +68 @@
 }
 
-##################33
+##################
 ### testing the diff grouping -- this does not work for the Euclid data taken 2018.07.29 because the OBJECT
 ### field is missing
@@ -382 +382 @@
     $query .= "     AND exp_type = 'OBJECT'";
     $query .= "     AND obs_mode NOT LIKE 'ENGINEERING'";
-    $query .= "     AND obs_mode like '%SS%'";
+    $query .= "     AND (obs_mode LIKE '%SS%' OR obs_mode LIKE '%BRIGHT%')";
     $query .= "     AND rawExp.comment like '%visit%'";
     $query .= "     AND (camProcessedExp.quality IS NULL or camProcessedExp.quality = 0)";
@@ -438 +438 @@
     $query .= "     AND exp_type = 'OBJECT'";
     $query .= "     AND obs_mode NOT LIKE 'ENGINEERING'";
-    $query .= "     AND obs_mode like '%SS%'";
+    $query .= "     AND (obs_mode LIKE '%SS%' OR obs_mode LIKE '%BRIGHT%')";
     $query .= "     AND rawExp.comment like '%visit%'";
     $query .= "     AND (camProcessedExp.quality IS NULL or camProcessedExp.quality = 0)";
@@ -474 +474 @@
     $query .= "     AND exp_type = 'OBJECT'";
     $query .= "     AND obs_mode NOT LIKE 'ENGINEERING'";
-    $query .= "     AND obs_mode like '%SS%'";
+    $query .= "     AND (obs_mode LIKE '%SS%' OR obs_mode LIKE '%BRIGHT%')";
     $query .= "     AND rawExp.comment like '%visit%'";
     $query .= "     AND (camProcessedExp.quality IS NULL or camProcessedExp.quality = 0)";
@@ -660 +660 @@
     $query .= "   AND exp_type = 'OBJECT'";
     $query .= "   AND obs_mode NOT LIKE 'ENGINEERING'";
-    $query .= "   AND obs_mode NOT like '%SS%'";
+    $query .= "   AND (obs_mode NOT LIKE '%SS%' AND obs_mode NOT LIKE '%BRIGHT%')";
     $query .= "   AND rawExp.comment like '%visit%'";
     $query .= "   AND (camProcessedExp.quality IS NULL or camProcessedExp.quality = 0)";
@@ -694 +694 @@
     $query .= "    WHERE dateobs like '$date%'";
     $query .= "    AND exp_id > $refExpID"; #REF
-    $query .= "    AND obs_mode like '%SS%'";
+    $query .= "    AND (obs_mode LIKE '%SS%' OR obs_mode LIKE '%BRIGHT%')";
     $query .= "    AND (camProcessedExp.quality = 0)";
     $query .= "  ) AS expall";
@@ -724 +724 @@
     while (@row = $result->fetchrow_array()) {
         if ($doHeader) {
-            print "Unpublished Solar System Exposures ( obs_mode like %SS% ) with good camera quality :\n";
+            print "Unpublished Solar System Exposures ( obs_mode like %SS% or obs_mode like %BRIGHT%) with good camera quality :\n";
             printf "%12s %12s %12s | %-19s | %-16s\n", "exp_name", "warp_id", "diff_id", "dateobs", "comment";
             $doHeader = 0;
@@ -751 +751 @@
     $query .= "     AND exp_type = 'OBJECT'";
     $query .= "     AND obs_mode NOT LIKE 'ENGINEERING'";
-    $query .= "     AND obs_mode like '%SS%'";
+    $query .= "     AND (obs_mode LIKE '%SS%' OR obs_mode LIKE '%BRIGHT%')";
     $query .= "     AND rawExp.comment like '%visit%'";
     $query .= "     AND (camProcessedExp.quality IS NULL or camProcessedExp.quality = 0)";