Return to clean_db.pl CVS log

Up to [LON-CAPA] / loncom / debugging_tools

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

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: #
        !             7: # $Id: dump_db.pl,v 1.3 2003/09/04 14:32:46 matthew Exp $
        !             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;
        !            63: if (! tie(%db,'GDBM_File',$fname,&GDBM_WRITER,0640)) {
        !            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: