3 #-----------------------------------
4 # Copyright 2013 ByWater Solutions
6 # This file is part of Koha.
8 # Koha is free software; you can redistribute it and/or modify it under the
9 # terms of the GNU General Public License as published by the Free Software
10 # Foundation; either version 3 of the License, or (at your option) any later
13 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
14 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
15 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License along
18 # with Koha; if not, write to the Free Software Foundation, Inc.,
19 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
20 #-----------------------------------
24 binmode( STDOUT, ":encoding(UTF-8)" );
28 # find Koha's Perl modules
29 # test carefully before changing this
31 eval { require "$FindBin::Bin/../kohalib.pl" };
47 'i|di|delete-items' => \$delete_items,
48 'c|confirm' => \$confirm,
50 'v|verbose' => \$verbose,
54 if ( $help || !$confirm ) {
56 delete_records_via_leader.pl - Attempt to delete any MARC records where the leader character 5 equals 'd'
57 usage: delete_records_via_leader.pl --confirm --verbose [--test]
58 This script has the following parameters :
59 -h --help: Prints this message
60 -c --confirm: Script will do nothing without this parameter
61 -v --verbose: Be verbose
62 -t --test: Test mode, does not delete records.
63 Test mode cannot determine if a record/item will be deleted successfully,
64 it will only tell you what records and items the script will attempt to delete.
65 -i --delete-items: Try deleting items before deleting record.
66 Records with items cannot be deleted.
71 my $schema = Koha::Database->new()->schema();
73 $schema->resultset('Biblioitem')->search( { marc => { LIKE => '_____d%' } } );
75 my $total_records_count = @biblioitems;
76 my $deleted_records_count = 0;
77 my $total_items_count = 0;
78 my $deleted_items_count = 0;
80 foreach my $biblioitem (@biblioitems) {
81 my $biblionumber = $biblioitem->get_column('biblionumber');
83 say "RECORD: $biblionumber" if $verbose;
86 my $deleted_count = 0;
87 foreach my $item ( $biblioitem->items() ) {
88 my $itemnumber = $item->itemnumber();
90 my $error = $test ? "Test mode enabled" : DelItemCheck( $biblionumber, $itemnumber );
91 $error = undef if $error eq '1';
94 say "ERROR DELETING ITEM $itemnumber: $error";
97 say "DELETED ITEM $itemnumber" if $verbose;
98 $deleted_items_count++;
101 $total_items_count++;
106 my $error = $test ? q{Test mode enabled} : DelBiblio($biblionumber);
108 say "ERROR DELETING BIBLIO $biblionumber: $error";
110 say "DELETED BIBLIO $biblionumber" if $verbose;
111 $deleted_records_count++;
118 say "DELETED $deleted_records_count OF $total_records_count RECORDS";
119 say "DELETED $deleted_items_count OF $total_items_count ITEMS" if $delete_items;