Changeset 28817 for trunk/tools/difflog_grep.pl

Timestamp:

Jul 30, 2010, 4:41:26 PM (16 years ago)

Author:

heather

Message:

added some additional features (more information printed, like ippMonitor)

File:

• trunk/tools/difflog_grep.pl (modified) (5 diffs)

trunk/tools/difflog_grep.pl

@@ -28 +28 @@
 
 
-my ($db_host, $dbname, $db_user, $db_pw, $dateobs_begin, $dateobs_end, $label, $filter, $data_group, $dist_group, $ra, $decl, $radius, $limit, $pstamp_order, $magicked, $not_destreaked, $destreaked, $grep, $diffandsky, $uselogname); # Database details
+my ($db_host, $dbname, $db_user, $db_pw, $dateobs_begin, $dateobs_end, $label, $filter, $data_group, $dist_group, $ra, $decl, $radius, $limit, $pstamp_order, $magicked, $not_destreaked, $destreaked, $grep, $diffandsky, $uselogname, $ippMonitor); # Database details
 $db_host = 'ippdb01';
 $db_pw = 'ipp';
@@ -52 +52 @@
            'not_destreaked'   => \$not_destreaked,
            'destreaked'   => \$destreaked,
-           'diffandsky'  => \$diffandsky
+           'diffandsky'  => \$diffandsky,
+    'ippMonitor'  => \$ippMonitor,
     # No magicked inputs?
            ) or die "Unable to parse arguments.\n";
 die "Unknown option: @ARGV\n" if @ARGV;
-die "difflog_grep.pl uses difftool and grep to look for 'something' in many diffs logfiles.\n\nRequired options: --dbhost --dbname --dbuser --dbpass\n\nOptional options: --dateobs_begin, --dateobs_end, --label, --filter, --data_group, --dist_group, --ra, --decl, --radius, --limit, --pstamp_order, --magicked, --not_destreaked, --destreaked will select diff_ids from difftool to investigate\n\n--grep - if grep is not used will just list the log files \n--diffandsky will print the diff_id and sky_id instead of the logfilename\n"
+die "difflog_grep.pl uses difftool and grep to look for 'something' in many diffs logfiles.\n\nRequired options: --dbhost --dbname --dbuser --dbpass\n\nOptional options: --dateobs_begin, --dateobs_end, --label, --filter, --data_group, --dist_group, --ra, --decl, --radius, --limit, --pstamp_order, --magicked, --not_destreaked, --destreaked will select diff_ids from difftool to investigate\n\n--grep - if grep is not used will just list the log files \n--diffandsky will print the diff_id and sky_id instead of the logfilename\n--ippMonitor will add ippMonitor like output (bg, nsources, etc)\n"
 
     unless defined $db_host
@@ -97 +98 @@
 if (defined(@$stdout_buf)){
 
-
+    if (defined($diffandsky)) {
+        print "diff_id skycell ";
+    } else {print "logfile ";}
+
+    if (defined($ippMonitor)) {
+        print "bg bg_stdev dtime_diff dtime_match dtime_phot dtime_script stamps_num stamps_mean stamps_rms sources";
+    }
+
+
+        print "\n";
     my  $metadata2 = $mdcParser->parse(join "", @$stdout_buf) or
         die "Unable to parse metadata config";
@@ -127 +137 @@
 
 # Query to run
-my $sql = "SELECT path_base, diffSkyfile.diff_id, skycell_id from diffRun, diffSkyfile WHERE diffRun.diff_id = diffSkyfile.diff_id AND diffSkyfile.diff_id = $diff_id";
+my $sql = "SELECT path_base, diffSkyfile.diff_id, skycell_id, diffSkyfile.bg,diffSkyfile.bg_stdev,diffSkyfile.dtime_diff,diffSkyfile.dtime_match,diffSkyfile.dtime_phot,diffSkyfile.dtime_script,diffSkyfile.stamps_num,diffSkyfile.stamps_mean,diffSkyfile.stamps_rms,diffSkyfile.sources from diffRun, diffSkyfile WHERE diffRun.diff_id = diffSkyfile.diff_id AND diffSkyfile.diff_id = $diff_id";
 
 #print "$sql\n";
@@ -146 +156 @@
     } else {
 print "$logfile ";
+    }
+    
+
+    if (defined($ippMonitor)) {
+
+   if (defined($$row[3])) {printf "%2.4f ",$$row[3];} else {print "???     ";}
+   if (defined($$row[4])) {printf "%2.4f ",$$row[4];} else {print "???     ";}
+if (defined($$row[5])) {printf "%2.4f ",$$row[5];} else {print "???     ";}
+if (defined($$row[6])) {printf "%2.4f ",$$row[6];} else {print "???     ";}
+if (defined($$row[7])) {printf "%2.4f ",$$row[7];} else {print "???     ";}
+if (defined($$row[8])) {printf "%d ",$$row[8];} else {print "???     ";}
+if (defined($$row[9])) {printf "%d ",$$row[9];} else {print "???     ";}
+if (defined($$row[10])) {printf "%2.4f ",$$row[10];} else {print "???     ";}
+if (defined($$row[11])) {printf "%2.4f ",$$row[11];} else {print "???     ";}
+if (defined($$row[12])) {printf "%d ",$$row[12];} else {print "???     ";}
+
+
+
+
+
+# $$row[4] $$row[5] $$row[6] $$row[7] $$row[8] $$row[9] $$row[10] $$row[11] $$row[12] ";
+        
     }