1 package WebPAC::Input::Koha;
8 use base qw/WebPAC::Common/;
10 use Data::Dump qw/dump/;
14 WebPAC::Input::Koha - read MARC records from Koha
18 our $VERSION = '0.02';
24 my $input = new WebPAC::Input::Koha(
25 dsn => 'dbi:mysql:database=koha',
26 user => $ENV{KOHA_USER},
27 passwd => $ENV{KOHA_PASSWD},
39 my $log = $self->_get_logger();
40 $log->debug( 'arg = ', dump($arg) );
42 if ( -e $arg->{path} ) {
43 $log->info("Koha marc dump ", $arg->{path}, " exists");
44 $self->{_koha_size} = 0;
47 $arg->{dsn} ||= 'dbi:mysql:database=koha';
48 $arg->{user} ||= $ENV{KOHA_USER};
49 $arg->{passwd} ||= $ENV{KOHA_PASSWD},
50 $arg->{sql} ||= 'select biblionumber as mfn, marc from biblioitems';
51 $arg->{sql} .= ' limit ' . $arg->{limit} if $arg->{limit};
52 $arg->{sql} .= ' offset ' . $arg->{offset} if $arg->{offset};
54 $log->info("opening Koha database '$arg->{dsn}'");
56 $self->{_dbh} = DBI->connect( $arg->{dsn}, $arg->{user}, $arg->{passwd}, { RaiseError => 1 } );
57 $self->{_sth} = $self->{_dbh}->prepare( $arg->{sql} );
58 $self->{_sth}->execute;
59 $self->{_koha_size} = $self->{_sth}->rows;
61 warn "got ", $self->{_koha_size}, " rows for ", $arg->{sql};
63 open( $self->{_koha_fh}, '>', $arg->{path} ) || die "can't create $arg->{path}: $!";
67 $self ? return $self : return undef;
72 Return record with ID C<$mfn> from database
74 my $rec = $input->fetch_rec( $mfn );
83 my $row = $self->{_sth}->fetchrow_hashref;
85 if ( my $fh = $self->{_koha_fh} ) {
86 if ( my $marc = $row->{marc} ) {
89 warn "MFN $mfn no marc in ",dump($row);
93 push @{$row->{'000'}}, $mfn;
99 Return number of records in database
101 my $size = $isis->size;
107 return $self->{_koha_size} + $self->{offset};
113 Dobrica Pavlinusic, C<< <dpavlin@rot13.org> >>
115 =head1 COPYRIGHT & LICENSE
117 Copyright 2009 Dobrica Pavlinusic, All Rights Reserved.
119 This program is free software; you can redistribute it and/or modify it
120 under the same terms as Perl itself.