t/db_dependent/Koha/Suggestions.t

   1 #!/usr/bin/perl
   2
   3 # Copyright 2015 Koha Development team
   4 #
   5 # This file is part of Koha
   6 #
   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.
  11 #
  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.
  16 #
  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>.
  19
  20 use Modern::Perl;
  21
  22 use Test::More tests => 5;
  23
  24 use Koha::Suggestion;
  25 use Koha::Suggestions;
  26 use Koha::Database;
  27 use Koha::DateUtils;
  28
  29 use t::lib::TestBuilder;
  30
  31 my $schema = Koha::Database->new->schema;
  32 $schema->storage->txn_begin;
  33
  34 my $builder           = t::lib::TestBuilder->new;
  35 my $biblio_1          = $builder->build( { source => 'Biblio' } );
  36 my $biblio_2          = $builder->build( { source => 'Biblio' } );
  37 my $patron            = $builder->build( { source => 'Borrower' } );
  38 my $nb_of_suggestions = Koha::Suggestions->search->count;
  39 my $new_suggestion_1  = Koha::Suggestion->new(
  40     {   suggestedby  => $patron->{borrowernumber},
  41         biblionumber => $biblio_1->{biblionumber},
  42     }
  43 )->store;
  44 my $new_suggestion_2 = Koha::Suggestion->new(
  45     {   suggestedby  => $patron->{borrowernumber},
  46         biblionumber => $biblio_2->{biblionumber},
  47     }
  48 )->store;
  49
  50 subtest 'store' => sub {
  51     plan tests => 3;
  52     my $suggestion  = Koha::Suggestion->new(
  53         {   suggestedby  => $patron->{borrowernumber},
  54             biblionumber => $biblio_1->{biblionumber},
  55         }
  56     )->store;
  57
  58     is( $suggestion->suggesteddate, dt_from_string()->ymd, "If suggesteddate not passed in, it will default to today" );
  59     my $two_days_ago = dt_from_string->subtract( days => 2 );
  60     my $two_days_ago_sql = output_pref({dt => $two_days_ago, dateformat => 'sql', dateonly => 1 });
  61     $suggestion->suggesteddate($two_days_ago)->store;
  62     $suggestion = Koha::Suggestions->find( $suggestion->suggestionid );
  63     is( $suggestion->suggesteddate, $two_days_ago_sql, 'If suggesteddate passed in, it should be taken into account' );
  64     $suggestion->reason('because!')->store;
  65     $suggestion = Koha::Suggestions->find( $suggestion->suggestionid );
  66     is( $suggestion->suggesteddate, $two_days_ago_sql, 'If suggestion id modified, suggesteddate should not be modified' );
  67     $suggestion->delete;
  68 };
  69
  70 like( $new_suggestion_1->suggestionid, qr|^\d+$|, 'Adding a new suggestion should have set the suggestionid' );
  71 is( Koha::Suggestions->search->count, $nb_of_suggestions + 2, 'The 2 suggestions should have been added' );
  72
  73 my $retrieved_suggestion_1 = Koha::Suggestions->find( $new_suggestion_1->suggestionid );
  74 is( $retrieved_suggestion_1->biblionumber, $new_suggestion_1->biblionumber, 'Find a suggestion by id should return the correct suggestion' );
  75
  76 $retrieved_suggestion_1->delete;
  77 is( Koha::Suggestions->search->count, $nb_of_suggestions + 1, 'Delete should have deleted the suggestion' );
  78
  79 $schema->storage->txn_rollback;
  80