#!/usr/bin/perl
# -*- mode: Perl -*-
##################################################################
# Remove old data from OV_DB files
##################################################################
# Created by Laurie Gellatly <gellatly@one.net.au>
# This reads an OV_DB file for the cut off and interface
# and calculates how many lines can be removed
#################################################################
#
# Distributed under the GNU copyleft
#
# $Id: ovcullfile,v 1.1.1.1 2002/02/26 10:16:36 oetiker Exp $
#
use strict;
use vars '$DEBUG';
my $ov_db = "/var/opt/OV/share/databases";
my $ovdb= $ov_db."/snmpCollect/";
my $DEBUG = 0;
   my($days2keep, $interface, $io , $cutoff) ;
   my($cnt, $data, $recno, $junk);
   my @names = ( "IfInErrors", "IfOutErrors", 
     "IfInOctets", "IfOutOctets", "avgBusy5");
   my @namext = (".err", "", ".cpu");
   my ($val);
   my $recsz = 24;
   my $fsize = -1;
   my $p = "',\$p'";
   my $parms = '-F\\t \'{printf("%d\\t%d\\t%s\\t%lg\\n", $4, $5, $6, $3)}\'';
   my @resu;

sub main {

   my($extn) = "";
   $days2keep = $ARGV[0];
   $interface = $ARGV[1];
   $io = $ARGV[2];
   die <<USAGE  unless (defined($days2keep) && defined($interface) && defined($io));

USAGE: ovcullfile '#days Interface# io&errs=1|cpu=0'

EXAMPLE:  ovcullfile 30 4 1

Delete all data older than 30 days for 
all interface 4 Input and Output Octets & Errors


USAGE
   $cutoff = time - ( 3600 * 24 * $days2keep) ;
   $extn =  $namext[$io];
   if ($io) {
      get(2);
      get(3);
      get(0);
      get(1);
   } else {
      get(4);
   }
}
  
main;
exit(0);

sub get {
   my ($ind) = @_;
   my ($starttime, $entime, $IPAdd1, $IPAdd2, $IPAdd3, $IPAdd4, $cnt, $val) ;
   my ($file) = $ovdb.$names[$ind].".".$interface;
   open (RAWIN , $file) or die "Could not open $file";
   my ($junk, $junk, $junk, $junk, $junk, $junk, $junk, $cfsize) = stat $file;
   binmode(RAWIN);
   my ($notfound) = (($cfsize / $recsz) - 1)> -1;
   if (($fsize == $cfsize) && ($recno > 1)){
      seek(RAWIN,($recno - 2) * $recsz, 0);
      $notfound = ($recsz == read(RAWIN, $data, $recsz));
      ($starttime, $entime, $IPAdd1, $IPAdd2, $IPAdd3, $IPAdd4, $cnt, $val) =
      unpack("LLCCCCLd",$data);
      if ($cutoff < $entime) {
         seek(RAWIN, 0, 0);
	 $recno = 1;
      }
   } else {
      $fsize = $cfsize;
      $recno = 1;
   } 
   while ($notfound){
# Read from the beginning of file
      $notfound = ($recsz == read(RAWIN, $data, $recsz));
      ($starttime, $entime, $IPAdd1, $IPAdd2, $IPAdd3, $IPAdd4, $cnt, $val) =
      unpack("LLCCCCLd",$data);
      if ($cutoff < $entime) {
	 $notfound = 0;
      } else {
	 $recno++;
      }
   }
   close (RAWIN);
   if ($recno > 1){
   @resu = `snmpColDump -tTI $file | sed -n $recno$p |
       awk $parms |
       snmpColDump -r - $file`
#       wc -l`
   }
   return ($recno);
}
