t/db_dependent/Serials/Frequency.t

   1 #!/usr/bin/perl
   2
   3 use C4::Context;
   4 use Koha::Database;
   5 use Test::More tests => 27;
   6 use Modern::Perl;
   7
   8 my $schema = Koha::Database->new->schema;
   9 $schema->storage->txn_begin;
  10 my $dbh = C4::Context->dbh;
  11
  12 use C4::Serials::Frequency;
  13
  14 # Start by deleting all frequencies.
  15 my @frequencies = GetSubscriptionFrequencies();
  16 foreach my $f (@frequencies) {
  17     DelSubscriptionFrequency($f->{id});
  18 }
  19
  20 @frequencies = GetSubscriptionFrequencies();
  21 is(scalar @frequencies, 0, "There is no frequencies in database");
  22
  23 my $frequency = GetSubscriptionFrequency(1);
  24 is($frequency, undef, "GetSubscriptionFrequency(1) returns undef");
  25
  26 my $rv = ModSubscriptionFrequency($frequency);
  27 is($rv, undef, "ModSubscriptionFrequency(undef) returns undef");
  28 $frequency = {};
  29 $rv = ModSubscriptionFrequency($frequency);
  30 is($rv, undef, "ModSubscriptionFrequency({}) returns undef");
  31 # returns 0 because id doesn't exist
  32 $frequency = { id => 1, description => "Test frequency 1" };
  33 $rv = ModSubscriptionFrequency($frequency);
  34 is($rv, '0E0', "ModSubscriptionFrequency({id=1,description=>'Test frequency 1'}) returns '0 but true'");
  35
  36 $frequency = undef;
  37 my $id = AddSubscriptionFrequency($frequency);
  38 is($id, undef, "AddSubscriptionFrequency(undef) returns undef");
  39 $frequency = {};
  40 $id = AddSubscriptionFrequency($frequency);
  41 is($id, undef, "AddSubscriptionFrequency({}) returns undef");
  42 $frequency = { description => "Test frequency 1" };
  43 $id = AddSubscriptionFrequency($frequency);
  44 ok((defined($id) && ($id > 0)), "AddSubscriptionFrequency({description => 'Test frequency 1'}) returns frequency id");
  45
  46 $frequency = GetSubscriptionFrequency($id);
  47 isa_ok($frequency, 'HASH', "GetSubscriptionFrequency($id)");
  48 is($frequency->{description}, "Test frequency 1", "description OK");
  49 is($frequency->{unit}, undef, "unit OK");
  50 is($frequency->{issuesperunit}, 1, "issuesperunit OK");
  51 is($frequency->{unitsperissue}, 1, "unitsperissue OK");
  52 is($frequency->{expectedissuesayear}, undef, "expectedissuesayear OK");
  53 is($frequency->{displayorder}, undef, "displayorder OK");
  54
  55 $frequency->{description} = $frequency->{description} . " (modified)";
  56 $frequency->{unit} = 'day';
  57 $frequency->{unitsperissue} = 3;
  58 $frequency->{displayorder} = 1;
  59 $rv = ModSubscriptionFrequency($frequency);
  60 is($rv, 1, "ModSubscriptionFrequency(\$frequency) returns 1");
  61
  62 $frequency = GetSubscriptionFrequency($id);
  63 isa_ok($frequency, 'HASH', "GetSubscriptionFrequency($id)");
  64 is($frequency->{description}, "Test frequency 1 (modified)", "description OK");
  65 is($frequency->{unit}, 'day', "unit OK");
  66 is($frequency->{issuesperunit}, 1, "issuesperunit OK");
  67 is($frequency->{unitsperissue}, 3, "unitsperissue OK");
  68 is($frequency->{expectedissuesayear}, undef, "expectedissuesayear OK");
  69 is($frequency->{displayorder}, 1, "displayorder OK");
  70
  71 @frequencies = GetSubscriptionFrequencies();
  72 is(scalar @frequencies, 1, "There is one frequency");
  73
  74 # Add another frequency
  75 undef $frequency->{id};
  76 my $id2 = AddSubscriptionFrequency($frequency);
  77
  78 @frequencies = GetSubscriptionFrequencies();
  79 is(scalar @frequencies, 2, "There are two frequencies");
  80
  81 # Delete one frequency
  82 DelSubscriptionFrequency($id);
  83 @frequencies = GetSubscriptionFrequencies();
  84 is(scalar @frequencies, 1, "There is one frequency");
  85
  86 # Delete the other frequency
  87 DelSubscriptionFrequency($id2);
  88 @frequencies = GetSubscriptionFrequencies();
  89 is(scalar @frequencies, 0, "There is no frequency");