3 # Copyright (C) 2011 ByWater Solutions
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
23 # possible modules to use
24 use Getopt::Long qw( GetOptions );
28 use C4::Biblio qw( GetMarcBiblio ModBiblio );
29 use Pod::Usage qw( pod2usage );
33 pod2usage( -verbose => 2 );
38 my $dbh = C4::Context->dbh;
40 # Benchmarking variables
41 my $startime = time();
53 'o|output:s' => \$outfile,
55 'where:s' => \$whereclause,
62 $whereclause = "WHERE $whereclause";
65 # output log or STDOUT
67 if (defined $outfile) {
68 open ($fh, '>', $outfile) || die ("Cannot open output file");
70 open($fh, '>&', \*STDOUT) || die ("Couldn't duplicate STDOUT: $!");
73 my $sth1 = $dbh->prepare("SELECT biblionumber, frameworkcode FROM biblio $whereclause");
76 # fetch info from the search
77 while (my ($biblionumber, $frameworkcode) = $sth1->fetchrow_array){
78 my $record = GetMarcBiblio({ biblionumber => $biblionumber });
80 my $modok = ModBiblio($record, $biblionumber, $frameworkcode);
84 print $fh "Touched biblio $biblionumber\n" if (defined $verbose);
87 print $fh "ERROR WITH BIBLIO $biblionumber !!!!\n";
97 my $time = $endtime-$startime;
98 my $accuracy = $totalcount ? ($goodcount / $totalcount) * 100 : 0; # this is a percentage
100 $averagetime = $time / $totalcount if $totalcount;
101 print "Good: $goodcount, Bad: $badcount (of $totalcount) in $time seconds\n";
102 printf "Accuracy: %.2f%%\nAverage time per record: %.6f seconds\n", $accuracy, $averagetime if (defined $verbose);
111 touch_all_biblios.pl -v
112 touch_all_biblios.pl --where=STRING
116 When changes are made to ModBiblio (or the routines that are called by those),
117 it is sometimes necessary to run ModBiblio on all or some records in the catalog
118 when upgrading. This script does this.
128 Provide verbose log information.
132 Limits the search with a user-specified WHERE clause.