3 #script to administer Authorities without biblio
5 # Copyright 2009 BibLibre
6 # written 2009-05-04 by paul dot poulain at biblibre.com
8 # This file is part of Koha.
10 # Koha is free software; you can redistribute it and/or modify it
11 # under the terms of the GNU General Public License as published by
12 # the Free Software Foundation; either version 3 of the License, or
13 # (at your option) any later version.
15 # Koha is distributed in the hope that it will be useful, but
16 # WITHOUT ANY WARRANTY; without even the implied warranty of
17 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 # GNU General Public License for more details.
20 # You should have received a copy of the GNU General Public License
21 # along with Koha; if not, see <http://www.gnu.org/licenses>.
27 use C4::AuthoritiesMarc;
30 use Koha::SearchEngine::Search;
36 'aut|authtypecode:s' => \@authtypes,
38 'h|help' => \$want_help
46 print "*** Testing only, authorities will not be deleted. ***\n";
49 print "Restricted to authority type(s) : ".join(',', @authtypes).".\n";
52 my $searcher = Koha::SearchEngine::Search->new( { index => 'biblios' } );
54 if ( C4::Context->preference("SearchEngine") eq 'Zebra' ) {
56 my $errZebraConnection = C4::Context->Zconn("biblioserver",0)->errcode();
57 if ( $errZebraConnection == 10000 ) {
58 die "Zebra server seems not to be available. This script needs Zebra runs.";
59 } elsif ( $errZebraConnection ) {
60 die "Error from Zebra: $errZebraConnection";
62 $checksearch = q{an,alwaysmatches=''};
65 $checksearch = q{an:*};
67 # Check search on authority number as at least one result
68 my ($err,$res,$nb) = $searcher->simple_search_compat($checksearch,0,10);
70 die "Searching authority number in biblio records seems not to be available : $checksearch";
73 my $dbh=C4::Context->dbh;
75 # prepare the request to retrieve all authorities of the requested types
76 my $rqsql = q{ SELECT authid,authtypecode FROM auth_header };
77 $rqsql .= q{ WHERE authtypecode IN (}.join(',',map{ '?' }@authtypes).')' if @authtypes;
78 my $rqselect = $dbh->prepare($rqsql);
81 $rqselect->execute(@authtypes);
85 while (my $data=$rqselect->fetchrow_hashref){
87 print 'authid='.$data->{'authid'};
88 print ' type='.$data->{'authtypecode'};
89 my $bibliosearch = 'an:'.$data->{'authid'};
90 # search for biblios mapped
91 my ($err,$res,$used) = $searcher->simple_search_compat($bibliosearch,0,10);
94 warn "Error: $err on search for biblios $bibliosearch\n";
99 DelAuthority({ authid => $data->{'authid'} });
102 print " : can be deleted";
107 print " : used $used time(s)";
112 print "$counter authorities parsed\n";
114 print "$totdeleted deleted because unused\n";
116 print "$totdeleted can be deleted because unused\n";
118 print "$totundeleted unchanged because used\n";
122 $0: Remove unused authority records
124 This script removes authority records that do not have any biblio
125 records attached to them.
127 If the --aut option is supplied, only authority records of that
128 particular type will be checked for usage. --aut can be repeated.
130 If --aut is not supplied, all authority records will be checked.
132 Use --test to perform a test run. This script does not ask the
133 operator to confirm the deletion of each authority record.
136 --aut|authtypecode TYPE the list of authtypes to check
137 --test or -t test mode, don't delete really, just count
138 --help or -h show this message.