#!/usr/bin/perl

#
# Copyright (c) 2001, 2011, Oracle and/or its affiliates. All rights reserved. 
#
#  $Id:oracle_sage_category_metrics.pl 
#
#
# NAME  
#   oracle_sage_category_metrics.pl
#
# DESC 
#
# NOTES
#
# MODIFIED  (MM/DD/YY)
#    spalapu 08/28/08 - 
#    spalapu 08/28/08 - 
#    spalapu 08/28/08 - 
#    spalapu 08/28/08 - 
#    spalapu 08/27/08 - 
#    spalapu 08/27/08 - replace cellmonitor with cellmonitor
#    spalapu 08/26/08 - 
#    spalapu 08/26/08 - removed sage from plug-in and added exadata. Also,
#                       fixed realm reports to remove targer_guid from realm
#                       reports. Creating new files from oracle_sage_cell
#    spalapu 07/17/08 - 
#    spalapu 07/17/08 - fix conversion of collectiontime to secs
#    loliu   06/20/08 - Bug 7157542: Added iormtimestamp. Fixed IO request
#                       timestamp.
#    spalapu 05/27/08 - split metrics to small and large
#    spalapu 05/01/08 - Change cumulative value to Cumulative
#    spalapu 04/25/08 - 
#    spalapu 04/17/08 - Split IO Requests into Small and Large from current
#                       Read and Write
#    spalapu 04/03/08 - remove uneccesary fields
#    spalapu 03/28/08 - change ifs to elsifs where possible
#    spalapu 03/19/08 - Add Copyright statements
#    spalapu 03/18/08 - 
#    spalapu 03/17/08 - 
#    spalapu 02/13/08 - new file
#   spalapud 10/07/06 	Created the file.
#
#CATEGORY
#--------
#CT_IO_RQ
#CT_IO_WT_RQ
#CT_IO_WT
# 

use XML::Parser;
use Class::Struct;
require emx::oracle_cell::oracle_cell_common;
require "emd_common.pl";

our %categories;  # Hash of categories

$ipaddress=doPing(@ARGV);

if($ipaddress eq "") {
  print "em_error=Failed to ping Cell\n";
  exit -1;
}
my $command = "ssh -l cellmonitor $ipaddress cellcli  -xml -e 'list metriccurrent where objectType=".'\"IORM_CATEGORY\"'."'";
EMD_PERL_DEBUG("command = $command \n");

my $xmlout = `$command`;

my $str;
use Data::Dumper;
$str = Dumper($xmlout);
EMD_PERL_DEBUG($str);

my $parser = XML::Parser->new( Handlers => {
                                      Start=>\&handle_start,
                                      End=>\&handle_end,
				      Char=> \&characterData,
                                     });
$str = Dumper($parser);
EMD_PERL_DEBUG($str);

my $myinf;
my $io_requests;
my $io_wait_requests;
my $io_wait_per_request;
$parser->parse( $xmlout);

       foreach $category (keys %categories)
       {
#          $io_requests = $categories{$category}{CT_IO_RQ};
#          $io_wait_requests = $categories{$category}{CT_IO_WT};
#          print "em_result=".$categories{$category}{name}."|".$cellname."|".$realmname."|Category*_Statistics|CATEGORY|".$io_requests."|".$categories{$category}{CT_IO_RQ_time}."|".$io_wait_requests."|"."\n";
          print "em_result=".$categories{$category}{name}."|".$cellname."|".$realmname."|".$iormtimestamp."|Category*_Statistics|CATEGORY|".$categories{$category}{CT_IO_RQ_SM}."|".$categories{$category}{CT_IO_WT_SM}."|".$categories{$category}{CT_IO_RQ_LG}."|". $categories{$category}{CT_IO_WT_LG}."|".$categories{$category}{CT_IO_RQ_SM_time}."\n";
       }

#-----------------------------------------------------------------
# FUNCTIONS :  handle_start
#
#
# DESC : Does node based parsing of the XML output.
#
# ARGUMENTS :
#		elements : Node elements in the XML 
#  		attrs 	 : Attributes of the elements.
#
#
#-----------------------------------------------------------------

sub handle_start {
    my( $expat, $element, %attrs  ) = @_;
    $myinf="";
    if ($element eq "context")
    {
      if( %attrs )
      {
         $cellname = $attrs{cell};
         $realmname = $attrs{realm};
         $iormtimestamp = $attrs{iormResetTimestamp};
         $iormtimestamp = $iormtimestamp/1000;

      }
    }
    elsif ($element eq "cli-output")
    {
       $myinf="cli-output";
    }
    elsif ($element eq "name")
    {
       $myinf="name";
    }
    elsif ($element eq "metricType")
    {
       $myinf="metric_type";
    }
    elsif ($element eq "metricValue")
    {
       $myinf="metric_value";
    }
    elsif ($element eq "collectionTime")
    {
       $myinf="collection_time";
    }
    elsif ($element eq "metricObjectName")
    {
       $myinf="object_name";
    }
    else
    {
       EMD_PERL_DEBUG("invisible element = $element \n");
    }
}

sub handle_end {
    my( $expat, $element, %attrs  ) = @_;
    if ($element eq "metric")
    {
      if ($realmname eq "") {
        $realmname="NONE";
      }
    }
    else
    {
       EMD_PERL_DEBUG("find not metric element: $element \n");
    }
}

sub characterData {
    my( $parseinst, $data ) = @_;
    $space=" ";
    $data =~ s/\n//g;
    if (($data !~ m/^\s/) and ($data ne "\""))
    {
       if ($myinf eq "name" )
       {
         $name=$name.$data;
       }
       elsif ($myinf eq "metric_type" )
       {
         $metric_type=$metric_type.$data;
       }
       elsif ($myinf eq "metric_value" )
       {
         $metric_value=$metric_value.$data;
         if ($metric_type eq "Cumulative")
         {
           $collection_time = $collection_time/1000;
           $categories{$object_name}{name} = $object_name;
           $categories{$object_name}{$name} = $metric_value;
           $categories{$object_name}{$name."_time"} = $collection_time;
         }
         $name="";
         $metric_type="";
         $metric_value="";
         $collection_time="";
         $object_name="";
       }
       elsif ($myinf eq "collection_time" )
       {
         $data=$data;
         $collection_time=$collection_time.$data;
       }
       elsif ($myinf eq "object_name" )
       {
         $object_name=$object_name.$data;
       }
    }
}