Changeset 25022 for branches/eam_branches/20090715/arclog/arclog_readdb.pl

Timestamp:

Aug 7, 2009, 12:45:24 PM (17 years ago)

Author:

eugene

Message:

update from mainline

Location:

branches/eam_branches/20090715

Files:

• . (modified) (1 prop)
• arclog/arclog_readdb.pl (modified) (5 diffs)

branches/eam_branches/20090715/arclog/arclog_readdb.pl

@@ -19 +19 @@
 pod2usage( -msg => "Unknown option: @ARGV", -exitval => 2 ) if @ARGV;
 
-my $filter_records = 1;
+my $filter_records = 0;
 
 my $rcfile = "$ENV{HOME}/.arclogrc";
@@ -30 +30 @@
 die "can not open logdb" unless $dbh;
 
-my $query = $dbh->prepare("SELECT * FROM log")
+my $query = $dbh->prepare("SELECT record, stamp FROM log")
     or die "database error: $!";
 $query->execute or die "database error: $!";
@@ -52 +52 @@
     @rec{qw( host time device event elapse_time errors )} 
         = split(/\|/, $row->[0]);
+    $rec{stamp} = $row->[1];
     $rec{time} = $strptime->parse_datetime($rec{time});
     push @records, \%rec;
@@ -60 +61 @@
 
 RECORDS: foreach my $rec (@records) {
-    my ($host, $time, $device, $event, $elapse_time, $errors)
-        = @$rec{qw( host time device event elapse_time errors )};
+    my ($host, $stamp, $time, $device, $event, $elapse_time, $errors)
+        = @$rec{qw( host stamp time device event elapse_time errors )};
 
     # do not print filtered records
@@ -71 +72 @@
 
     no warnings qw( uninitialized );
-    print "$host $time $device $event $elapse_time $errors\n";
+    print "$stamp - $host $time $device $event $elapse_time $errors\n";
     use warnings;
 }