Changeset 29278

Timestamp:

Sep 30, 2010, 9:18:41 AM (16 years ago)

Author:

rhenders

Message:

Added optimize option

File:

• trunk/tools/czarclean.pl (modified) (3 diffs)

trunk/tools/czarclean.pl

@@ -9 +9 @@
 
 my $czarDbName = undef;
-my $begin = undef;
-my $end = undef;
+my $from = undef;
+my $to = undef;
 my $interval = undef;
 my $verbose = undef;
+my $optimize = undef;
 
 GetOptions (
         "dbname|d=s" => \$czarDbName,
         "interval|i=s" => \$interval,
-        "begin|b=s" => \$begin,
-        "end|e=s" => \$end,
+        "from|f=s" => \$from,
+        "to|t=s" => \$to,
+        "optimize|o" => \$optimize,
         "verbose|v" => \$verbose,
         );
@@ -30 +32 @@
     print "* UNKNKOWN: option                          @ARGV\n";
 }
-if (!$begin) {
+if (!$from) {
     $quit=1;
-    print "* REQUIRED: choose a begin date             -b <datetime>\n";
+    print "* REQUIRED: choose a from date                 -b <datetime>\n";
 }
-if (!$end) {
-
-    if($begin) {$end=$begin;} else {$end="NULL";}
-    print "* OPTIONAL: choose an end date              -e <datetime>                   (default=$end)\n";
+if (!$to) {
+    if($from) {$to=$from;} else {$to="NULL";}
+    print "* OPTIONAL: choose a to date                   -e <datetime>                   (default=$to)\n";
 }
 if (!$czarDbName) {
     $czarDbName = "czardb";
-    print "* OPTIONAL: choose czar Db name             -d <name>                       (default=$czarDbName\n";
+    print "* OPTIONAL: choose czar Db name                -d <name>                       (default=$czarDbName\n";
 }
 if (!$interval) {
     $interval = "30 MINUTE";
-    print "* OPTIONAL: choose time interval            -i <'30 MINUTE'|'1 hour'|etc>   (default=$interval)\n";
+    print "* OPTIONAL: choose time interval               -i <'30 MINUTE'|'1 hour'|etc>   (default=$interval)\n";
+}
+if (!$optimize) {
+    $optimize = 0;
+    print "* OPTIONAL: optimize database after cleanup    -o <'30 MINUTE'|'1 hour'|etc>   (default=$interval)\n";
 }
 print "*\n*******************************************************************************\n";
@@ -60 +65 @@
 
 
-$czarDb->cleanupDateRange($begin, $end, $interval);
-
+$czarDb->cleanupDateRange($from, $to, $interval);
+if ($optimize) {$czarDb->optimize();}