Changeset 32265 for trunk/tools/diskspace/run_counter.pl
- Timestamp:
- Aug 31, 2011, 5:18:37 PM (15 years ago)
- File:
-
- 1 edited
-
trunk/tools/diskspace/run_counter.pl (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/tools/diskspace/run_counter.pl
r32230 r32265 1 #! /usr/local/bin/perl -w 1 #! /usr/bin/env perl 2 use warnings; 2 3 4 use DateTime; 5 use Sys::Hostname; 6 use PS::IPP::Config; 3 7 use DBI; 4 use Getopt::Std;5 8 6 getopts('I',\%opt);7 9 # Set up the database 8 10 use constant DB_SOCKET => '/var/run/mysqld/mysqld.sock'; … … 41 43 $im_query = 'select data_state,count(data_state) AS N from TABLETABLE GROUP BY data_state'; 42 44 43 if (exists($opt{I})) { 44 foreach $k (keys %im_stages) { 45 $stages{$k} = $im_stages{$k}; 46 } 45 foreach $k (keys %im_stages) { 46 $stages{$k} = $im_stages{$k}; 47 47 } 48 49 my $ipprc = PS::IPP::Config->new("GPC1"); 50 my $nebcon = $ipprc->nebulous(); 51 52 my @lt = gmtime; 53 $dt = DateTime->now; 54 $dt->subtract( days => $lt[6]); 55 my $datestring = $dt->ymd; 56 my $outfile = "neb:///ipp_diskspace/${datestring}/run_im_counts.dat"; 57 my $out_fh = $ipprc->file_create_open($outfile); 48 58 49 59 foreach $s (keys %stages) { 50 60 my $query = $base_query; 51 if (exists($ opt{I}) && exists($im_stages{$s})) {61 if (exists($im_stages{$s})) { 52 62 $query = $im_query; 53 63 } … … 57 67 foreach $rr (@{ $dr }) { 58 68 my ($state,$count) = @{ $rr }; 59 print "$s $state $count\n";69 print $out_fh "$s $state $count\n"; 60 70 } 61 71 } 62 72 close($out_fh); 73
Note:
See TracChangeset
for help on using the changeset viewer.
