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);
124 my @objects = Koha::Objects->search([$params, $attributes]);
126 my $objects = Koha::Objects->search([$params, $attributes]);
127 while (my $object = $objects->next) {
131 This B<instantiates> the I<Koha::Objects> class, and generates a resultset
132 based on the query I<$params> and I<$attributes> that are passed (like in DBIC).
134 In B<list context> it returns an array of I<Koha::Object> objects.
135 In B<scalar context> it returns an iterator.
140 my ( $self, $params, $attributes ) = @_;
143 my @dbic_rows = $self->_resultset()->search($params, $attributes);
145 return $self->_wrap(@dbic_rows);
149 my $class = ref($self) ? ref($self) : $self;
150 my $rs = $self->_resultset()->search($params, $attributes);
152 return $class->_new_from_dbic($rs);
156 =head3 search_related
158 my @objects = Koha::Objects->search_related( $rel_name, $cond?, \%attrs? );
159 my $objects = Koha::Objects->search_related( $rel_name, $cond?, \%attrs? );
161 Searches the specified relationship, optionally specifying a condition and attributes for matching records.
166 my ( $self, $rel_name, @params ) = @_;
168 return if !$rel_name;
170 my @dbic_rows = $self->_resultset()->search_related($rel_name, @params);
171 return if !@dbic_rows;
172 my $object_class = _get_objects_class( $dbic_rows[0]->result_class );
174 eval "require $object_class";
175 return _wrap( $object_class, @dbic_rows );
178 my $rs = $self->_resultset()->search_related($rel_name, @params);
180 my $object_class = _get_objects_class( $rs->result_class );
182 eval "require $object_class";
183 return _new_from_dbic( $object_class, $rs );
194 if ( Class::Inspector->function_exists( $self->object_class, 'delete' ) ) {
196 $self->_resultset->result_source->schema->txn_do( sub {
197 $self->reset; # If we iterated already over the set
198 while ( my $o = $self->next ) {
203 return $objects_deleted;
206 return $self->_resultset->delete;
211 my $objects = Koha::Objects->new; # or Koha::Objects->search
212 $objects->update( $fields, [ { no_triggers => 0/1 } ] );
214 This method overloads the DBIC inherited one so if code-level triggers exist
215 (through the use of an overloaded I<update> or I<store> method in the Koha::Object
216 based class) those are called in a loop on the resultset.
218 If B<no_triggers> is passed and I<true>, then the DBIC update method is called
219 directly. This feature is important for performance, in cases where no code-level
220 triggers should be triggered. The developer will explicitly ask for this and QA should
221 catch wrong uses as well.
226 my ($self, $fields, $options) = @_;
228 my $no_triggers = $options->{no_triggers};
232 && ( Class::Inspector->function_exists( $self->object_class, 'update' )
233 or Class::Inspector->function_exists( $self->object_class, 'store' ) )
237 $self->_resultset->result_source->schema->txn_do( sub {
238 while ( my $o = $self->next ) {
243 return $objects_updated;
246 return $self->_resultset->update($fields);
251 my $object = Koha::Objects->search({}, { rows => 1 })->single
253 Returns one and only one object that is part of this set.
254 Returns undef if there are no objects found.
256 This is optimal as it will grab the first returned result without instantiating
260 http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Retrieve_one_and_only_one_row_from_a_resultset
267 my $single = $self->_resultset()->single;
268 return unless $single;
270 return $self->object_class()->_new_from_dbic($single);
273 =head3 Koha::Objects->next();
275 my $object = Koha::Objects->next();
277 Returns the next object that is part of this set.
278 Returns undef if there are no more objects to return.
285 my $result = $self->_resultset()->next();
286 return unless $result;
288 my $object = $self->object_class()->_new_from_dbic( $result );
293 =head3 Koha::Objects->last;
295 my $object = Koha::Objects->last;
297 Returns the last object that is part of this set.
298 Returns undef if there are no object to return.
305 my $count = $self->_resultset->count;
306 return unless $count;
308 my ( $result ) = $self->_resultset->slice($count - 1, $count - 1);
310 my $object = $self->object_class()->_new_from_dbic( $result );
317 my $empty_rs = Koha::Objects->new->empty;
319 Sets the resultset empty. This is handy for consistency on method returns
320 (e.g. if we know in advance we won't have results but want to keep returning
328 unless (ref($self)) {
332 $self->_resultset()->set_cache([]);
337 =head3 Koha::Objects->reset();
339 Koha::Objects->reset();
341 resets iteration so the next call to next() will start agein
342 with the first object in a set.
349 $self->_resultset()->reset();
354 =head3 Koha::Objects->as_list();
356 Koha::Objects->as_list();
358 Returns an arrayref of the objects in this set.
365 my @dbic_rows = $self->_resultset()->all();
367 my @objects = $self->_wrap(@dbic_rows);
369 return wantarray ? @objects : \@objects;
372 =head3 Koha::Objects->unblessed
374 Returns an unblessed representation of objects.
381 return [ map { $_->unblessed } $self->as_list ];
384 =head3 Koha::Objects->get_column
386 Return all the values of this set for a given column
391 my ($self, $column_name) = @_;
392 return $self->_resultset->get_column( $column_name )->all;
395 =head3 Koha::Objects->TO_JSON
397 Returns an unblessed representation of objects, suitable for JSON output.
404 return [ map { $_->TO_JSON } $self->as_list ];
407 =head3 Koha::Objects->to_api
409 Returns a representation of the objects, suitable for API output .
414 my ($self, $params) = @_;
416 return [ map { $_->to_api($params) } $self->as_list ];
419 =head3 attributes_from_api
421 my $attributes = $objects->attributes_from_api( $api_attributes );
423 Translates attributes from the API to DBIC
427 sub attributes_from_api {
428 my ( $self, $attributes ) = @_;
430 $self->{_singular_object} ||= $self->object_class->new();
431 return $self->{_singular_object}->attributes_from_api( $attributes );
434 =head3 from_api_mapping
436 my $mapped_attributes_hash = $objects->from_api_mapping;
438 Attributes map from the API to DBIC
442 sub from_api_mapping {
445 $self->{_singular_object} ||= $self->object_class->new();
446 return $self->{_singular_object}->from_api_mapping;
449 =head3 prefetch_whitelist
451 my $whitelist = $object->prefetch_whitelist()
453 Returns a hash of prefetchable subs and the type it returns
457 sub prefetch_whitelist {
460 $self->{_singular_object} ||= $self->object_class->new();
462 $self->{_singular_object}->prefetch_whitelist;
465 =head3 Koha::Objects->_wrap
467 wraps the DBIC object in a corresponding Koha object
472 my ( $self, @dbic_rows ) = @_;
474 my @objects = map { $self->object_class->_new_from_dbic( $_ ) } @dbic_rows;
479 =head3 Koha::Objects->_resultset
481 Returns the internal resultset or creates it if undefined
489 $self->{_resultset} ||=
490 Koha::Database->new()->schema()->resultset( $self->_type() );
492 return $self->{_resultset};
495 return Koha::Database->new()->schema()->resultset( $self->_type() );
499 sub _get_objects_class {
503 if( $type->can('koha_objects_class') ) {
504 return $type->koha_objects_class;
506 $type =~ s|Schema::Result::||;
512 my @columns = Koha::Objects->columns
514 Return the table columns
520 return Koha::Database->new->schema->resultset( $class->_type )->result_source->columns;
525 The autoload method is used call DBIx::Class method on a resultset.
527 Important: If you plan to use one of the DBIx::Class methods you must provide
528 relevant tests in t/db_dependent/Koha/Objects.t
529 Currently count, is_paged, pager, result_class, single and slice are covered.
534 my ( $self, @params ) = @_;
536 my @known_methods = qw( count is_paged pager result_class single slice );
537 my $method = our $AUTOLOAD;
541 unless ( grep { $_ eq $method } @known_methods ) {
542 my $class = ref($self) ? ref($self) : $self;
543 Koha::Exceptions::Object::MethodNotCoveredByTests->throw(
544 error => sprintf("The method %s->%s is not covered by tests!", $class, $method),
549 my $r = eval { $self->_resultset->$method(@params) };
551 carp "No method $method found for " . ref($self) . " " . $@;
559 The _type method must be set for all child classes.
560 The value returned by it should be the DBIC resultset name.
561 For example, for holds, _type should return 'Reserve'.
569 This method must be set for all child classes.
570 The value returned by it should be the name of the Koha
571 object class that is returned by this class.
572 For example, for holds, object_class should return 'Koha::Hold'.
582 Kyle M Hall <kyle@bywatersolutions.com>