Changeset 24945

Timestamp:

Jul 30, 2009, 11:57:40 AM (17 years ago)

Author:

jhoblitt

Message:

update

Location:

trunk/arclog

Files:

• arclog.pl (modified) (2 diffs)
• arclog_readdb.pl (modified) (5 diffs)

trunk/arclog/arclog.pl

@@ -19 +19 @@
 use Pod::Usage qw( pod2usage );
 
-my ($email);
+my ($debug, $email);
 
 GetOptions(
-    'email|s=s'    => \$email,
+    'debug|d'   => \$debug,
+    'email|s=s' => \$email,
 ) || pod2usage( 2 );
 
@@ -176 +177 @@
         = @$rec{qw( host time device event elapse_time errors )};
     # pack record
-    $query->execute("$host|$time|$device|$event|$elapse_time|$errors")
+    my $rec = "$host|$time|$device|$event|$elapse_time|$errors";
+    $query->execute($rec)
         or die "database error: $!";
+    warn "inserting $rec\n" if $debug;
 
     # do not print filtered records

trunk/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;
 }