1 package OpenILS::Application::Vandelay;
2 use strict; use warnings;
3 use OpenILS::Application;
4 use base qw/OpenILS::Application/;
5 use Unicode::Normalize;
6 use OpenSRF::EX qw/:try/;
7 use OpenSRF::AppSession;
8 use OpenSRF::Utils::SettingsClient;
9 use OpenSRF::Utils::Cache;
10 use OpenILS::Utils::Fieldmapper;
11 use OpenILS::Utils::CStoreEditor qw/:funcs/;
15 use OpenILS::Utils::Fieldmapper;
16 use Time::HiRes qw(time);
17 use OpenSRF::Utils::Logger qw/$logger/;
19 use OpenILS::Application::AppUtils;
20 use OpenILS::Application::Cat::BibCommon;
21 my $U = 'OpenILS::Application::AppUtils';
26 # --------------------------------------------------------------------------------
29 sub create_bib_queue {
37 my $e = new_editor(authtoken => $auth, xact => 1);
39 return $e->die_event unless $e->checkauth;
40 return $e->die_event unless $e->allowed('CREATE_BIB_IMPORT_QUEUE');
41 $owner ||= $e->requestor->id;
43 my $queue = new Fieldmapper::vandelay::bib_queue();
44 $queue->name( $name );
45 $queue->owner( $owner );
46 $queue->queue_type( $type ) if ($type);
48 my $new_q = $e->create_vandelay_bib_queue( $queue );
49 return $e->die_event unless ($new_q);
54 __PACKAGE__->register_method(
55 api_name => "open-ils.vandelay.bib_queue.create",
56 method => "create_bib_queue",
62 sub create_auth_queue {
70 my $e = new_editor(authtoken => $auth, xact => 1);
72 return $e->die_event unless $e->checkauth;
73 return $e->die_event unless $e->allowed('CREATE_AUTHORITY_IMPORT_QUEUE');
74 $owner ||= $e->requestor->id;
76 my $queue = new Fieldmapper::vandelay::authority_queue();
77 $queue->name( $name );
78 $queue->owner( $owner );
79 $queue->queue_type( $type ) if ($type);
81 my $new_q = $e->create_vandelay_authority_queue( $queue );
82 $e->die_event unless ($new_q);
87 __PACKAGE__->register_method(
88 api_name => "open-ils.vandelay.authority_queue.create",
89 method => "create_auth_queue",
94 sub add_record_to_bib_queue {
102 my $e = new_editor(authtoken => $auth, xact => 1);
104 $queue = $e->retrieve_vandelay_bib_queue($queue);
106 return $e->die_event unless $e->checkauth;
107 return $e->die_event unless
108 ($e->allowed('CREATE_BIB_IMPORT_QUEUE', undef, $queue) ||
109 $e->allowed('CREATE_BIB_IMPORT_QUEUE'));
111 my $new_rec = _add_bib_rec($e, $marc, $queue->id, $purpose);
113 return $e->die_event unless ($new_rec);
117 __PACKAGE__->register_method(
118 api_name => "open-ils.vandelay.queued_bib_record.create",
119 method => "add_record_to_bib_queue",
130 my $rec = new Fieldmapper::vandelay::queued_bib_record();
132 $rec->queue( $queue );
133 $rec->purpose( $purpose ) if ($purpose);
135 return $e->create_vandelay_queued_bib_record( $rec );
138 sub add_record_to_authority_queue {
146 my $e = new_editor(authtoken => $auth, xact => 1);
148 $queue = $e->retrieve_vandelay_authority_queue($queue);
150 return $e->die_event unless $e->checkauth;
151 return $e->die_event unless
152 ($e->allowed('CREATE_AUTHORITY_IMPORT_QUEUE', undef, $queue) ||
153 $e->allowed('CREATE_AUTHORITY_IMPORT_QUEUE'));
155 my $new_rec = _add_auth_rec($e, $marc, $queue->id, $purpose);
157 return $e->die_event unless ($new_rec);
161 __PACKAGE__->register_method(
162 api_name => "open-ils.vandelay.queued_authority_record.create",
163 method => "add_record_to_authority_queue",
174 my $rec = new Fieldmapper::vandelay::queued_authority_record();
176 $rec->queue( $queue );
177 $rec->purpose( $purpose ) if ($purpose);
179 return $e->create_vandelay_queued_authority_record( $rec );
186 my $fingerprint = shift;
187 my $queue_id = shift;
189 my $e = new_editor(authtoken => $auth, xact => 1);
190 return $e->die_event unless $e->checkauth;
193 my $type = $self->{record_type};
196 $queue = $e->retrieve_vandelay_bib_queue($queue_id) or return $e->die_event;
198 $queue = $e->retrieve_vandelay_authority_queue($queue_id) or return $e->die_event;
201 my $evt = check_queue_perms($e, $type, $queue);
204 my $method = "open-ils.vandelay.queued_${type}_record.create";
205 $method = $self->method_lookup( $method );
207 my $cache = new OpenSRF::Utils::Cache();
209 my $data = $cache->get_cache('vandelay_import_spool_' . $fingerprint);
210 my $purpose = $data->{purpose};
211 $data = decode_base64($data->{marc});
213 $logger->info("vandelay loaded $fingerprint purpose=$purpose and ".length($data)." bytes of data");
216 open $fh, '<', \$data;
218 my $marctype = 'USMARC'; # ?
219 my $batch = new MARC::Batch ( $marctype, $fh );
223 while (my $r = $batch->next) {
224 $logger->info("processing record $count");
226 (my $xml = $r->as_xml_record()) =~ s/\n//sog;
227 $xml =~ s/^<\?xml.+\?\s*>//go;
228 $xml =~ s/>\s+</></go;
229 $xml =~ s/\p{Cc}//go;
230 $xml = $U->entityize($xml);
231 $xml =~ s/[\x00-\x1f]//go;
233 if ($type eq 'bib') {
234 _add_bib_rec( $e, $xml, $queue_id, $purpose ) or return $e->die_event;
236 _add_auth_rec( $e, $xml, $queue_id, $purpose ) or return $e->die_event;
240 $client->respond( $count );
243 $logger->warn("Encountered a bad record at Vandelay ingest: ".$error);
250 __PACKAGE__->register_method(
251 api_name => "open-ils.vandelay.bib.process_spool",
252 method => "process_spool",
257 __PACKAGE__->register_method(
258 api_name => "open-ils.vandelay.auth.process_spool",
259 method => "process_spool",
262 record_type => 'auth'
266 __PACKAGE__->register_method(
267 api_name => "open-ils.vandelay.bib_queue.records.retrieve",
268 method => 'retrieve_queue',
274 __PACKAGE__->register_method(
275 api_name => "open-ils.vandelay.auth_queue.records.retrieve",
276 method => 'retrieve_queue',
280 record_type => 'auth'
283 __PACKAGE__->register_method(
284 api_name => "open-ils.vandelay.bib_queue.records.matches.retrieve",
285 method => 'retrieve_queue',
289 record_type => 'bib',
291 desc => q/Only retrieve queued bib records that have matches against existing records/
294 __PACKAGE__->register_method(
295 api_name => "open-ils.vandelay.auth_queue.records.matches.retrieve",
296 method => 'retrieve_queue',
300 record_type => 'auth',
302 desc => q/Only retrieve queued authority records that have matches against existing records/
308 my($self, $conn, $auth, $queue_id, $options) = @_;
309 my $e = new_editor(authtoken => $auth);
310 return $e->event unless $e->checkauth;
312 my $limit = $$options{limit} || 20;
313 my $offset = $$options{offset} || 0;
315 my $type = $self->{record_type};
318 $queue = $e->retrieve_vandelay_bib_queue($queue_id) or return $e->die_event;
320 $queue = $e->retrieve_vandelay_authority_queue($queue_id) or return $e->die_event;
322 my $evt = check_queue_perms($e, $type, $queue);
325 my $class = ($type eq 'bib') ? 'vqbr' : 'vqar';
326 my $search = ($type eq 'bib') ?
327 'search_vandelay_queued_bib_record' : 'search_vandelay_queued_authority_record';
328 my $retrieve = ($type eq 'bib') ?
329 'retrieve_vandelay_queued_bib_record' : 'retrieve_vandelay_queued_authority_record';
332 if($self->api_name =~ /matches/) {
333 # fetch only matched records
334 $record_ids = queued_records_with_matches($e, $type, $queue_id, $limit, $offset);
336 # fetch all queue records
337 $record_ids = $e->$search([
338 {queue => $queue_id},
339 {order_by => {$class => 'id'}, limit => $limit, offset => $offset}
346 for my $rec_id (@$record_ids) {
349 flesh_fields => {$class => ['attributes', 'matches']},
351 my $rec = $e->$retrieve([$rec_id, $params]);
352 $rec->clear_marc if $$options{clear_marc};
353 $conn->respond($rec);
358 sub check_queue_perms {
359 my($e, $type, $queue) = @_;
360 if ($type eq 'bib') {
361 return $e->die_event unless
362 ($e->allowed('CREATE_BIB_IMPORT_QUEUE', undef, $queue) ||
363 $e->allowed('CREATE_BIB_IMPORT_QUEUE'));
365 return $e->die_event unless
366 ($e->allowed('CREATE_AUTHORITY_IMPORT_QUEUE', undef, $queue) ||
367 $e->allowed('CREATE_AUTHORITY_IMPORT_QUEUE'));
373 __PACKAGE__->register_method(
374 api_name => "open-ils.vandelay.bib_record.list.import",
375 method => 'import_record_list',
382 __PACKAGE__->register_method(
383 api_name => "open-ils.vandelay.auth_record.list.import",
384 method => 'import_record_list',
388 record_type => 'auth'
391 sub import_record_list {
392 my($self, $conn, $auth, $rec_ids, $args) = @_;
393 my $e = new_editor(xact => 1, authtoken => $auth);
394 return $e->die_event unless $e->checkauth;
396 my $err = import_record_list_impl($self, $conn, $auth, $e, $rec_ids, $args);
399 return {complete => 1};
403 __PACKAGE__->register_method(
404 api_name => "open-ils.vandelay.bib_queue.import",
405 method => 'import_queue',
412 __PACKAGE__->register_method(
413 api_name => "open-ils.vandelay.auth_queue.import",
414 method => 'import_queue',
418 record_type => 'auth'
420 __PACKAGE__->register_method(
421 api_name => "open-ils.vandelay.bib_queue.nomatch.import",
422 method => 'import_queue',
427 desc => q/Only import records that have no collisions/
432 __PACKAGE__->register_method(
433 api_name => "open-ils.vandelay.auth_queue.nomatch.import",
434 method => 'import_queue',
439 desc => q/Only import records that have no collisions/
441 record_type => 'auth'
444 my($self, $conn, $auth, $q_id, $options) = @_;
445 my $e = new_editor(xact => 1, authtoken => $auth);
446 return $e->die_event unless $e->checkauth;
448 my $type = $self->{record_type};
449 my $class = ($type eq 'bib') ? 'vqbr' : 'vqar';
451 my $query = {queue => $q_id, import_time => undef};
453 if($self->api_name =~ /nomatch/) {
454 my $matched_recs = queued_records_with_matches($e, $type, $q_id, undef, undef, {import_time => undef});
455 $query->{id} = {'not in' => $matched_recs} if @$matched_recs;
458 my $search = ($type eq 'bib') ?
459 'search_vandelay_queued_bib_record' : 'search_vandelay_queued_authority_record';
460 my $rec_ids = $e->$search($query, {idlist => 1});
461 my $err = import_record_list_impl($self, $conn, $auth, $e, $rec_ids, $options);
464 return {complete => 1};
468 # returns a list of queued record IDs for a given queue that
469 # have at least one entry in the match table
470 sub queued_records_with_matches {
471 my($e, $type, $q_id, $limit, $offset, $filter) = @_;
473 my $match_class = 'vbm';
474 my $rec_class = 'vqbr';
475 if($type eq 'auth') {
476 $match_class = 'vam';
481 $filter->{queue} = $q_id;
485 select => {$match_class => ['queued_record']},
490 fkey => 'queued_record',
497 if($limit or defined $offset) {
500 $query->{limit} = $limit;
501 $query->{offset} = $offset;
504 my $data = $e->json_query($query);
505 return [ map {$_->{queued_record}} @$data ];
508 sub import_record_list_impl {
509 my($self, $conn, $auth, $e, $rec_ids, $args) = @_;
511 my $overlay_map = $args->{overlay_map} || {};
512 my $type = $self->{record_type};
513 my $total = @$rec_ids;
517 for my $rec_id (@$rec_ids) {
520 my $rec = $e->retrieve_vandelay_queued_bib_record($rec_id)
521 or return $e->die_event;
523 next if $rec->import_time;
524 $queues{$rec->queue} = 1;
527 if(defined $overlay_map->{$rec_id}) {
528 $logger->info("vl: overlaying record $rec_id");
529 $record = OpenILS::Application::Cat::BibCommon->biblio_record_replace_marc(
530 $e, $rec_id, $rec->marc); #$rec->bib_source
532 $logger->info("vl: importing new record");
533 $record = OpenILS::Application::Cat::BibCommon->biblio_record_xml_import(
534 $e, $rec->marc); #$rec->bib_source
537 return $record if $U->event_code($record);
538 $rec->imported_as($record->id);
539 $rec->import_time('now');
540 $e->update_vandelay_queued_bib_record($rec) or return $e->die_event;
544 my $rec = $e->retrieve_vandelay_queued_authority_record($rec_id)
545 or return $e->die_event;
547 next if $rec->import_time;
548 $queues{$rec->queue} = 1;
551 if(defined $overlay_map->{$rec_id}) {
552 $logger->info("vl: overlaying record $rec_id");
553 $record = $U->simplereq(
555 'open-ils.cat.authority.record.overlay',
556 $auth, $overlay_map->{$rec_id}, $rec->marc); #$rec->bib_source);
558 $logger->info("vl: importing new record");
559 $record = $U->simplereq(
561 'open-ils.cat.authority.record.import',
562 $auth, $rec->marc); #$rec->bib_source);
565 if($U->event_code($record)) {
570 $rec->imported_as($record->id);
571 $rec->import_time('now');
572 $e->update_vandelay_queued_authority_record($rec) or return $e->die_event;
575 $conn->respond({total => $total, progress => ++$count, imported => $rec_id});
578 # see if we need to mark any queues as complete
579 for my $q_id (keys %queues) {
581 my $remaining = $e->search_vandelay_queued_bib_record(
582 {queue => $q_id, import_time => undef}, {idlist => 1});
583 unless(@$remaining) {
584 my $queue = $e->retrieve_vandelay_bib_queue($q_id);
585 unless($U->is_true($queue->complete)) {
586 $queue->complete('t');
587 $e->update_vandelay_bib_queue($queue) or return $e->die_event;
591 my $remaining = $e->search_vandelay_queued_authority_record(
592 {queue => $q_id, import_time => undef}, {idlist => 1});
593 unless(@$remaining) {
594 my $queue = $e->retrieve_vandelay_authority_queue($q_id);
595 unless($U->is_true($queue->complete)) {
596 $queue->complete('t');
597 $e->update_vandelay_authority_queue($queue) or return $e->die_event;
607 __PACKAGE__->register_method(
608 api_name => "open-ils.vandelay.bib_queue.owner.retrieve",
609 method => 'owner_queue_retrieve',
615 __PACKAGE__->register_method(
616 api_name => "open-ils.vandelay.authority_queue.owner.retrieve",
617 method => 'owner_queue_retrieve',
621 record_type => 'auth'
624 sub owner_queue_retrieve {
625 my($self, $conn, $auth, $owner_id) = @_;
626 my $e = new_editor(authtoken => $auth);
627 return $e->die_event unless $e->checkauth;
628 $owner_id = $e->requestor->id; # XXX add support for viewing other's queues?
630 if($self->{record_type} eq 'bib') {
631 $queues = $e->search_vandelay_bib_queue(
632 {complete => 'f', owner => $owner_id});
634 $queues = $e->search_vandelay_authority_queue(
635 {complete => 'f', owner => $owner_id});
637 $conn->respond($_) for @$queues;
641 __PACKAGE__->register_method(
642 api_name => "open-ils.vandelay.bib_queue.delete",
643 method => "delete_queue",
648 __PACKAGE__->register_method(
649 api_name => "open-ils.vandelay.auth_queue.delete",
650 method => "delete_queue",
653 record_type => 'auth'
657 my($self, $conn, $auth, $q_id) = @_;
658 my $e = new_editor(xact => 1, authtoken => $auth);
659 return $e->die_event unless $e->checkauth;
660 if($self->{record_type} eq 'bib') {
661 return $e->die_event unless $e->allowed('CREATE_BIB_IMPORT_QUEUE');
662 my $queue = $e->retrieve_vandelay_bib_queue($q_id)
663 or return $e->die_event;
664 $e->delete_vandelay_bib_queue($queue)
665 or return $e->die_event;
667 return $e->die_event unless $e->allowed('CREATE_AUTHORITY_IMPORT_QUEUE');
668 my $queue = $e->retrieve_vandelay_authority_queue($q_id)
669 or return $e->die_event;
670 $e->delete_vandelay_authority_queue($queue)
671 or return $e->die_event;