t/db_dependent/Serials/Frequency.t

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