1 package OpenILS::Application::Ingest;
2 use OpenILS::Application;
3 use base qw/OpenILS::Application/;
5 use Unicode::Normalize;
6 use OpenSRF::EX qw/:try/;
8 use OpenSRF::AppSession;
9 use OpenSRF::Utils::SettingsClient;
10 use OpenSRF::Utils::Logger qw/:level/;
12 use OpenILS::Application::AppUtils;
13 use OpenILS::Utils::ScriptRunner;
14 use OpenILS::Utils::Fieldmapper;
15 use OpenSRF::Utils::JSON;
17 use OpenILS::Utils::Fieldmapper;
21 use Time::HiRes qw(time);
23 our %supported_formats = (
24 mods33 => {ns => 'http://www.loc.gov/mods/v3'},
25 mods32 => {ns => 'http://www.loc.gov/mods/v3'},
26 mods3 => {ns => 'http://www.loc.gov/mods/v3'},
27 mods => {ns => 'http://www.loc.gov/mods/'},
28 marcxml => {ns => 'http://www.loc.gov/MARC21/slim'},
29 srw_dc => {ns => 'info:srw/schema/1/dc-schema'},
30 oai_dc => {ns => 'http://www.openarchives.org/OAI/2.0/oai_dc/'},
31 rdf_dc => {ns => 'http://www.w3.org/1999/02/22-rdf-syntax-ns#'},
32 atom => {ns => 'http://www.w3.org/2005/Atom'},
33 rss091 => {ns => 'http://my.netscape.com/rdf/simple/0.9/'},
37 rss10 => {ns => 'http://purl.org/rss/1.0/'},
38 rss11 => {ns => 'http://purl.org/net/rss1.1#'},
43 my $log = 'OpenSRF::Utils::Logger';
45 my $parser = XML::LibXML->new();
46 my $xslt = XML::LibXSLT->new();
56 unless (keys %$xpathset) {
57 $log->debug("Running post_init", DEBUG);
59 my $xsldir = OpenSRF::Utils::SettingsClient->new->config_value(dirs => 'xsl');
61 unless ($supported_formats{mods}{xslt}) {
62 $log->debug("Loading MODS XSLT", DEBUG);
63 my $xslt_doc = $parser->parse_file( $xsldir . "/MARC21slim2MODS.xsl");
64 $supported_formats{mods}{xslt} = $xslt->parse_stylesheet( $xslt_doc );
67 unless ($supported_formats{mods3}{xslt}) {
68 $log->debug("Loading MODS v3 XSLT", DEBUG);
69 my $xslt_doc = $parser->parse_file( $xsldir . "/MARC21slim2MODS3.xsl");
70 $supported_formats{mods3}{xslt} = $xslt->parse_stylesheet( $xslt_doc );
73 unless ($supported_formats{mods32}{xslt}) {
74 $log->debug("Loading MODS v32 XSLT", DEBUG);
75 my $xslt_doc = $parser->parse_file( $xsldir . "/MARC21slim2MODS32.xsl");
76 $supported_formats{mods32}{xslt} = $xslt->parse_stylesheet( $xslt_doc );
79 unless ($supported_formats{mods33}{xslt}) {
80 $log->debug("Loading MODS v33 XSLT", DEBUG);
81 my $xslt_doc = $parser->parse_file( $xsldir . "/MARC21slim2MODS33.xsl");
82 $supported_formats{mods33}{xslt} = $xslt->parse_stylesheet( $xslt_doc );
85 my $req = OpenSRF::AppSession
86 ->create('open-ils.cstore')
88 # XXX testing new metabib field use for faceting
89 #->request( 'open-ils.cstore.direct.config.metabib_field.search.atomic', { id => { '!=' => undef } } )
90 ->request( 'open-ils.cstore.direct.config.metabib_field.search.atomic', { search_field => 't' } )
94 if (ref $req and @$req) {
96 $xpathset->{ $f->field_class }->{ $f->name }->{xpath} = $f->xpath;
97 $xpathset->{ $f->field_class }->{ $f->name }->{id} = $f->id;
98 $xpathset->{ $f->field_class }->{ $f->name }->{format} = $f->format;
99 $log->debug("Loaded XPath from DB: ".$f->field_class." => ".$f->name." : ".$f->xpath, DEBUG);
105 # --------------------------------------------------------------------------------
108 package OpenILS::Application::Ingest::Biblio;
109 use base qw/OpenILS::Application::Ingest/;
110 use Unicode::Normalize;
112 sub rw_biblio_ingest_single_object {
117 my ($blob) = $self->method_lookup("open-ils.ingest.full.biblio.object.readonly")->run($bib);
118 return undef unless ($blob);
120 $bib->fingerprint( $blob->{fingerprint}->{fingerprint} );
121 $bib->quality( $blob->{fingerprint}->{quality} );
123 my $cstore = OpenSRF::AppSession->connect('open-ils.cstore');
125 my $xact = $cstore->request('open-ils.cstore.transaction.begin')->gather(1);
128 # update uri stuff ...
130 # gather URI call numbers for this record
131 my $uri_cns = $u->{call_number} = $cstore->request(
132 'open-ils.cstore.direct.asset.call_number.id_list.atomic' => { record => $bib->id, label => '##URI##' }
136 # gather the maps for those call numbers
137 my $uri_maps = $u->{call_number} = $cstore->request(
138 'open-ils.cstore.direct.asset.uri_call_number_map.id_list.atomic' => { call_number => $uri_cns }
141 # delete the old maps
142 $cstore->request( 'open-ils.cstore.direct.asset.uri_call_number_map.delete' => $_ )->gather(1) for (@$uri_maps);
144 # and delete the call numbers if there are no more URIs
145 if (!@{ $blob->{uri} }) {
146 $cstore->request( 'open-ils.cstore.direct.asset.call_number.delete' => $_ )->gather(1) for (@$uri_cns);
150 # now, add CNs, URIs and maps
151 my %new_cns_by_owner;
152 my %new_uris_by_owner;
153 for my $u ( @{ $blob->{uri} } ) {
155 my $owner = $u->{call_number}->owning_lib;
157 if ($u->{call_number}->isnew) {
158 if ($new_cns_by_owner{$owner}) {
159 $u->{call_number} = $new_cns_by_owner{$owner};
161 $u->{call_number}->clear_id;
162 $u->{call_number} = $new_cns_by_owner{$owner} = $cstore->request(
163 'open-ils.cstore.direct.asset.call_number.create' => $u->{call_number}
168 if ($u->{uri}->isnew) {
169 if ($new_uris_by_owner{$owner}) {
170 $u->{uri} = $new_uris_by_owner{$owner};
172 $u->{uri} = $new_uris_by_owner{$owner} = $cstore->request(
173 'open-ils.cstore.direct.asset.uri.create' => $u->{uri}
178 # Check for an existing CN-URI map
179 $tmp = $cstore->request(
180 'open-ils.cstore.direct.asset.uri_call_number_map.id_list',
181 { call_number => $u->{call_number}->id, uri => $u->{uri}->id }
186 my $umap = Fieldmapper::asset::uri_call_number_map->new;
187 $umap->uri($u->{uri}->id);
188 $umap->call_number($u->{call_number}->id);
190 $cstore->request( 'open-ils.cstore.direct.asset.uri_call_number_map.create' => $umap )->gather(1);
193 # update full_rec stuff ...
194 $tmp = $cstore->request(
195 'open-ils.cstore.direct.metabib.full_rec.id_list.atomic',
196 { record => $bib->id }
199 $cstore->request( 'open-ils.cstore.direct.metabib.full_rec.delete' => $_ )->gather(1) for (@$tmp);
200 $cstore->request( 'open-ils.cstore.direct.metabib.full_rec.create' => $_ )->gather(1) for (@{ $blob->{full_rec} });
202 # update rec_descriptor stuff ...
203 $tmp = $cstore->request(
204 'open-ils.cstore.direct.metabib.record_descriptor.id_list.atomic',
205 { record => $bib->id }
208 $cstore->request( 'open-ils.cstore.direct.metabib.record_descriptor.delete' => $_ )->gather(1) for (@$tmp);
209 $cstore->request( 'open-ils.cstore.direct.metabib.record_descriptor.create' => $blob->{descriptor} )->gather(1);
211 # deal with classed fields...
212 for my $class ( qw/title author subject keyword series/ ) {
213 $tmp = $cstore->request(
214 "open-ils.cstore.direct.metabib.${class}_field_entry.id_list.atomic",
215 { source => $bib->id }
218 $cstore->request( "open-ils.cstore.direct.metabib.${class}_field_entry.delete" => $_ )->gather(1) for (@$tmp);
220 for my $obj ( @{ $blob->{field_entries} } ) {
221 my $class = $obj->class_name;
222 $class =~ s/^Fieldmapper:://o;
224 $cstore->request( "open-ils.cstore.direct.$class.create" => $obj )->gather(1);
229 $tmp = $cstore->request(
230 'open-ils.cstore.direct.metabib.metarecord_source_map.search.atomic',
231 { source => $bib->id }
234 $cstore->request( 'open-ils.cstore.direct.metabib.metarecord_source_map.delete' => $_->id )->gather(1) for (@$tmp);
237 my $old_mrs = $cstore->request(
238 'open-ils.cstore.direct.metabib.metarecord.search.atomic' => { id => [map { $_->metarecord } @$tmp] }
239 )->gather(1) if (@$tmp);
241 $old_mrs = [] if (!ref($old_mrs));
244 for my $m (@$old_mrs) {
245 if ($m->fingerprint eq $bib->fingerprint) {
248 my $others = $cstore->request(
249 'open-ils.cstore.direct.metabib.metarecord_source_map.id_list.atomic' => { metarecord => $m->id }
254 'open-ils.cstore.direct.metabib.metarecord.delete' => $m->id
264 # Get the matchin MR, if any.
265 $mr = $cstore->request(
266 'open-ils.cstore.direct.metabib.metarecord.search',
267 { fingerprint => $bib->fingerprint }
270 $holds = $cstore->request(
271 'open-ils.cstore.direct.action.hold_request.search.atomic',
272 { hold_type => 'M', target => [ map { $_->id } grep { $_->isdeleted } @$old_mrs ] }
273 )->gather(1) if (@$old_mrs);
276 for my $h (@$holds) {
278 $cstore->request( 'open-ils.cstore.direct.action.hold_request.update' => $h )->gather(1);
285 $mr = new Fieldmapper::metabib::metarecord;
286 $mr->fingerprint( $bib->fingerprint );
287 $mr->master_record( $bib->id );
290 "open-ils.cstore.direct.metabib.metarecord.create",
291 $mr => { quiet => 'true' }
295 for my $h (grep { !$_->ischanged } @$holds) {
297 $cstore->request( 'open-ils.cstore.direct.action.hold_request.update' => $h )->gather(1);
300 my $mrm = $cstore->request(
301 'open-ils.cstore.direct.metabib.metarecord_source_map.search.atomic',
302 { metarecord => $mr->id }
306 my $best = $cstore->request(
307 "open-ils.cstore.direct.biblio.record_entry.search",
308 { id => [ map { $_->source } @$mrm ] },
309 { 'select' => { bre => [ qw/id quality/ ] },
310 order_by => { bre => "quality desc" },
315 if ($best->quality > $bib->quality) {
316 $mr->master_record($best->id);
318 $mr->master_record($bib->id);
321 $mr->master_record($bib->id);
326 $cstore->request( 'open-ils.cstore.direct.metabib.metarecord.update' => $mr )->gather(1);
329 my $mrm = new Fieldmapper::metabib::metarecord_source_map;
330 $mrm->source($bib->id);
331 $mrm->metarecord($mr->id);
333 $cstore->request( 'open-ils.cstore.direct.metabib.metarecord_source_map.create' => $mrm )->gather(1);
334 $cstore->request( 'open-ils.cstore.direct.biblio.record_entry.update' => $bib )->gather(1);
336 $cstore->request( 'open-ils.cstore.json_query.atomic' => { from => [ 'reporter.simple_rec_update', $bib->id ] } )->gather(1);
338 $cstore->request( 'open-ils.cstore.transaction.commit' )->gather(1) || return undef;;
343 __PACKAGE__->register_method(
344 api_name => "open-ils.ingest.full.biblio.object",
345 method => "rw_biblio_ingest_single_object",
350 sub rw_biblio_ingest_single_record {
355 OpenILS::Application::Ingest->post_init();
356 my $cstore = OpenSRF::AppSession->connect( 'open-ils.cstore' );
357 $cstore->request('open-ils.cstore.transaction.begin')->gather(1);
359 my $r = $cstore->request( 'open-ils.cstore.direct.biblio.record_entry.retrieve' => $rec )->gather(1);
361 $cstore->request('open-ils.cstore.transaction.rollback')->gather(1);
364 return undef unless ($r and @$r);
366 return ($self->method_lookup("open-ils.ingest.full.biblio.object")->run($r))[0];
368 __PACKAGE__->register_method(
369 api_name => "open-ils.ingest.full.biblio.record",
370 method => "rw_biblio_ingest_single_record",
375 sub rw_biblio_ingest_record_list {
378 my @rec = ref($_[0]) ? @{ $_[0] } : @_ ;
380 OpenILS::Application::Ingest->post_init();
381 my $cstore = OpenSRF::AppSession->connect( 'open-ils.cstore' );
382 $cstore->request('open-ils.cstore.transaction.begin')->gather(1);
384 my $r = $cstore->request( 'open-ils.cstore.direct.biblio.record_entry.search.atomic' => { id => \@rec } )->gather(1);
386 $cstore->request('open-ils.cstore.transaction.rollback')->gather(1);
389 return undef unless ($r and @$r);
393 if (($self->method_lookup("open-ils.ingest.full.biblio.object")->run($_))[0]) {
399 __PACKAGE__->register_method(
400 api_name => "open-ils.ingest.full.biblio.record_list",
401 method => "rw_biblio_ingest_record_list",
406 sub ro_biblio_ingest_single_object {
410 my $xml = OpenILS::Application::AppUtils->entityize($bib->marc);
414 my $cstore = OpenSRF::AppSession->connect( 'open-ils.cstore' );
417 my $cn = $cstore->request( 'open-ils.cstore.direct.asset.call_number.search' => { id => { '!=' => undef } }, { limit => 1, order_by => { acn => 'id desc' } } )->gather(1);
418 $max_cn = int($cn->id) + 1000;
422 my $cn = $cstore->request( 'open-ils.cstore.direct.asset.call_number.search' => { id => { '!=' => undef } }, { limit => 1, order_by => { acn => 'id desc' } } )->gather(1);
423 $max_uri = int($cn->id) + 1000;
428 my $document = $parser->parse_string($xml);
430 my @uris = $self->method_lookup("open-ils.ingest.856_uri.object")->run($bib, $max_cn, $max_uri);
431 my @mfr = $self->method_lookup("open-ils.ingest.flat_marc.biblio.xml")->run($document);
432 my @mXfe = $self->method_lookup("open-ils.ingest.extract.field_entry.all.xml")->run($document);
433 my ($fp) = $self->method_lookup("open-ils.ingest.fingerprint.xml")->run($xml);
434 my ($rd) = $self->method_lookup("open-ils.ingest.descriptor.xml")->run($xml);
436 $_->source($bib->id) for (@mXfe);
437 $_->record($bib->id) for (@mfr);
438 $rd->record($bib->id) if ($rd);
440 return { full_rec => \@mfr, field_entries => \@mXfe, fingerprint => $fp, descriptor => $rd, uri => \@uris };
442 __PACKAGE__->register_method(
443 api_name => "open-ils.ingest.full.biblio.object.readonly",
444 method => "ro_biblio_ingest_single_object",
449 sub ro_biblio_ingest_single_xml {
452 my $xml = OpenILS::Application::AppUtils->entityize(shift);
454 my $document = $parser->parse_string($xml);
456 my @mfr = $self->method_lookup("open-ils.ingest.flat_marc.biblio.xml")->run($document);
457 my @mXfe = $self->method_lookup("open-ils.ingest.extract.field_entry.all.xml")->run($document);
458 my ($fp) = $self->method_lookup("open-ils.ingest.fingerprint.xml")->run($xml);
459 my ($rd) = $self->method_lookup("open-ils.ingest.descriptor.xml")->run($xml);
461 return { full_rec => \@mfr, field_entries => \@mXfe, fingerprint => $fp, descriptor => $rd };
463 __PACKAGE__->register_method(
464 api_name => "open-ils.ingest.full.biblio.xml.readonly",
465 method => "ro_biblio_ingest_single_xml",
470 sub ro_biblio_ingest_single_record {
475 OpenILS::Application::Ingest->post_init();
476 my $r = OpenSRF::AppSession
477 ->create('open-ils.cstore')
478 ->request( 'open-ils.cstore.direct.biblio.record_entry.retrieve' => $rec )
481 return undef unless ($r and @$r);
483 my ($res) = $self->method_lookup("open-ils.ingest.full.biblio.xml.readonly")->run($r->marc);
485 $_->source($rec) for (@{$res->{field_entries}});
486 $_->record($rec) for (@{$res->{full_rec}});
487 $res->{descriptor}->record($rec);
491 __PACKAGE__->register_method(
492 api_name => "open-ils.ingest.full.biblio.record.readonly",
493 method => "ro_biblio_ingest_single_record",
498 sub ro_biblio_ingest_stream_record {
502 OpenILS::Application::Ingest->post_init();
504 my $ses = OpenSRF::AppSession->create('open-ils.cstore');
506 while (my ($resp) = $client->recv( count => 1, timeout => 5 )) {
508 my $rec = $resp->content;
509 last unless (defined $rec);
511 $log->debug("Running open-ils.ingest.full.biblio.record.readonly ...");
512 my ($res) = $self->method_lookup("open-ils.ingest.full.biblio.record.readonly")->run($rec);
514 $_->source($rec) for (@{$res->{field_entries}});
515 $_->record($rec) for (@{$res->{full_rec}});
517 $client->respond( $res );
522 __PACKAGE__->register_method(
523 api_name => "open-ils.ingest.full.biblio.record_stream.readonly",
524 method => "ro_biblio_ingest_stream_record",
529 sub ro_biblio_ingest_stream_xml {
533 OpenILS::Application::Ingest->post_init();
535 my $ses = OpenSRF::AppSession->create('open-ils.cstore');
537 while (my ($resp) = $client->recv( count => 1, timeout => 5 )) {
539 my $xml = $resp->content;
540 last unless (defined $xml);
542 $log->debug("Running open-ils.ingest.full.biblio.xml.readonly ...");
543 my ($res) = $self->method_lookup("open-ils.ingest.full.biblio.xml.readonly")->run($xml);
545 $client->respond( $res );
550 __PACKAGE__->register_method(
551 api_name => "open-ils.ingest.full.biblio.xml_stream.readonly",
552 method => "ro_biblio_ingest_stream_xml",
557 sub rw_biblio_ingest_stream_import {
561 OpenILS::Application::Ingest->post_init();
563 my $ses = OpenSRF::AppSession->create('open-ils.cstore');
565 while (my ($resp) = $client->recv( count => 1, timeout => 5 )) {
567 my $bib = $resp->content;
568 last unless (defined $bib);
570 $log->debug("Running open-ils.ingest.full.biblio.xml.readonly ...");
571 my ($res) = $self->method_lookup("open-ils.ingest.full.biblio.xml.readonly")->run($bib->marc);
573 $_->source($bib->id) for (@{$res->{field_entries}});
574 $_->record($bib->id) for (@{$res->{full_rec}});
576 $client->respond( $res );
581 __PACKAGE__->register_method(
582 api_name => "open-ils.ingest.full.biblio.bib_stream.import",
583 method => "rw_biblio_ingest_stream_import",
589 # --------------------------------------------------------------------------------
592 package OpenILS::Application::Ingest::Authority;
593 use base qw/OpenILS::Application::Ingest/;
594 use Unicode::Normalize;
596 sub rw_authority_ingest_single_object {
601 my ($blob) = $self->method_lookup("open-ils.ingest.full.authority.object.readonly")->run($auth);
602 return undef unless ($blob);
604 my $cstore = OpenSRF::AppSession->connect('open-ils.cstore');
606 my $xact = $cstore->request('open-ils.cstore.transaction.begin')->gather(1);
609 # update full_rec stuff ...
610 $tmp = $cstore->request(
611 'open-ils.cstore.direct.authority.full_rec.id_list.atomic',
612 { record => $auth->id }
615 $cstore->request( 'open-ils.cstore.direct.authority.full_rec.delete' => $_ )->gather(1) for (@$tmp);
616 $cstore->request( 'open-ils.cstore.direct.authority.full_rec.create' => $_ )->gather(1) for (@{ $blob->{full_rec} });
618 # XXX when we start extracting authority descriptors and adding sources ...
620 # update rec_descriptor stuff ...
621 #$tmp = $cstore->request(
622 # 'open-ils.cstore.direct.authority.record_descriptor.id_list.atomic',
623 # { record => $auth->id }
626 #$cstore->request( 'open-ils.cstore.direct.authority.record_descriptor.delete' => $_ )->gather(1) for (@$tmp);
627 #$cstore->request( 'open-ils.cstore.direct.authority.record_descriptor.create' => $blob->{descriptor} )->gather(1);
628 #$cstore->request( 'open-ils.cstore.direct.authority.record_entry.update' => $auth )->gather(1);
630 $cstore->request( 'open-ils.cstore.transaction.commit' )->gather(1) || return undef;;
635 __PACKAGE__->register_method(
636 api_name => "open-ils.ingest.full.authority.object",
637 method => "rw_authority_ingest_single_object",
642 sub rw_authority_ingest_single_record {
647 OpenILS::Application::Ingest->post_init();
648 my $cstore = OpenSRF::AppSession->connect( 'open-ils.cstore' );
649 $cstore->request('open-ils.cstore.transaction.begin')->gather(1);
651 my $r = $cstore->request( 'open-ils.cstore.direct.authority.record_entry.retrieve' => $rec )->gather(1);
653 $cstore->request('open-ils.cstore.transaction.rollback')->gather(1);
656 return undef unless ($r and @$r);
658 return ($self->method_lookup("open-ils.ingest.full.authority.object")->run($r))[0];
660 __PACKAGE__->register_method(
661 api_name => "open-ils.ingest.full.authority.record",
662 method => "rw_authority_ingest_single_record",
667 sub ro_authority_ingest_single_object {
671 my $xml = OpenILS::Application::AppUtils->entityize($bib->marc);
673 my $document = $parser->parse_string($xml);
675 my @mfr = $self->method_lookup("open-ils.ingest.flat_marc.authority.xml")->run($document);
677 $_->record($bib->id) for (@mfr);
679 return { full_rec => \@mfr };
681 __PACKAGE__->register_method(
682 api_name => "open-ils.ingest.full.authority.object.readonly",
683 method => "ro_authority_ingest_single_object",
688 sub ro_authority_ingest_single_xml {
691 my $xml = OpenILS::Application::AppUtils->entityize(shift);
693 my $document = $parser->parse_string($xml);
695 my @mfr = $self->method_lookup("open-ils.ingest.flat_marc.authority.xml")->run($document);
697 return { full_rec => \@mfr };
699 __PACKAGE__->register_method(
700 api_name => "open-ils.ingest.full.authority.xml.readonly",
701 method => "ro_authority_ingest_single_xml",
706 sub ro_authority_ingest_single_record {
711 OpenILS::Application::Ingest->post_init();
712 my $r = OpenSRF::AppSession
713 ->create('open-ils.cstore')
714 ->request( 'open-ils.cstore.direct.authority.record_entry.retrieve' => $rec )
717 return undef unless ($r and @$r);
719 my ($res) = $self->method_lookup("open-ils.ingest.full.authority.xml.readonly")->run($r->marc);
721 $_->record($rec) for (@{$res->{full_rec}});
722 $res->{descriptor}->record($rec);
726 __PACKAGE__->register_method(
727 api_name => "open-ils.ingest.full.authority.record.readonly",
728 method => "ro_authority_ingest_single_record",
733 sub ro_authority_ingest_stream_record {
737 OpenILS::Application::Ingest->post_init();
739 my $ses = OpenSRF::AppSession->create('open-ils.cstore');
741 while (my ($resp) = $client->recv( count => 1, timeout => 5 )) {
743 my $rec = $resp->content;
744 last unless (defined $rec);
746 $log->debug("Running open-ils.ingest.full.authority.record.readonly ...");
747 my ($res) = $self->method_lookup("open-ils.ingest.full.authority.record.readonly")->run($rec);
749 $_->record($rec) for (@{$res->{full_rec}});
751 $client->respond( $res );
756 __PACKAGE__->register_method(
757 api_name => "open-ils.ingest.full.authority.record_stream.readonly",
758 method => "ro_authority_ingest_stream_record",
763 sub ro_authority_ingest_stream_xml {
767 OpenILS::Application::Ingest->post_init();
769 my $ses = OpenSRF::AppSession->create('open-ils.cstore');
771 while (my ($resp) = $client->recv( count => 1, timeout => 5 )) {
773 my $xml = $resp->content;
774 last unless (defined $xml);
776 $log->debug("Running open-ils.ingest.full.authority.xml.readonly ...");
777 my ($res) = $self->method_lookup("open-ils.ingest.full.authority.xml.readonly")->run($xml);
779 $client->respond( $res );
784 __PACKAGE__->register_method(
785 api_name => "open-ils.ingest.full.authority.xml_stream.readonly",
786 method => "ro_authority_ingest_stream_xml",
791 sub rw_authority_ingest_stream_import {
795 OpenILS::Application::Ingest->post_init();
797 my $ses = OpenSRF::AppSession->create('open-ils.cstore');
799 while (my ($resp) = $client->recv( count => 1, timeout => 5 )) {
801 my $bib = $resp->content;
802 last unless (defined $bib);
804 $log->debug("Running open-ils.ingest.full.authority.xml.readonly ...");
805 my ($res) = $self->method_lookup("open-ils.ingest.full.authority.xml.readonly")->run($bib->marc);
807 $_->record($bib->id) for (@{$res->{full_rec}});
809 $client->respond( $res );
814 __PACKAGE__->register_method(
815 api_name => "open-ils.ingest.full.authority.bib_stream.import",
816 method => "rw_authority_ingest_stream_import",
821 # --------------------------------------------------------------------------------
822 # MARC index extraction
824 package OpenILS::Application::Ingest::XPATH;
825 use base qw/OpenILS::Application::Ingest/;
826 use Unicode::Normalize;
828 # give this an XML documentElement and an XPATH expression
829 sub xpath_to_string {
833 my $ns_prefix = shift;
836 $xml->setNamespace( $ns_uri, $ns_prefix, 1 ) if ($ns_uri && $ns_prefix);
840 # grab the set of matching nodes
841 my @nodes = $xml->findnodes( $xpath );
842 for my $value (@nodes) {
844 # grab all children of the node
845 my @children = $value->childNodes();
846 for my $child (@children) {
848 # add the childs content to the growing buffer
849 my $content = quotemeta($child->textContent);
850 next if ($unique && $string =~ /$content/); # uniquify the values
851 $string .= $child->textContent . " ";
854 $string .= $value->textContent . " ";
858 $string =~ s/(\w+)\/(\w+)/$1 $2/sgo;
859 # Split date ranges and ISSNs on the hyphen
860 $string =~ s/(\d{4})-(\d{3,4}x?)/ $1 $2 /goi;
865 sub class_index_string_xml {
871 OpenILS::Application::Ingest->post_init();
872 $xml = $parser->parse_string(OpenILS::Application::AppUtils->entityize($xml)) unless (ref $xml);
876 for my $class (@classes) {
877 my $class_constructor = "Fieldmapper::metabib::${class}_field_entry";
878 for my $type ( keys %{ $xpathset->{$class} } ) {
880 my $def = $xpathset->{$class}->{$type};
881 my $sf = $OpenILS::Application::Ingest::supported_formats{$def->{format}};
886 $document = $transform_cache{$def->{format}} || $sf->{xslt}->transform($xml);
887 $transform_cache{$def->{format}} = $document;
890 my $value = xpath_to_string(
891 $document->documentElement => $def->{xpath},
892 $sf->{ns} => $def->{format},
898 $value = NFD($value);
899 $value =~ s/\pM+//sgo;
900 $value =~ s/\pC+//sgo;
901 $value =~ s/\W+$//sgo;
903 $value =~ s/\b\.+\b//sgo;
906 my $fm = $class_constructor->new;
907 $fm->value( $value );
908 $fm->field( $xpathset->{$class}->{$type}->{id} );
909 $client->respond($fm);
914 __PACKAGE__->register_method(
915 api_name => "open-ils.ingest.field_entry.class.xml",
916 method => "class_index_string_xml",
922 sub class_index_string_record {
928 OpenILS::Application::Ingest->post_init();
929 my $r = OpenSRF::AppSession
930 ->create('open-ils.cstore')
931 ->request( 'open-ils.cstore.direct.authority.record_entry.retrieve' => $rec )
934 return undef unless ($r and @$r);
936 for my $fm ($self->method_lookup("open-ils.ingest.field_entry.class.xml")->run($r->marc, @classes)) {
938 $client->respond($fm);
942 __PACKAGE__->register_method(
943 api_name => "open-ils.ingest.field_entry.class.record",
944 method => "class_index_string_record",
950 sub all_index_string_xml {
955 for my $fm ($self->method_lookup("open-ils.ingest.field_entry.class.xml")->run($xml, keys(%$xpathset))) {
956 $client->respond($fm);
960 __PACKAGE__->register_method(
961 api_name => "open-ils.ingest.extract.field_entry.all.xml",
962 method => "all_index_string_xml",
968 sub all_index_string_record {
973 OpenILS::Application::Ingest->post_init();
974 my $r = OpenSRF::AppSession
975 ->create('open-ils.cstore')
976 ->request( 'open-ils.cstore.direct.biblio.record_entry.retrieve' => $rec )
979 return undef unless ($r and @$r);
981 for my $fm ($self->method_lookup("open-ils.ingest.field_entry.class.xml")->run($r->marc, keys(%$xpathset))) {
983 $client->respond($fm);
987 __PACKAGE__->register_method(
988 api_name => "open-ils.ingest.extract.field_entry.all.record",
989 method => "all_index_string_record",
995 # --------------------------------------------------------------------------------
998 package OpenILS::Application::Ingest::FlatMARC;
999 use base qw/OpenILS::Application::Ingest/;
1000 use Unicode::Normalize;
1003 sub _marcxml_to_full_rows {
1005 my $marcxml = shift;
1006 my $xmltype = shift || 'metabib';
1008 my $type = "Fieldmapper::${xmltype}::full_rec";
1012 my ($root) = $marcxml->findnodes('//*[local-name()="record"]');
1014 for my $tagline ( @{$root->getChildrenByTagName("leader")} ) {
1015 next unless $tagline;
1016 _special_tag_to_full_rows($type, $tagline, \@ns_list, 'LDR');
1019 for my $tagline ( @{$root->getChildrenByTagName("controlfield")} ) {
1020 next unless $tagline;
1021 _special_tag_to_full_rows($type, $tagline, \@ns_list, $tagline->getAttribute( "tag" ));
1024 for my $tagline ( @{$root->getChildrenByTagName("datafield")} ) {
1025 next unless $tagline;
1026 _data_tag_to_full_rows($type, $tagline, \@ns_list, $tagline->getAttribute( "tag" ));
1028 if ($xmltype eq 'metabib' and $tag eq '245') {
1029 _data_tag_to_full_rows($type, $tagline, \@ns_list, 'tnf');
1033 $log->debug("Returning ".scalar(@ns_list)." Fieldmapper nodes from $xmltype xml");
1037 =head2 _special_tag_to_full_rows
1039 Converts a leader or control field to a set of normalized values
1043 sub _special_tag_to_full_rows {
1045 my $tagline = shift;
1046 my $ns_list = shift;
1047 my $tagname = shift;
1049 my $ns = $type->new;
1051 $ns->tag( $tagname );
1052 my $val = $tagline->textContent;
1054 $val =~ s/\pM+//sgo;
1055 $val =~ s/\pC+//sgo;
1056 $val =~ s/\W+$//sgo;
1059 push @$ns_list, $ns;
1062 =head2 _data_tag_to_full_rows
1064 Converts a data field to a set of normalized values
1068 sub _data_tag_to_full_rows {
1070 my $tagline = shift;
1071 my $ns_list = shift;
1074 my $ind1 = $tagline->getAttribute( "ind1" );
1075 my $ind2 = $tagline->getAttribute( "ind2" );
1077 for my $data ( @{$tagline->getChildrenByTagName('subfield')} ) {
1080 my $ns = $type->new;
1085 $ns->subfield( $data->getAttribute( "code" ) );
1086 my $val = $data->textContent;
1088 $val =~ s/\pM+//sgo;
1089 $val =~ s/\pC+//sgo;
1090 $val =~ s/\W+$//sgo;
1091 # Split date ranges and ISSNs on the hyphen
1092 $val =~ s/(\d{4})-(\d{3,4}x?)/ $1 $2 /goi;
1093 $val =~ s/(\w+)\/(\w+)/$1 $2/sgo;
1094 $ns->value( lc($val) );
1096 push @$ns_list, $ns;
1105 $log->debug("processing [$xml]");
1107 $xml = $parser->parse_string(OpenILS::Application::AppUtils->entityize($xml)) unless (ref $xml);
1109 my $type = 'metabib';
1110 $type = 'authority' if ($self->api_name =~ /authority/o);
1112 OpenILS::Application::Ingest->post_init();
1114 $client->respond($_) for (_marcxml_to_full_rows($xml, $type));
1117 __PACKAGE__->register_method(
1118 api_name => "open-ils.ingest.flat_marc.authority.xml",
1119 method => "flat_marc_xml",
1124 __PACKAGE__->register_method(
1125 api_name => "open-ils.ingest.flat_marc.biblio.xml",
1126 method => "flat_marc_xml",
1132 sub flat_marc_record {
1137 my $type = 'biblio';
1138 $type = 'authority' if ($self->api_name =~ /authority/o);
1140 OpenILS::Application::Ingest->post_init();
1141 my $r = OpenSRF::AppSession
1142 ->create('open-ils.cstore')
1143 ->request( "open-ils.cstore.direct.${type}.record_entry.retrieve" => $rec )
1147 return undef unless ($r and $r->marc);
1149 my @rows = $self->method_lookup("open-ils.ingest.flat_marc.$type.xml")->run($r->marc);
1150 for my $row (@rows) {
1151 $client->respond($row);
1152 $log->debug(OpenSRF::Utils::JSON->perl2JSON($row), DEBUG);
1156 __PACKAGE__->register_method(
1157 api_name => "open-ils.ingest.flat_marc.biblio.record_entry",
1158 method => "flat_marc_record",
1163 __PACKAGE__->register_method(
1164 api_name => "open-ils.ingest.flat_marc.authority.record_entry",
1165 method => "flat_marc_record",
1171 # --------------------------------------------------------------------------------
1174 package OpenILS::Application::Ingest::Biblio::URI;
1175 use base qw/OpenILS::Application::Ingest/;
1176 use Unicode::Normalize;
1177 use OpenSRF::EX qw/:try/;
1180 sub _extract_856_uris {
1184 my $max_uri = shift;
1187 my $recid = $rec->id;
1188 my $marcxml = $rec->marc;
1190 my $document = $parser->parse_string($marcxml);
1191 my @nodes = $document->findnodes('//*[local-name()="datafield" and @tag="856" and (@ind1="4" or @ind1="1") and (@ind2="0" or @ind2="1")]');
1193 my $cstore = OpenSRF::AppSession->connect('open-ils.cstore');
1197 for my $node (@nodes) {
1198 # first, is there a URI?
1199 my $href = $node->findvalue('*[local-name()="subfield" and @code="u"]/text()');
1200 next unless ($href);
1202 # now, find the best possible label
1203 my $label = $node->findvalue('*[local-name()="subfield" and @code="y"]/text()');
1204 $label ||= $node->findvalue('*[local-name()="subfield" and @code="3"]/text()');
1208 my $use = $node->findvalue('*[local-name()="subfield" and @code="z"]/text()');
1209 $use ||= $node->findvalue('*[local-name()="subfield" and @code="2"]/text()');
1210 $use ||= $node->findvalue('*[local-name()="subfield" and @code="n"]/text()');
1212 # moving on to the URI owner
1213 my $owner = $node->findvalue('*[local-name()="subfield" and @code="9"]/text()'); # Evergreen special sauce
1214 $owner ||= $node->findvalue('*[local-name()="subfield" and @code="w"]/text()');
1215 $owner ||= $node->findvalue('*[local-name()="subfield" and @code="n"]/text()');
1217 $owner =~ s/^.*?\((\w+)\).*$/$1/o; # unwrap first paren-enclosed string and then ...
1219 # no owner? skip it :(
1220 next unless ($owner);
1223 ->request( 'open-ils.cstore.direct.actor.org_unit.search' => { shortname => $owner} )
1228 # now we can construct the uri object
1230 ->request( 'open-ils.cstore.direct.asset.uri.search' => { label => $label, href => $href, use_restriction => $use, active => 't' } )
1234 $uri = Fieldmapper::asset::uri->new;
1236 $uri->id( $$max_uri++ );
1237 $uri->label($label);
1240 $uri->use_restriction($use);
1243 # see if we need to create a call number
1244 my $cn = $cn_cache{$org->id};
1245 $cn = $cn->clone if ($cn);
1246 $cn->clear_isnew if ($cn);
1249 ->request( 'open-ils.cstore.direct.asset.call_number.search' => { owning_lib => $org->id, record => $recid, label => '##URI##' } )
1253 $cn = Fieldmapper::asset::call_number->new;
1256 $cn->id( $$max_cn++ );
1257 $cn->owning_lib( $org->id );
1258 $cn->record( $recid );
1259 $cn->create_date( 'now' );
1260 $cn->creator( $rec->creator );
1261 $cn->editor( $rec->editor );
1262 $cn->edit_date( 'now' );
1263 $cn->label( '##URI##' );
1266 $cn_cache{$org->id} = $cn;
1268 push @objects, { uri => $uri, call_number => $cn };
1271 $log->debug("Returning ".scalar(@objects)." URI nodes for record $recid");
1272 $cstore->disconnect;
1276 sub get_uris_record {
1281 OpenILS::Application::Ingest->post_init();
1282 my $r = OpenSRF::AppSession
1283 ->create('open-ils.cstore')
1284 ->request( "open-ils.cstore.direct.biblio.record_entry.retrieve" => $rec )
1287 return undef unless ($r and $r->marc);
1289 $client->respond($_) for (_extract_856_uris($r));
1292 __PACKAGE__->register_method(
1293 api_name => "open-ils.ingest.856_uri.record",
1294 method => "get_uris_record",
1300 sub get_uris_object {
1305 my $max_uri = shift;
1307 return undef unless ($obj and $obj->marc);
1309 $client->respond($_) for (_extract_856_uris($obj, \$max_cn, \$max_uri));
1312 __PACKAGE__->register_method(
1313 api_name => "open-ils.ingest.856_uri.object",
1314 method => "get_uris_object",
1321 # --------------------------------------------------------------------------------
1324 package OpenILS::Application::Ingest::Biblio::Fingerprint;
1325 use base qw/OpenILS::Application::Ingest/;
1326 use Unicode::Normalize;
1327 use OpenSRF::EX qw/:try/;
1329 sub biblio_fingerprint_record {
1334 OpenILS::Application::Ingest->post_init();
1336 my $r = OpenSRF::AppSession
1337 ->create('open-ils.cstore')
1338 ->request( 'open-ils.cstore.direct.biblio.record_entry.retrieve' => $rec )
1341 return undef unless ($r and $r->marc);
1343 my ($fp) = $self->method_lookup('open-ils.ingest.fingerprint.xml')->run($r->marc);
1344 $log->debug("Returning [$fp] as fingerprint for record $rec", INFO);
1345 $fp->{quality} = int($fp->{quality});
1348 __PACKAGE__->register_method(
1349 api_name => "open-ils.ingest.fingerprint.record",
1350 method => "biblio_fingerprint_record",
1356 sub biblio_fingerprint {
1359 my $xml = OpenILS::Application::AppUtils->entityize(shift);
1361 $log->internal("Got MARC [$xml]");
1364 my @pfx = ( "apps", "open-ils.ingest","app_settings" );
1365 my $conf = OpenSRF::Utils::SettingsClient->new;
1367 my $libs = $conf->config_value(@pfx, 'script_path');
1368 my $script_file = $conf->config_value(@pfx, 'scripts', 'biblio_fingerprint');
1369 my $script_libs = (ref($libs)) ? $libs : [$libs];
1371 $log->debug("Loading script $script_file for biblio fingerprinting...");
1373 $fp_script = new OpenILS::Utils::ScriptRunner
1374 ( file => $script_file,
1375 paths => $script_libs,
1376 reset_count => 100 );
1379 $fp_script->insert('environment' => {marc => $xml} => 1);
1381 my $res = $fp_script->run || ($log->error( "Fingerprint script died! $@" ) && return undef);
1382 $log->debug("Script for biblio fingerprinting completed successfully...");
1386 __PACKAGE__->register_method(
1387 api_name => "open-ils.ingest.fingerprint.xml",
1388 method => "biblio_fingerprint",
1394 sub biblio_descriptor {
1397 my $xml = OpenILS::Application::AppUtils->entityize(shift);
1399 $log->internal("Got MARC [$xml]");
1402 my @pfx = ( "apps", "open-ils.ingest","app_settings" );
1403 my $conf = OpenSRF::Utils::SettingsClient->new;
1405 my $libs = $conf->config_value(@pfx, 'script_path');
1406 my $script_file = $conf->config_value(@pfx, 'scripts', 'biblio_descriptor');
1407 my $script_libs = (ref($libs)) ? $libs : [$libs];
1409 $log->debug("Loading script $script_file for biblio descriptor extraction...");
1411 $rd_script = new OpenILS::Utils::ScriptRunner
1412 ( file => $script_file,
1413 paths => $script_libs,
1414 reset_count => 100 );
1417 $log->debug("Setting up environment for descriptor extraction script...");
1418 $rd_script->insert('environment.marc' => $xml => 1);
1419 $log->debug("Environment building complete...");
1421 my $res = $rd_script->run || ($log->error( "Descriptor script died! $@" ) && return undef);
1422 $log->debug("Script for biblio descriptor extraction completed successfully");
1424 my $d1 = $res->date1;
1425 if ($d1 && $d1 ne ' ') {
1430 my $d2 = $res->date2;
1431 if ($d2 && $d2 ne ' ') {
1438 __PACKAGE__->register_method(
1439 api_name => "open-ils.ingest.descriptor.xml",
1440 method => "biblio_descriptor",