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 );
27 use Koha::Exceptions::Object;
28 use Koha::DateUtils qw( dt_from_string );
32 Koha::Objects - Koha Object set base class
37 my $objects = Koha::Objects->search({ borrowernumber => $borrowernumber});
41 This class must be subclassed.
49 =head3 Koha::Objects->new();
51 my $object = Koha::Objects->new();
59 bless( $self, $class );
62 =head3 Koha::Objects->_new_from_dbic();
64 my $object = Koha::Objects->_new_from_dbic( $resultset );
69 my ( $class, $resultset ) = @_;
70 my $self = { _resultset => $resultset };
72 bless( $self, $class );
75 =head3 Koha::Objects->find();
77 Similar to DBIx::Class::ResultSet->find this method accepts:
78 \%columns_values | @pk_values, { key => $unique_constraint, %attrs }?
79 Strictly speaking, columns_values should only refer to columns under an
82 It returns undef if no results were found
84 my $object = Koha::Objects->find( { col1 => $val1, col2 => $val2 } );
85 my $object = Koha::Objects->find( $id );
86 my $object = Koha::Objects->find( $idpart1, $idpart2, $attrs ); # composite PK
91 my ( $self, @pars ) = @_;
95 unless (!@pars || none { defined($_) } @pars) {
96 my $result = $self->_resultset()->find(@pars);
98 $object = $self->object_class()->_new_from_dbic($result);
105 =head3 Koha::Objects->find_or_create();
107 my $object = Koha::Objects->find_or_create( $attrs );
112 my ( $self, $params ) = @_;
114 my $result = $self->_resultset->find_or_create($params);
116 return unless $result;
118 my $object = $self->object_class->_new_from_dbic($result);
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).
137 my ( $self, $params, $attributes ) = @_;
139 my $class = ref($self) ? ref($self) : $self;
140 my $rs = $self->_resultset()->search($params, $attributes);
142 return $class->_new_from_dbic($rs);
145 =head3 search_related
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 $rs = $self->_resultset()->search_related($rel_name, @params);
160 my $object_class = _get_objects_class( $rs->result_class );
162 eval "require $object_class";
163 return _new_from_dbic( $object_class, $rs );
173 if ( Class::Inspector->function_exists( $self->object_class, 'delete' ) ) {
175 $self->_resultset->result_source->schema->txn_do( sub {
176 $self->reset; # If we iterated already over the set
177 while ( my $o = $self->next ) {
182 return $objects_deleted;
185 return $self->_resultset->delete;
190 my $objects = Koha::Objects->new; # or Koha::Objects->search
191 $objects->update( $fields, [ { no_triggers => 0/1 } ] );
193 This method overloads the DBIC inherited one so if code-level triggers exist
194 (through the use of an overloaded I<update> or I<store> method in the Koha::Object
195 based class) those are called in a loop on the resultset.
197 If B<no_triggers> is passed and I<true>, then the DBIC update method is called
198 directly. This feature is important for performance, in cases where no code-level
199 triggers should be triggered. The developer will explicitly ask for this and QA should
200 catch wrong uses as well.
205 my ($self, $fields, $options) = @_;
207 Koha::Exceptions::Object::NotInstantiated->throw(
212 my $no_triggers = $options->{no_triggers};
216 && ( Class::Inspector->function_exists( $self->object_class, 'update' )
217 or Class::Inspector->function_exists( $self->object_class, 'store' ) )
221 $self->_resultset->result_source->schema->txn_do( sub {
222 while ( my $o = $self->next ) {
227 return $objects_updated;
230 return $self->_resultset->update($fields);
233 =head3 filter_by_last_update
235 my $filtered_objects = $objects->filter_by_last_update({
236 days => $days, from => $date1, to => $date2, days_inclusive => 1,
237 older_than => $days, younger_than => $days,
241 You should pass at least one of the parameters: days, from, to, older_than,
242 younger_than. Make sure that they do not conflict with each other to get
244 By default, from and to are inclusive and days is exclusive (unless you
245 passed the optional days_inclusive parameter).
246 By nature older_than and younger_than are exclusive. This cannot be changed.
247 The optional parameter datetime allows datetime comparison.
249 The from and to parameters can be DateTime objects or date strings.
253 sub filter_by_last_update {
254 my ( $self, $params ) = @_;
255 my $timestamp_column_name = $params->{timestamp_column_name} || 'timestamp';
256 my $days_inclusive = $params->{days_inclusive} || 0;
258 Koha::Exceptions::MissingParameter->throw("Please pass: days|from|to|older_than|younger_than")
259 unless grep { exists $params->{$_} } qw/days from to older_than younger_than/;
261 my $dtf = Koha::Database->new->schema->storage->datetime_parser;
262 my $method = $params->{datetime} ? 'format_datetime' : 'format_date';
263 foreach my $p ( qw/days older_than younger_than/ ) {
264 next if !exists $params->{$p};
265 my $dt = Koha::DateUtils::dt_from_string();
266 my $operator = $p eq 'days' && $days_inclusive
268 : $p eq 'younger_than'
271 $conditions->{$operator} = $dtf->$method( $dt->subtract( days => $params->{$p} ) );
273 if ( exists $params->{from} ) {
274 my $from = ref($params->{from}) ? $params->{from} : dt_from_string($params->{from});
275 $conditions->{'>='} = $dtf->$method( $from );
277 if ( exists $params->{to} ) {
278 my $to = ref($params->{to}) ? $params->{to} : dt_from_string($params->{to});
279 $conditions->{'<='} = $dtf->$method( $to );
282 return $self->search(
284 $timestamp_column_name => $conditions
291 my $object = Koha::Objects->search({}, { rows => 1 })->single
293 Returns one and only one object that is part of this set.
294 Returns undef if there are no objects found.
296 This is optimal as it will grab the first returned result without instantiating
300 http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Retrieve_one_and_only_one_row_from_a_resultset
307 my $single = $self->_resultset()->single;
308 return unless $single;
310 return $self->object_class()->_new_from_dbic($single);
313 =head3 Koha::Objects->next();
315 my $object = Koha::Objects->next();
317 Returns the next object that is part of this set.
318 Returns undef if there are no more objects to return.
325 my $result = $self->_resultset()->next();
326 return unless $result;
328 my $object = $self->object_class()->_new_from_dbic( $result );
333 =head3 Koha::Objects->last;
335 my $object = Koha::Objects->last;
337 Returns the last object that is part of this set.
338 Returns undef if there are no object to return.
345 my $count = $self->_resultset->count;
346 return unless $count;
348 my ( $result ) = $self->_resultset->slice($count - 1, $count - 1);
350 my $object = $self->object_class()->_new_from_dbic( $result );
357 my $empty_rs = Koha::Objects->new->empty;
359 Sets the resultset empty. This is handy for consistency on method returns
360 (e.g. if we know in advance we won't have results but want to keep returning
368 Koha::Exceptions::Object::NotInstantiated->throw(
373 $self = $self->search(\'0 = 1');
374 $self->_resultset()->set_cache([]);
379 =head3 Koha::Objects->reset();
381 Koha::Objects->reset();
383 resets iteration so the next call to next() will start agein
384 with the first object in a set.
391 $self->_resultset()->reset();
396 =head3 Koha::Objects->as_list();
398 Koha::Objects->as_list();
400 Returns an arrayref of the objects in this set.
407 my @dbic_rows = $self->_resultset()->all();
409 my @objects = $self->_wrap(@dbic_rows);
411 return wantarray ? @objects : \@objects;
414 =head3 Koha::Objects->unblessed
416 Returns an unblessed representation of objects.
423 return [ map { $_->unblessed } $self->as_list ];
426 =head3 Koha::Objects->get_column
428 Return all the values of this set for a given column
433 my ($self, $column_name) = @_;
434 return $self->_resultset->get_column( $column_name )->all;
437 =head3 Koha::Objects->TO_JSON
439 Returns an unblessed representation of objects, suitable for JSON output.
446 return [ map { $_->TO_JSON } $self->as_list ];
449 =head3 Koha::Objects->to_api
451 Returns a representation of the objects, suitable for API output .
456 my ($self, $params) = @_;
458 return [ map { $_->to_api($params) } $self->as_list ];
461 =head3 attributes_from_api
463 my $attributes = $objects->attributes_from_api( $api_attributes );
465 Translates attributes from the API to DBIC
469 sub attributes_from_api {
470 my ( $self, $attributes ) = @_;
472 $self->{_singular_object} ||= $self->object_class->new();
473 return $self->{_singular_object}->attributes_from_api( $attributes );
476 =head3 from_api_mapping
478 my $mapped_attributes_hash = $objects->from_api_mapping;
480 Attributes map from the API to DBIC
484 sub from_api_mapping {
487 $self->{_singular_object} ||= $self->object_class->new();
488 return $self->{_singular_object}->from_api_mapping;
491 =head3 prefetch_whitelist
493 my $whitelist = $object->prefetch_whitelist()
495 Returns a hash of prefetchable subs and the type it returns
499 sub prefetch_whitelist {
502 $self->{_singular_object} ||= $self->object_class->new();
504 $self->{_singular_object}->prefetch_whitelist;
507 =head3 Koha::Objects->_wrap
509 wraps the DBIC object in a corresponding Koha object
514 my ( $self, @dbic_rows ) = @_;
516 my @objects = map { $self->object_class->_new_from_dbic( $_ ) } @dbic_rows;
521 =head3 Koha::Objects->_resultset
523 Returns the internal resultset or creates it if undefined
531 $self->{_resultset} ||=
532 Koha::Database->new()->schema()->resultset( $self->_type() );
534 return $self->{_resultset};
537 return Koha::Database->new()->schema()->resultset( $self->_type() );
541 sub _get_objects_class {
545 if( $type->can('koha_objects_class') ) {
546 return $type->koha_objects_class;
548 $type =~ s|Schema::Result::||;
554 my @columns = Koha::Objects->columns
556 Return the table columns
562 return Koha::Database->new->schema->resultset( $class->_type )->result_source->columns;
567 The autoload method is used call DBIx::Class method on a resultset.
569 Important: If you plan to use one of the DBIx::Class methods you must provide
570 relevant tests in t/db_dependent/Koha/Objects.t
571 Currently count, is_paged, pager, result_class, single and slice are covered.
576 my ( $self, @params ) = @_;
578 my @known_methods = qw( count is_paged pager result_class single slice );
579 my $method = our $AUTOLOAD;
583 unless ( grep { $_ eq $method } @known_methods ) {
584 my $class = ref($self) ? ref($self) : $self;
585 Koha::Exceptions::Object::MethodNotCoveredByTests->throw(
586 error => sprintf("The method %s->%s is not covered by tests!", $class, $method),
591 my $r = eval { $self->_resultset->$method(@params) };
593 carp "No method $method found for " . ref($self) . " " . $@;
601 The _type method must be set for all child classes.
602 The value returned by it should be the DBIC resultset name.
603 For example, for holds, _type should return 'Reserve'.
611 This method must be set for all child classes.
612 The value returned by it should be the name of the Koha
613 object class that is returned by this class.
614 For example, for holds, object_class should return 'Koha::Hold'.
624 Kyle M Hall <kyle@bywatersolutions.com>