3 # Copyright (C) 2009 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 under the
8 # terms of the GNU General Public License as published by the Free Software
9 # Foundation; either version 2 of the License, or (at your option) any later
12 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License along
17 # with Koha; if not, write to the Free Software Foundation, Inc.,
18 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
23 use Test
::More
qw(no_plan);
27 my $root_dir = 'installer/data/mysql';
28 my $base_syspref_file = "en/mandatory/sysprefs.sql";
29 my @trans_syspref_files = qw(
30 de-DE/mandatory/sysprefs.sql
31 it-IT/necessari/sysprefs.sql
32 fr-FR/1-Obligatoire/unimarc_standard_systemprefs.sql
33 uk-UA/mandatory/system_preferences_full_optimal_for_install_only.sql
34 ru-RU/mandatory/system_preferences_full_optimal_for_install_only.sql
35 pl-PL/mandatory/sysprefs.sql
39 open( my $ref_fh, "<$root_dir/$base_syspref_file" ),
40 "Open reference syspref file $root_dir/$base_syspref_file" );
41 my $ref_syspref = get_syspref_from_file
( $ref_fh );
42 my @ref_sysprefs = sort { lc $a cmp lc $b } keys %$ref_syspref;
44 $#ref_sysprefs, '>=', 0,
45 "Found " . ($#ref_sysprefs + 1) . " sysprefs" );
47 foreach my $file_name ( @trans_syspref_files ) {
48 compare_syspref
( $file_name );
53 # Get sysprefs from SQL file populating sysprefs table with INSERT statement.
56 # INSERT INTO `systempreferences` (variable,value,explanation,options,type)
57 # VALUES('AmazonLocale','US','Use to set the Locale of your Amazon.com Web Services',
58 # 'US|CA|DE|FR|JP|UK','Choice')
60 sub get_syspref_from_file
{
64 next if /^--/; # Comment line
65 #/VALUES.*\(\'([\w\-:]+)\'/;
68 next unless $variable;
69 # lowercase syspref - at present, systempreference lookup is not case-sensitive
70 $variable = lc $variable;
71 $syspref{$variable} = 1;
78 my $trans_file = shift;
80 open( my $trans_fh, "<$root_dir/$trans_file" ),
81 "Open translated sysprefs file $root_dir/$trans_file" );
82 my $trans_syspref = get_syspref_from_file
( $trans_fh );
83 my @trans_sysprefs = sort { lc $a cmp lc $b } keys %$trans_syspref;
85 $#trans_sysprefs, '>=', 0,
86 "Found " . ($#trans_sysprefs + 1) . " sysprefs" );
89 foreach ( @ref_sysprefs ) {
90 push @to_add_sysprefs, $_ if ! $trans_syspref->{$_};
92 if ( $#to_add_sysprefs >= 0 ) {
93 fail
( 'No syspref to add') or diag
( "Sysprefs to add in $trans_file: " . join(', ', @to_add_sysprefs ) );
96 pass
( 'No syspref to add' );
99 my @to_delete_sysprefs;
100 foreach ( @trans_sysprefs ) {
101 push @to_delete_sysprefs, $_ if ! $ref_syspref->{$_};
103 if ( $#to_delete_sysprefs >= 0 ) {
104 fail
( 'No syspref to delete' );
105 diag
( "Sysprefs to delete in $trans_file: " . join(', ', @to_delete_sysprefs ) );
106 diag
( 'Warning: Some of those sysprefs may rather have to be added to English sysprefs' );
109 pass
( 'No syspref to delete' );
120 This test identifies incoherences between translated sysprefs files
121 and the reference file.
123 Koha sysprefs are loaded to sypref table from a text SQL file during
124 Koha installation by web installer. The reference file is the one
125 provided for English (en) installation :
127 <koha_root>/installer/data/mysql/en/mandatory/sysprefs.sql
129 Alternatives files are provided for other languages. Those files
130 are difficult to keep syncrhonized with reference file.