3 # Copyright ByWater Solutions 2014
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
23 use List::MoreUtils qw( none );
30 Koha::Objects - Koha Object set base class
35 my @objects = Koha::Objects->search({ borrowernumber => $borrowernumber});
39 This class must be subclassed.
47 =head3 Koha::Objects->new();
49 my $object = Koha::Objects->new();
57 bless( $self, $class );
60 =head3 Koha::Objects->_new_from_dbic();
62 my $object = Koha::Objects->_new_from_dbic( $resultset );
67 my ( $class, $resultset ) = @_;
68 my $self = { _resultset => $resultset };
70 bless( $self, $class );
73 =head3 Koha::Objects->find();
75 Similar to DBIx::Class::ResultSet->find this method accepts:
76 \%columns_values | @pk_values, { key => $unique_constraint, %attrs }?
77 Strictly speaking, columns_values should only refer to columns under an
80 It returns undef if no results were found
82 my $object = Koha::Objects->find( { col1 => $val1, col2 => $val2 } );
83 my $object = Koha::Objects->find( $id );
84 my $object = Koha::Objects->find( $idpart1, $idpart2, $attrs ); # composite PK
89 my ( $self, @pars ) = @_;
93 unless (!@pars || none { defined($_) } @pars) {
94 my $result = $self->_resultset()->find(@pars);
96 $object = $self->object_class()->_new_from_dbic($result);
103 =head3 Koha::Objects->find_or_create();
105 my $object = Koha::Objects->find_or_create( $attrs );
110 my ( $self, $params ) = @_;
112 my $result = $self->_resultset->find_or_create($params);
114 return unless $result;
116 my $object = $self->object_class->_new_from_dbic($result);
121 =head3 Koha::Objects->search();
123 my @objects = Koha::Objects->search($params);
128 my ( $self, $params, $attributes ) = @_;
131 my @dbic_rows = $self->_resultset()->search($params, $attributes);
133 return $self->_wrap(@dbic_rows);
137 my $class = ref($self) ? ref($self) : $self;
138 my $rs = $self->_resultset()->search($params, $attributes);
140 return $class->_new_from_dbic($rs);
144 =head3 search_related
146 my @objects = Koha::Objects->search_related( $rel_name, $cond?, \%attrs? );
147 my $objects = Koha::Objects->search_related( $rel_name, $cond?, \%attrs? );
149 Searches the specified relationship, optionally specifying a condition and attributes for matching records.
154 my ( $self, $rel_name, @params ) = @_;
156 return if !$rel_name;
158 my @dbic_rows = $self->_resultset()->search_related($rel_name, @params);
159 return if !@dbic_rows;
160 my $object_class = _get_objects_class( $dbic_rows[0]->result_class );
162 eval "require $object_class";
163 return _wrap( $object_class, @dbic_rows );
166 my $rs = $self->_resultset()->search_related($rel_name, @params);
168 my $object_class = _get_objects_class( $rs->result_class );
170 eval "require $object_class";
171 return _new_from_dbic( $object_class, $rs );
182 if ( Class::Inspector->function_exists( $self->object_class, 'delete' ) ) {
184 $self->_resultset->result_source->schema->txn_do( sub {
185 $self->reset; # If we iterated already over the set
186 while ( my $o = $self->next ) {
191 return $objects_deleted;
194 return $self->_resultset->delete;
199 my $objects = Koha::Objects->new; # or Koha::Objects->search
200 $objects->update( $fields, [ { no_triggers => 0/1 } ] );
202 This method overloads the DBIC inherited one so if code-level triggers exist
203 (through the use of an overloaded I<update> or I<store> method in the Koha::Object
204 based class) those are called in a loop on the resultset.
206 If B<no_triggers> is passed and I<true>, then the DBIC update method is called
207 directly. This feature is important for performance, in cases where no code-level
208 triggers should be triggered. The developer will explicitly ask for this and QA should
209 catch wrong uses as well.
214 my ($self, $fields, $options) = @_;
216 my $no_triggers = $options->{no_triggers};
220 && ( Class::Inspector->function_exists( $self->object_class, 'update' )
221 or Class::Inspector->function_exists( $self->object_class, 'store' ) )
225 $self->_resultset->result_source->schema->txn_do( sub {
226 while ( my $o = $self->next ) {
231 return $objects_updated;
234 return $self->_resultset->update($fields);
239 my $object = Koha::Objects->search({}, { rows => 1 })->single
241 Returns one and only one object that is part of this set.
242 Returns undef if there are no objects found.
244 This is optimal as it will grab the first returned result without instantiating
248 http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Retrieve_one_and_only_one_row_from_a_resultset
255 my $single = $self->_resultset()->single;
256 return unless $single;
258 return $self->object_class()->_new_from_dbic($single);
261 =head3 Koha::Objects->next();
263 my $object = Koha::Objects->next();
265 Returns the next object that is part of this set.
266 Returns undef if there are no more objects to return.
273 my $result = $self->_resultset()->next();
274 return unless $result;
276 my $object = $self->object_class()->_new_from_dbic( $result );
281 =head3 Koha::Objects->last;
283 my $object = Koha::Objects->last;
285 Returns the last object that is part of this set.
286 Returns undef if there are no object to return.
293 my $count = $self->_resultset->count;
294 return unless $count;
296 my ( $result ) = $self->_resultset->slice($count - 1, $count - 1);
298 my $object = $self->object_class()->_new_from_dbic( $result );
305 my $empty_rs = Koha::Objects->new->empty;
307 Sets the resultset empty. This is handy for consistency on method returns
308 (e.g. if we know in advance we won't have results but want to keep returning
316 unless (ref($self)) {
320 $self->_resultset()->set_cache([]);
325 =head3 Koha::Objects->reset();
327 Koha::Objects->reset();
329 resets iteration so the next call to next() will start agein
330 with the first object in a set.
337 $self->_resultset()->reset();
342 =head3 Koha::Objects->as_list();
344 Koha::Objects->as_list();
346 Returns an arrayref of the objects in this set.
353 my @dbic_rows = $self->_resultset()->all();
355 my @objects = $self->_wrap(@dbic_rows);
357 return wantarray ? @objects : \@objects;
360 =head3 Koha::Objects->unblessed
362 Returns an unblessed representation of objects.
369 return [ map { $_->unblessed } $self->as_list ];
372 =head3 Koha::Objects->get_column
374 Return all the values of this set for a given column
379 my ($self, $column_name) = @_;
380 return $self->_resultset->get_column( $column_name )->all;
383 =head3 Koha::Objects->TO_JSON
385 Returns an unblessed representation of objects, suitable for JSON output.
392 return [ map { $_->TO_JSON } $self->as_list ];
395 =head3 Koha::Objects->to_api
397 Returns a representation of the objects, suitable for API output .
402 my ($self, $params) = @_;
404 return [ map { $_->to_api($params) } $self->as_list ];
407 =head3 attributes_from_api
409 my $attributes = $objects->attributes_from_api( $api_attributes );
411 Translates attributes from the API to DBIC
415 sub attributes_from_api {
416 my ( $self, $attributes ) = @_;
418 $self->{_singular_object} ||= $self->object_class->new();
419 return $self->{_singular_object}->attributes_from_api( $attributes );
422 =head3 from_api_mapping
424 my $mapped_attributes_hash = $objects->from_api_mapping;
426 Attributes map from the API to DBIC
430 sub from_api_mapping {
433 $self->{_singular_object} ||= $self->object_class->new();
434 return $self->{_singular_object}->from_api_mapping;
437 =head3 prefetch_whitelist
439 my $whitelist = $object->prefetch_whitelist()
441 Returns a hash of prefetchable subs and the type it returns
445 sub prefetch_whitelist {
448 $self->{_singular_object} ||= $self->object_class->new();
450 $self->{_singular_object}->prefetch_whitelist;
453 =head3 Koha::Objects->_wrap
455 wraps the DBIC object in a corresponding Koha object
460 my ( $self, @dbic_rows ) = @_;
462 my @objects = map { $self->object_class->_new_from_dbic( $_ ) } @dbic_rows;
467 =head3 Koha::Objects->_resultset
469 Returns the internal resultset or creates it if undefined
477 $self->{_resultset} ||=
478 Koha::Database->new()->schema()->resultset( $self->_type() );
480 return $self->{_resultset};
483 return Koha::Database->new()->schema()->resultset( $self->_type() );
487 sub _get_objects_class {
491 if( $type->can('koha_objects_class') ) {
492 return $type->koha_objects_class;
494 $type =~ s|Schema::Result::||;
500 my @columns = Koha::Objects->columns
502 Return the table columns
508 return Koha::Database->new->schema->resultset( $class->_type )->result_source->columns;
513 The autoload method is used call DBIx::Class method on a resultset.
515 Important: If you plan to use one of the DBIx::Class methods you must provide
516 relevant tests in t/db_dependent/Koha/Objects.t
517 Currently count, is_paged, pager, result_class, single and slice are covered.
522 my ( $self, @params ) = @_;
524 my @known_methods = qw( count is_paged pager result_class single slice );
525 my $method = our $AUTOLOAD;
529 unless ( grep { $_ eq $method } @known_methods ) {
530 my $class = ref($self) ? ref($self) : $self;
531 Koha::Exceptions::Object::MethodNotCoveredByTests->throw(
532 error => sprintf("The method %s->%s is not covered by tests!", $class, $method),
537 my $r = eval { $self->_resultset->$method(@params) };
539 carp "No method $method found for " . ref($self) . " " . $@;
547 The _type method must be set for all child classes.
548 The value returned by it should be the DBIC resultset name.
549 For example, for holds, _type should return 'Reserve'.
557 This method must be set for all child classes.
558 The value returned by it should be the name of the Koha
559 object class that is returned by this class.
560 For example, for holds, object_class should return 'Koha::Hold'.
570 Kyle M Hall <kyle@bywatersolutions.com>