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 # find Koha's Perl modules
24 # test carefully before changing this
26 eval { require "$FindBin::Bin/../kohalib.pl" };
29 # possible modules to use
30 use Getopt::Long qw( GetOptions );
35 use Pod::Usage qw( pod2usage );
39 pod2usage( -verbose => 2 );
44 my $dbh = C4::Context->dbh;
46 # Benchmarking variables
47 my $startime = time();
59 'o|output:s' => \$outfile,
61 'where:s' => \$whereclause,
68 $whereclause = "WHERE $whereclause";
71 # output log or STDOUT
73 if (defined $outfile) {
74 open ($fh, '>', $outfile) || die ("Cannot open output file");
76 open($fh, '>&', \*STDOUT) || die ("Couldn't duplicate STDOUT: $!");
79 # FIXME Would be better to call Koha::Items->search here
80 my $sth_fetch = $dbh->prepare("SELECT biblionumber, itemnumber, itemcallnumber FROM items $whereclause");
81 $sth_fetch->execute();
83 # fetch info from the search
84 while (my ($biblionumber, $itemnumber, $itemcallnumber) = $sth_fetch->fetchrow_array){
86 my $item = Koha::Items->find($itemnumber);
89 for my $c (qw( itemcallnumber cn_source ) ){
90 $item->make_column_dirty($c);
93 eval { $item->store };
94 my $modok = $@ ? 0 : 1;
98 print $fh "Touched item $itemnumber\n" if (defined $verbose);
101 print $fh "ERROR WITH ITEM $itemnumber !!!!\n";
110 my $endtime = time();
111 my $time = $endtime-$startime;
112 my $accuracy = ($goodcount / $totalcount) * 100; # this is a percentage
114 $averagetime = $time / $totalcount if $totalcount;
115 print "Good: $goodcount, Bad: $badcount (of $totalcount) in $time seconds\n";
116 printf "Accuracy: %.2f%%\nAverage time per record: %.6f seconds\n", $accuracy, $averagetime if (defined $verbose);
125 touch_all_items.pl -v
126 touch_all_items.pl --where=STRING
130 When changes are made to ModItem (or the routines that are called by it), it is
131 sometimes necessary to run ModItem on all or some records in the catalog when
132 upgrading. This script does that.
142 Provide verbose log information.
146 Limits the search with a user-specified WHERE clause.