# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
#
-# You should have received a copy of the GNU General Public License along with
-# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
-# Suite 330, Boston, MA 02111-1307 USA
+# You should have received a copy of the GNU General Public License along
+# with Koha; if not, write to the Free Software Foundation, Inc.,
+# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
use strict;
use warnings;
use C4::AuthoritiesMarc;
use Getopt::Long;
-my ($test,@authtypes);
+my @authtypes;
my $want_help = 0;
+my $test = 0;
GetOptions(
- 'aut|authtypecode:s' => \@authtypes,
- 't' => \$test,
- 'h|help' => \$want_help
+ 'aut|authtypecode:s' => \@authtypes,
+ 't|test' => \$test,
+ 'h|help' => \$want_help
);
if ($want_help) {
exit 0;
}
+if ($test) {
+ print "testing only, authorities will not be deleted.\n";
+}
+
my $dbh=C4::Context->dbh;
-@authtypes or @authtypes = qw( NC );
my $thresholdmin=0;
my $thresholdmax=0;
my @results;
# prepare the request to retrieve all authorities of the requested types
-my $rqselect = $dbh->prepare(
- qq{SELECT * from auth_header where authtypecode IN (}
- . join(",",map{$dbh->quote($_)}@authtypes)
- . ")"
-);
+my $rqsql = "SELECT * from auth_header where 1";
+$rqsql .= " AND authtypecode IN (".join(",",map{$dbh->quote($_)}@authtypes).")" if @authtypes;
+my $rqselect = $dbh->prepare($rqsql);
$|=1;
$rqselect->execute;
$query= "an=".$data->{'authid'};
# search for biblios mapped
my ($err,$res,$used) = C4::Search::SimpleSearch($query,0,10);
+ if (defined $err) {
+ warn "error: $err on search $query\n";
+ next;
+ }
print ".";
print "$counter\n" unless $counter++ % 100;
# if found, delete, otherwise, just count
sub print_usage {
print <<_USAGE_;
-$0: Removes unused authorities.
+$0: Remove unused authority records
+
+This script removes authority records that do not have any biblio
+records attached to them.
+
+If the --aut option is supplied, only authority records of that
+particular type will be checked for usage. --aut can be repeated.
+
+If --aut is not supplied, all authority records will be checked.
+
+Use --test to perform a test run. This script does not ask the
+operator to confirm the deletion of each authority record.
-This script will parse all authoritiestypes given as parameter, and remove authorities without any biblio attached.
-warning : there is no individual confirmation !
parameters
--aut|authtypecode TYPE the list of authtypes to check
- --t|test test mode, don't delete really, just count
+ --test or -t test mode, don't delete really, just count
--help or -h show this message.
_USAGE_