Return to dump_db.pl CVS log

Up to [LON-CAPA] / loncom / debugging_tools

Annotation of loncom/debugging_tools/dump_db.pl, revision 1.8

1.1       matthew     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.8     ! albertel    7: # $Id: dump_db.pl,v 1.7 2006/08/08 18:20:50 albertel Exp $
1.1       matthew     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.4       matthew    35: use Data::Dumper;
1.5       albertel   36: use Storable qw(thaw);
1.6       www        37: use lib '/home/httpd/lib/perl/';
                     38: use LONCAPA;
1.7       albertel   39: use LONCAPA::Configuration;
                     40: use Cwd;
1.1       matthew    41: 
                     42: #
                     43: # Options
1.3       matthew    44: my ($unesc,$help,$localize_times) = (0,0,0);
1.1       matthew    45: GetOptions("unescape" => \$unesc,
1.2       matthew    46:            "u"        => \$unesc,
1.3       matthew    47:            "t"        => \$localize_times,
1.2       matthew    48:            "help"     => \$help);
1.1       matthew    49: 
                     50: #
                     51: # Help them out if they ask for it
                     52: if ($help) {
                     53:     print <<END;
                     54: dump_db.pl - dump GDBM_File databases to stdout.  
                     55: Specify the database filenames on the command line.
                     56: Specify --unescape to have all the keys and values unescaped from every
                     57: database.
                     58: Options:
                     59:    --help     Display this help.
                     60:    --unescape Unescape the keys and values before printing them out.
1.3       matthew    61:    -u        Same as --unescape
                     62:    -t        Localize times when possible (human readable times)
1.1       matthew    63: Examples: 
                     64:     dump_db.pl mydata.db
                     65:     dump_db.pl mydata.db yourdata.db ourdata.db theirdata.db
                     66:     dump_db.pl --unescape \*db
                     67: END
                     68:     exit;
                     69: }
                     70: 
1.7       albertel   71: my  %perlvar=%{&LONCAPA::Configuration::read_conf('loncapa.conf')};
                     72: 
1.1       matthew    73: #
                     74: # Loop through ARGV getting files.
                     75: while (my $fname = shift) {
1.7       albertel   76:     $fname = &Cwd::abs_path($fname);
                     77:     my $dbref;
                     78:     if ($fname =~ m/^\Q$perlvar{'lonUsersDir'}\E/) {
                     79: 	$dbref=&LONCAPA::locking_hash_tie($fname,&GDBM_READER());
                     80:     } else {
                     81: 	if (tie(my %db,'GDBM_File',$fname,&GDBM_READER(),0640)) {
                     82: 	    $dbref = \%db;
                     83: 	}
                     84:     }
1.6       www        85: 
                     86:     if (!$dbref) {
1.1       matthew    87:         warn "Unable to tie to $fname";
                     88:         next;
                     89:     }
1.6       www        90:     while (my ($key,$value) = each(%$dbref)) {
1.4       matthew    91:         if ($value =~ s/^__FROZEN__//) {
1.8     ! albertel   92:             $value = thaw(&unescape($value));
1.4       matthew    93:         }
1.1       matthew    94:         if ($unesc) {
                     95:             $key = &unescape($key);
1.4       matthew    96:             $value = &unescape($value) if (! ref($value));
1.3       matthew    97:         }
1.4       matthew    98:         if ($localize_times && ! ref($value)) {
                     99:             $value =~ s/([0-9]{10,10})/localtime($1)/ge;
1.1       matthew   100:         }
1.4       matthew   101:         print "$key = ".(ref($value)?Dumper($value):$value)."\n";
1.1       matthew   102:     }
1.8     ! albertel  103:     if ($fname =~ m/^\Q$perlvar{'lonUsersDir'}\E/) {
        !           104: 	&LONCAPA::locking_hash_untie($dbref);
        !           105:     } else {
        !           106: 	untie($dbref);
        !           107:     }
1.1       matthew   108: }
                    109: exit;
                    110: