Return to clean_db.pl CVS log

Up to [LON-CAPA] / loncom / debugging_tools

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

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.3     ! albertel    7: # $Id: clean_db.pl,v 1.2 2005/03/18 21:36:49 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;
1.3     ! albertel   35: use lib '/home/httpd/lib/perl/';
        !            36: use LONCAPA;
1.1       albertel   37: 
                     38: #
                     39: # Options
                     40: my ($unesc,$help,$localize_times) = (0,0,0);
                     41: GetOptions(     "help"     => \$help);
                     42: 
                     43: #
                     44: # Help them out if they ask for it
                     45: if ($help) {
                     46:     print <<END;
                     47: clean_db.pl - clean a db of a certain key
                     48: Specify the database filename on the command line.
                     49: And the Key to remove.
                     50: Options:
                     51:    --help     Display this help.
                     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: 
1.3     ! albertel   62: my $dbref =&LONCAPA::locking_hash_tie($fname,&GDBM_WRCREAT());
        !            63: 
        !            64: if (! $dbref) {
        !            65:     warn("Unable to tie to $fname");
1.1       albertel   66:     exit;
                     67: }
1.3     ! albertel   68: while (my ($key,$value) = each(%{$dbref})) {
1.1       albertel   69:     if ($key ne $key_to_remove) { next; }
1.3     ! albertel   70:     delete($dbref->{$key});
1.1       albertel   71:     if ($fname =~ m|/nohist_[^/]*.db|) { exit; }
                     72:     my $hist=$fname;
                     73:     $hist=~s/\.db$/.hist/;
                     74:     open(HIST,">>$hist");
1.3     ! albertel   75:     print HIST ("D:".time.":$key\n");
1.1       albertel   76:     close(HIST);
                     77: }
                     78: exit;
                     79: