Return to clean_db.pl CVS log

Up to [LON-CAPA] / loncom / debugging_tools

Annotation of loncom/debugging_tools/clean_db.pl, revision 1.2

1.1       albertel    1: #!/usr/bin/perl -w
                      2: #
                      3: # The LearningOnline Network
                      4: #
                      5: # dump_db.pl - dump a GDBM database to standard output, unescaping if asked to.
                      6: #
1.2     ! albertel    7: # $Id: clean_db.pl,v 1.1 2005/03/18 20:07:21 albertel Exp $
1.1       albertel    8: #
                      9: # Copyright Michigan State University Board of Trustees
                     10: #
                     11: # This file is part of the LearningOnline Network with CAPA (LON-CAPA).
                     12: #
                     13: # LON-CAPA is free software; you can redistribute it and/or modify
                     14: # it under the terms of the GNU General Public License as published by
                     15: # the Free Software Foundation; either version 2 of the License, or
                     16: # (at your option) any later version.
                     17: #
                     18: # LON-CAPA is distributed in the hope that it will be useful,
                     19: # but WITHOUT ANY WARRANTY; without even the implied warranty of
                     20: # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
                     21: # GNU General Public License for more details.
                     22: #
                     23: # You should have received a copy of the GNU General Public License
                     24: # along with LON-CAPA; if not, write to the Free Software
                     25: # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
                     26: #
                     27: # /home/httpd/html/adm/gpl.txt
                     28: #
                     29: # http://www.lon-capa.org/
                     30: #
                     31: #################################################
                     32: use strict;
                     33: use Getopt::Long;
                     34: use GDBM_File;
                     35: 
                     36: #
                     37: # Options
                     38: my ($unesc,$help,$localize_times) = (0,0,0);
                     39: GetOptions(     "help"     => \$help);
                     40: 
                     41: #
                     42: # Help them out if they ask for it
                     43: if ($help) {
                     44:     print <<END;
                     45: clean_db.pl - clean a db of a certain key
                     46: Specify the database filename on the command line.
                     47: And the Key to remove.
                     48: Options:
                     49:    --help     Display this help.
                     50:    --unescape Unescape the keys and values before printing them out.
                     51:    -u        Same as --unescape
                     52:    -t        Localize times when possible (human readable times)
                     53: Example: 
                     54:     dump_db.pl mydata.db "error:"
                     55: END
                     56:     exit;
                     57: }
                     58: 
                     59: my $fname = shift;
                     60: my $key_to_remove = shift;
                     61: 
                     62: my %db;
1.2     ! albertel   63: if (! tie(%db,'GDBM_File',$fname,&GDBM_WRITER(),0640)) {
1.1       albertel   64:     warn "Unable to tie to $fname";
                     65:     exit;
                     66: }
                     67: while (my ($key,$value) = each(%db)) {
                     68:     if ($key ne $key_to_remove) { next; }
                     69:     delete($db{$key});
                     70:     if ($fname =~ m|/nohist_[^/]*.db|) { exit; }
                     71:     my $hist=$fname;
                     72:     $hist=~s/\.db$/.hist/;
                     73:     open(HIST,">>$hist");
                     74:     print HIST "D:".time.":$key\n";
                     75:     close(HIST);
                     76: }
                     77: exit;
                     78: