1 use strict; use warnings;
2 package OpenILS::Utils::CStoreEditor;
3 use OpenILS::Application::AppUtils;
4 use OpenSRF::AppSession;
5 use OpenSRF::EX qw(:try);
6 use OpenILS::Utils::Fieldmapper;
10 use OpenSRF::Utils::Logger qw($logger);
11 my $U = "OpenILS::Application::AppUtils";
16 # 'biblio.record_entry' => { update => 'UPDATE_MARC' },
17 # 'asset.copy' => { update => 'UPDATE_COPY'},
18 # 'asset.call_number' => { update => 'UPDATE_VOLUME'},
19 # 'action.circulation' => { retrieve => 'VIEW_CIRCULATIONS'},
24 # -----------------------------------------------------------------------------
25 # Export some useful functions
26 # -----------------------------------------------------------------------------
27 use vars qw(@EXPORT_OK %EXPORT_TAGS);
29 use base qw/Exporter/;
30 push @EXPORT_OK, ( 'new_editor', 'new_rstore_editor' );
31 %EXPORT_TAGS = ( funcs => [ qw/ new_editor new_rstore_editor / ] );
33 sub new_editor { return OpenILS::Utils::CStoreEditor->new(@_); }
35 sub new_rstore_editor {
36 my $e = OpenILS::Utils::CStoreEditor->new(@_);
37 $e->app('open-ils.reporter-store');
42 # -----------------------------------------------------------------------------
44 # -----------------------------------------------------------------------------
45 use constant E => 'error';
46 use constant W => 'warn';
47 use constant I => 'info';
48 use constant D => 'debug';
49 use constant A => 'activity';
53 # -----------------------------------------------------------------------------
55 # xact=><true> : creates a storage transaction
56 # authtoken=>$token : the login session key
57 # -----------------------------------------------------------------------------
59 my( $class, %params ) = @_;
60 $class = ref($class) || $class;
61 my $self = bless( \%params, $class );
62 $self->{checked_perms} = {};
68 my( $self, $app ) = @_;
69 $self->{app} = $app if $app;
70 $self->{app} = 'open-ils.cstore' unless $self->{app};
75 # -----------------------------------------------------------------------------
76 # Log the editor metadata along with the log string
77 # -----------------------------------------------------------------------------
79 my( $self, $lev, $str ) = @_;
81 $s .= "0|" unless $self->{xact};
82 $s .= "1|" if $self->{xact};
83 $s .= "0" unless $self->requestor;
84 $s .= $self->requestor->id if $self->requestor;
86 $logger->$lev("$s $str");
89 # -----------------------------------------------------------------------------
90 # Verifies the auth token and fetches the requestor object
91 # -----------------------------------------------------------------------------
94 $self->log(D, "checking auth token ".$self->authtoken);
95 my ($reqr, $evt) = $U->checkses($self->authtoken);
96 $self->event($evt) if $evt;
97 return $self->{requestor} = $reqr;
104 $cache = OpenSRF::Utils::Cache->new('global') unless $cache;
105 $self->log(D, "checking cached auth token ".$self->authtoken);
106 my $user = $cache->get_cache("oils_auth_".$self->authtoken);
107 return $self->{requestor} = $user->{userobj} if $user;
108 $self->event(OpenILS::Event->new('NO_SESSION'));
114 # -----------------------------------------------------------------------------
115 # Returns the last generated event
116 # -----------------------------------------------------------------------------
118 my( $self, $evt ) = @_;
119 $self->{event} = $evt if $evt;
120 return $self->{event};
123 # -----------------------------------------------------------------------------
124 # Destroys the transaction and disconnects where necessary,
125 # then returns the last event that occurred
126 # -----------------------------------------------------------------------------
134 # -----------------------------------------------------------------------------
135 # Clears the last caught event
136 # -----------------------------------------------------------------------------
139 $self->{event} = undef;
143 my( $self, $auth ) = @_;
144 $self->{authtoken} = $auth if $auth;
145 return $self->{authtoken};
148 # -----------------------------------------------------------------------------
149 # fetches the session, creating if necessary. If 'xact' is true on this
150 # object, a db session is created
151 # -----------------------------------------------------------------------------
153 my( $self, $session ) = @_;
154 $self->{session} = $session if $session;
156 if(!$self->{session}) {
157 $self->{session} = OpenSRF::AppSession->create($self->app);
159 if( ! $self->{session} ) {
160 my $str = "Error creating cstore session with OpenSRF::AppSession->create()!";
162 throw OpenSRF::EX::ERROR ($str);
165 $self->{session}->connect if $self->{xact} or $self->{connect};
166 $self->xact_start if $self->{xact};
168 return $self->{session};
172 # -----------------------------------------------------------------------------
173 # Starts a storage transaction
174 # -----------------------------------------------------------------------------
177 $self->log(D, "starting new db session");
178 my $stat = $self->request($self->app . '.transaction.begin');
179 $self->log(E, "error starting database transaction") unless $stat;
183 # -----------------------------------------------------------------------------
184 # Commits a storage transaction
185 # -----------------------------------------------------------------------------
188 $self->log(D, "comitting db session");
189 my $stat = $self->request($self->app.'.transaction.commit');
190 $self->log(E, "error comitting database transaction") unless $stat;
194 # -----------------------------------------------------------------------------
195 # Rolls back a storage stransaction
196 # -----------------------------------------------------------------------------
199 return unless $self->{session};
200 $self->log(I, "rolling back db session");
201 return $self->request($self->app.".transaction.rollback");
206 # -----------------------------------------------------------------------------
207 # Rolls back the transaction and disconnects
208 # -----------------------------------------------------------------------------
211 $self->xact_rollback if $self->{xact};
217 $self->session->disconnect if $self->{session};
221 # -----------------------------------------------------------------------------
222 # commits the db session and destroys the session
223 # -----------------------------------------------------------------------------
226 return unless $self->{xact};
228 $self->session->disconnect;
229 $self->{session} = undef;
232 # -----------------------------------------------------------------------------
233 # clears all object data. Does not commit the db transaction.
234 # -----------------------------------------------------------------------------
238 $$self{$_} = undef for (keys %$self);
242 # -----------------------------------------------------------------------------
244 # -----------------------------------------------------------------------------
253 # -----------------------------------------------------------------------------
254 # Does a simple storage request
255 # -----------------------------------------------------------------------------
257 my( $self, $method, @params ) = @_;
261 my $argstr = __arg_to_string( (scalar(@params)) == 1 ? $params[0] : \@params);
263 $self->log(I, "request $method : $argstr");
265 if( $self->{xact} and
266 $self->session->state != OpenSRF::AppSession::CONNECTED() ) {
267 $logger->error("CStoreEditor lost it's connection!!");
268 #throw OpenSRF::EX::ERROR ("CStoreEditor lost it's connection - transaction cannot continue");
272 $val = $self->session->request($method, @params)->gather(1);
276 $self->log(E, "request error $method : $argstr : $err");
284 # -----------------------------------------------------------------------------
285 # Sets / Returns the requstor object. This is set when checkauth succeeds.
286 # -----------------------------------------------------------------------------
288 my($self, $requestor) = @_;
289 $self->{requestor} = $requestor if $requestor;
290 return $self->{requestor};
295 # -----------------------------------------------------------------------------
296 # Holds the last data received from a storage call
297 # -----------------------------------------------------------------------------
299 my( $self, $data ) = @_;
300 $self->{data} = $data if defined $data;
301 return $self->{data};
305 # -----------------------------------------------------------------------------
306 # True if this perm has already been checked at this org
307 # -----------------------------------------------------------------------------
309 my( $self, $perm, $org ) = @_;
310 $self->{checked_perms}->{$org} = {}
311 unless $self->{checked_perms}->{$org};
312 my $checked = $self->{checked_perms}->{$org}->{$perm};
314 $self->{checked_perms}->{$org}->{$perm} = 1;
322 # -----------------------------------------------------------------------------
323 # Returns true if the requested perm is allowed. If the perm check fails,
324 # $e->event is set and undef is returned
325 # The perm user is $e->requestor->id and perm org defaults to the requestor's
327 # If this perm at the given org has already been verified, true is returned
328 # and the perm is not re-checked
329 # -----------------------------------------------------------------------------
331 my( $self, $perm, $org ) = @_;
332 my $uid = $self->requestor->id;
333 $org ||= $self->requestor->ws_ou;
334 $self->log(I, "checking perms user=$uid, org=$org, perm=$perm");
335 return 1 if $self->perm_checked($perm, $org);
336 return $self->checkperm($uid, $org, $perm);
340 my($self, $userid, $org, $perm) = @_;
341 my $s = $U->storagereq(
342 "open-ils.storage.permission.user_has_perm", $userid, $perm, $org );
345 my $e = OpenILS::Event->new('PERM_FAILURE', ilsperm => $perm, ilspermloc => $org);
355 # -----------------------------------------------------------------------------
356 # checks the appropriate perm for the operation
357 # -----------------------------------------------------------------------------
359 my( $self, $ptype, $action, $org ) = @_;
360 $org ||= $self->requestor->ws_ou;
361 my $perm = $PERMS{$ptype}{$action};
363 return undef if $self->perm_checked($perm, $org);
364 return $self->event unless $self->allowed($perm, $org);
366 $self->log(I, "no perm provided for $ptype.$action");
373 # -----------------------------------------------------------------------------
374 # Logs update actions to the activity log
375 # -----------------------------------------------------------------------------
377 my( $self, $type, $action, $arg ) = @_;
378 my $str = "$type.$action";
379 $str .= _prop_string($arg);
387 my @props = $obj->properties;
390 my $prop = $obj->$_() || "";
391 $prop = substr($prop, 0, 128) . "..." if length $prop > 131;
398 sub __arg_to_string {
400 return "" unless defined $arg;
401 if( UNIVERSAL::isa($arg, "Fieldmapper") ) {
402 return (defined $arg->id) ? $arg->id : '<new object>';
404 return JSON->perl2JSON($arg);
409 # -----------------------------------------------------------------------------
410 # This does the actual storage query.
412 # 'search' calls become search_where calls and $arg can be a search hash or
413 # an array-ref of storage search options.
415 # 'retrieve' expects an id
416 # 'update' expects an object
417 # 'create' expects an object
418 # 'delete' expects an object
420 # All methods return true on success and undef on failure. On failure,
421 # $e->event is set to the generated event.
422 # Note: this method assumes that updating a non-changed object and
423 # thereby receiving a 0 from storage, is a successful update.
425 # The method will therefore return true so the caller can just do
426 # $e->update_blah($x) or return $e->event;
427 # The true value returned from storage for all methods will be stored in
428 # $e->data, until the next method is called.
430 # not-found events are generated on retrieve and serach methods.
431 # action=search methods will return [] (==true) if no data is found. If the
432 # caller is interested in the not found event, they can do:
433 # return $e->event unless @$results;
434 # -----------------------------------------------------------------------------
436 my( $self, $action, $type, $arg, $options ) = @_;
438 if( $action eq 'retrieve' ) {
439 if(! defined($arg) ) {
440 $self->log(W,"$action $type called with no ID...");
441 $self->event(_mk_not_found($type, $arg));
443 } elsif( ref($arg) =~ /Fieldmapper/ ) {
444 $self->log(E,"$action $type called with an object.. attempting ID retrieval..");
449 my @arg = ( ref($arg) eq 'ARRAY' ) ? @$arg : ($arg);
450 my $method = $self->app.".direct.$type.$action";
452 if( $action eq 'search' ) {
453 $method = "$method.atomic";
455 } elsif( $action eq 'batch_retrieve' ) {
457 @arg = ( { id => $arg } );
458 $method =~ s/batch_retrieve/search/o;
459 $method = "$method.atomic";
461 } elsif( $action eq 'retrieve_all' ) {
463 $method =~ s/retrieve_all/search/o;
466 my $fmobj = "Fieldmapper::$tt";
467 @arg = ( { $fmobj->Identity => { '!=' => undef } } );
468 $method = "$method.atomic";
471 $method =~ s/search/id_list/o if $options->{idlist};
473 # remove any stale events
476 if( $action eq 'update' or $action eq 'delete' or $action eq 'create' ) {
478 $logger->error("Attempt to update DB while not in a transaction : $method");
479 throw OpenSRF::EX::ERROR ("Attempt to update DB while not in a transaction : $method");
481 $self->log_activity($type, $action, $arg);
484 if($$options{checkperm}) {
485 my $a = ($action eq 'search') ? 'retrieve' : $action;
486 my $e = $self->_checkperm($type, $a, $$options{permorg});
497 $obj = $self->request($method, @arg);
498 } catch Error with { $err = shift; };
502 $self->log(I, "request returned no data : $method");
504 if( $action eq 'retrieve' ) {
505 $self->event(_mk_not_found($type, $arg));
507 } elsif( $action eq 'update' or
508 $action eq 'delete' or $action eq 'create' ) {
509 my $evt = OpenILS::Event->new(
510 'DATABASE_UPDATE_FAILED', payload => $arg, debug => "$err" );
516 OpenILS::Event->new( 'DATABASE_QUERY_FAILED',
517 payload => $arg, debug => "$err" ));
524 if( $action eq 'create' and $obj == 0 ) {
525 my $evt = OpenILS::Event->new(
526 'DATABASE_UPDATE_FAILED', payload => $arg, debug => "$err" );
531 # If we havn't dealt with the error in a nice way, go ahead and throw it
534 OpenILS::Event->new( 'DATABASE_QUERY_FAILED',
535 payload => $arg, debug => "$err" ));
539 if( $action eq 'search' or $action eq 'batch_retrieve' or $action eq 'retrieve_all') {
540 $self->log(I, "$type.$action : returned ".scalar(@$obj). " result(s)");
541 $self->event(_mk_not_found($type, $arg)) unless @$obj;
544 if( $action eq 'create' ) {
545 $self->log(I, "created a new $type object with ID " . $obj->id);
549 $self->data($obj); # cache the data for convenience
551 return ($obj) ? $obj : 1;
556 my( $type, $arg ) = @_;
557 (my $t = $type) =~ s/\./_/og;
559 return OpenILS::Event->new("${t}_NOT_FOUND", payload => $arg);
564 # utility method for loading
568 $str =~ s/Fieldmapper:://o;
574 # -------------------------------------------------------------
575 # Load up the methods from the FM classes
576 # -------------------------------------------------------------
577 my $map = $Fieldmapper::fieldmap;
578 for my $object (keys %$map) {
579 my $obj = __fm2meth($object,'_');
580 my $type = __fm2meth($object, '.');
582 my $update = "update_$obj";
584 "sub $update {return shift()->runmethod('update', '$type', \@_);}";
587 my $retrieve = "retrieve_$obj";
589 "sub $retrieve {return shift()->runmethod('retrieve', '$type', \@_);}";
592 my $search = "search_$obj";
594 "sub $search {return shift()->runmethod('search', '$type', \@_);}";
597 my $create = "create_$obj";
599 "sub $create {return shift()->runmethod('create', '$type', \@_);}";
602 my $delete = "delete_$obj";
604 "sub $delete {return shift()->runmethod('delete', '$type', \@_);}";
607 my $bretrieve = "batch_retrieve_$obj";
609 "sub $bretrieve {return shift()->runmethod('batch_retrieve', '$type', \@_);}";
612 my $retrieveall = "retrieve_all_$obj";
614 "sub $retrieveall {return shift()->runmethod('retrieve_all', '$type', \@_);}";