Revert "Bug 10606: Remove MySQLism in GetUpcomingDueIssues"
[koha.git] / xt / sample_notices.t
blob083b39adeb9bdef811fa94925f4cebb8024e2df1
1 #!/usr/bin/perl
3 # Copyright (C) 2014 Tamil s.a.r.l.
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>.
20 use Modern::Perl;
21 use Test::More qw(no_plan);
24 my $root_dir = 'installer/data/mysql';
25 my $base_notices_file = "en/mandatory/sample_notices.sql";
26 my @trans_notices_files = qw(
27 fr-FR/1-Obligatoire/sample_notices.sql
28 de-DE/mandatory/sample_notices.sql
29 es-ES/mandatory/sample_notices.sql
30 it-IT/necessari/notices.sql
31 nb-NO/1-Obligatorisk/sample_notices.sql
32 pl-PL/mandatory/sample_notices.sql
33 ru-RU/mandatory/sample_notices.sql
34 uk-UA/mandatory/sample_notices.sql
37 ok(
38 open( my $ref_fh, "<", "$root_dir/$base_notices_file" ),
39 "Open reference sample notices file $root_dir/$base_notices_file" );
40 my $ref_notice = get_notices_from_file( $ref_fh );
41 my @ref_notices = sort { lc $a cmp lc $b } keys %$ref_notice;
42 cmp_ok(
43 $#ref_notices, '>=', 0,
44 "Found " . ($#ref_notices + 1) . " sample notices" );
46 foreach my $file_name ( @trans_notices_files ) {
47 compare_notices( $file_name );
52 # Get sample notices from SQL file populating letters table with INSERT
53 # statement.
55 sub get_notices_from_file {
56 my $fh = shift;
57 my %notice;
58 while ( <$fh> ) {
59 next unless /, *'([\_A-Z_]*)'/;
60 $notice{$1} = 1;
62 return \%notice;
66 sub compare_notices {
67 my $trans_file = shift;
68 ok(
69 open( my $trans_fh,"<", "$root_dir/$trans_file" ),
70 "Open translated sample notices file $root_dir/$trans_file" );
71 my $trans_notice = get_notices_from_file( $trans_fh );
72 use YAML;
73 my @trans_notices = sort { lc $a cmp lc $b } keys %$trans_notice;
74 cmp_ok(
75 $#trans_notices, '>=', 0,
76 "Found " . ($#trans_notices + 1) . " notices" );
77 my @to_add_notices;
78 foreach ( @ref_notices ) {
79 push @to_add_notices, $_ if ! $trans_notice->{$_};
81 if ( $#to_add_notices >= 0 ) {
82 fail( 'No sample notice to add') or diag( "Sample notices to add in $trans_file: " . join(', ', @to_add_notices ) );
84 else {
85 pass( 'No sample notice to add' );
88 my @to_delete_notices;
89 foreach ( @trans_notices ) {
90 push @to_delete_notices, $_ if ! $ref_notice->{$_};
92 if ( $#to_delete_notices >= 0 ) {
93 fail( 'No sample notice to delete' );
94 diag( "Sample notices to delete in $trans_file: " . join(', ', @to_delete_notices ) );
95 diag( 'Warning: Some of those sample notices may rather have to be added to English notice' );
97 else {
98 pass( 'No sample notices to delete' );
103 =head1 NAME
105 sample_notices.t
107 =head1 DESCRIPTION
109 This test identifies incoherences between translated sample notices and the
110 'en' reference file.
112 Koha sample notices are loaded to 'letter' table from a text SQL file
113 during Koha installation by web installer. The reference file is the one
114 provided for English (en) installation :
116 <koha_root>/installer/data/mysql/en/mandatory/sample_notices.sql
118 Alternatives files are provided for other languages. Those files are difficult
119 to keep synchronized with reference file. This could be an functional issue
120 since some Koha operation depend on notice existence, for example Print Slip in
121 Circulation.
123 =head1 USAGE
125 prove -v sample_notices.t
126 prove sample_notices.t
128 =cut