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 );
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 # FIXME Would be better to call Koha::Items->search here
74 my $sth_fetch = $dbh->prepare("SELECT biblionumber, itemnumber, itemcallnumber FROM items $whereclause");
75 $sth_fetch->execute();
77 # fetch info from the search
78 while (my ($biblionumber, $itemnumber, $itemcallnumber) = $sth_fetch->fetchrow_array){
80 my $item = Koha::Items->find($itemnumber);
83 for my $c (qw( itemcallnumber cn_source ) ){
84 $item->make_column_dirty($c);
87 eval { $item->store };
88 my $modok = $@ ? 0 : 1;
92 print $fh "Touched item $itemnumber\n" if (defined $verbose);
95 print $fh "ERROR WITH ITEM $itemnumber !!!!\n";
104 my $endtime = time();
105 my $time = $endtime-$startime;
106 my $accuracy = $totalcount ? ($goodcount / $totalcount) * 100 : 0; # this is a percentage
108 $averagetime = $time / $totalcount if $totalcount;
109 print "Good: $goodcount, Bad: $badcount (of $totalcount) in $time seconds\n";
110 printf "Accuracy: %.2f%%\nAverage time per record: %.6f seconds\n", $accuracy, $averagetime if (defined $verbose);
119 touch_all_items.pl -v
120 touch_all_items.pl --where=STRING
124 When changes are made to ModItem (or the routines that are called by it), it is
125 sometimes necessary to run ModItem on all or some records in the catalog when
126 upgrading. This script does that.
136 Provide verbose log information.
140 Limits the search with a user-specified WHERE clause.