Attachment #171807 for bug #37969

View | Details | Raw Unified | Return to bug 37969
Collapse All | Expand All




use Modern::Perl;
use Koha::Installer::Output qw(say_warning say_failure say_success say_info);

return {
    bug_number  => "37969",
    description => "Add nor language code",
    up          => sub {
        my ($args) = @_;
        my ( $dbh, $out ) = @$args{qw(dbh out)};

        $dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'nb', 'language', 'no', 'Norsk bokmål'); });
        $dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'nn', 'language', 'no', 'Norsk nynorsk'); });
        $dbh->do(q{ INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'no', 'language', 'Norwegian','2024-09-19' ); });
        $dbh->do(q{ INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'no','nor'); });
        $dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'no', 'language', 'nb', 'Norsk'); });
        $dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'no', 'language', 'nn', 'Norsk'); });
        $dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'no', 'language', 'no', 'Norsk'); });
        $dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'no', 'language', 'en', 'Norwegian'); });
        $dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'no', 'language', 'fr', 'Norvégien'); });
        $dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'no', 'language', 'de', 'Norwegisch'); });
        $dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'no', 'language', 'pl', 'Norweski'); });
        $dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'NO', 'region', 'no', 'Noreg'); });

        say $out "Added nor language code";
    },
};

Lines 957-962 VALUES ( 'nb','nob'); Link Here

(-)a/installer/data/mysql/mandatory/subtag_registry.sql (-1 / +37 lines)
957	INSERT INTO language_descriptions(subtag, type, lang, description)	957	INSERT INTO language_descriptions(subtag, type, lang, description)
958	VALUES ( 'nb', 'language', 'nb', 'Norsk bokmål');	958	VALUES ( 'nb', 'language', 'nb', 'Norsk bokmål');
959		959
		960	INSERT INTO language_descriptions(subtag, type, lang, description)
		961	VALUES ( 'nb', 'language', 'no', 'Norsk bokmål');
		962
960	INSERT INTO language_descriptions(subtag, type, lang, description)	963	INSERT INTO language_descriptions(subtag, type, lang, description)
961	VALUES ( 'nb', 'language', 'en', 'Norwegian bokmål');	964	VALUES ( 'nb', 'language', 'en', 'Norwegian bokmål');
962		965
Lines 1023-1028 VALUES ( 'nn', 'language', 'nb', 'Norsk nynorsk'); Link Here
1023	INSERT INTO language_descriptions(subtag, type, lang, description)	1026	INSERT INTO language_descriptions(subtag, type, lang, description)
1024	VALUES ( 'nn', 'language', 'nn', 'Norsk nynorsk');	1027	VALUES ( 'nn', 'language', 'nn', 'Norsk nynorsk');
1025		1028
		1029	INSERT INTO language_descriptions(subtag, type, lang, description)
		1030	VALUES ( 'nn', 'language', 'no', 'Norsk nynorsk');
		1031
1026	INSERT INTO language_descriptions(subtag, type, lang, description)	1032	INSERT INTO language_descriptions(subtag, type, lang, description)
1027	VALUES ( 'nn', 'language', 'en', 'Norwegian nynorsk');	1033	VALUES ( 'nn', 'language', 'en', 'Norwegian nynorsk');
1028		1034
Lines 1035-1040 VALUES ( 'nn', 'language', 'de', 'Norwegisch nynorsk'); Link Here
1035	INSERT INTO language_descriptions(subtag, type, lang, description)	1041	INSERT INTO language_descriptions(subtag, type, lang, description)
1036	VALUES ( 'nn', 'language', 'pl', 'Norweski nynorsk');	1042	VALUES ( 'nn', 'language', 'pl', 'Norweski nynorsk');
1037		1043
		1044	-- Norwegian (inclusive)
		1045	INSERT INTO language_subtag_registry( subtag, type, description, added)
		1046	VALUES ( 'no', 'language', 'Norwegian','2024-09-19' );
		1047
		1048	INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
		1049	VALUES ( 'no','nor');
		1050
		1051	INSERT INTO language_descriptions(subtag, type, lang, description)
		1052	VALUES ( 'no', 'language', 'nb', 'Norsk');
		1053
		1054	INSERT INTO language_descriptions(subtag, type, lang, description)
		1055	VALUES ( 'no', 'language', 'nn', 'Norsk');
		1056
		1057	INSERT INTO language_descriptions(subtag, type, lang, description)
		1058	VALUES ( 'no', 'language', 'no', 'Norsk');
		1059
		1060	INSERT INTO language_descriptions(subtag, type, lang, description)
		1061	VALUES ( 'no', 'language', 'en', 'Norwegian');
		1062
		1063	INSERT INTO language_descriptions(subtag, type, lang, description)
		1064	VALUES ( 'no', 'language', 'fr', 'Norvégien');
		1065
		1066	INSERT INTO language_descriptions(subtag, type, lang, description)
		1067	VALUES ( 'no', 'language', 'de', 'Norwegisch');
		1068
		1069	INSERT INTO language_descriptions(subtag, type, lang, description)
		1070	VALUES ( 'no', 'language', 'pl', 'Norweski');
		1071
1038	-- Punjabi	1072	-- Punjabi
1039	INSERT INTO language_subtag_registry( subtag, type, description, added)	1073	INSERT INTO language_subtag_registry( subtag, type, description, added)
1040	VALUES ( 'pa', 'language', 'Punjabi', '2017-04-21');	1074	VALUES ( 'pa', 'language', 'Punjabi', '2017-04-21');
Lines 2238-2243 VALUES ( 'NO', 'region', 'ne', 'Noreg'); Link Here
2238	INSERT INTO language_descriptions(subtag, type, lang, description)	2272	INSERT INTO language_descriptions(subtag, type, lang, description)
2239	VALUES ( 'NO', 'region', 'nn', 'Noreg');	2273	VALUES ( 'NO', 'region', 'nn', 'Noreg');
2240		2274
		2275	INSERT INTO language_descriptions(subtag, type, lang, description)
		2276	VALUES ( 'NO', 'region', 'no', 'Noreg');
		2277
2241	-- New Zealand	2278	-- New Zealand
2242	INSERT INTO language_subtag_registry( subtag, type, description, added)	2279	INSERT INTO language_subtag_registry( subtag, type, description, added)
2243	VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');	2280	VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
2244	-

Return to bug 37969

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_37969_add_missing_language_code_nor.pl (+26 lines)
	1	use Modern::Perl;
	2	use Koha::Installer::Output qw(say_warning say_failure say_success say_info);
	3
	4	return {
	5	bug_number => "37969",
	6	description => "Add nor language code",
	7	up => sub {
	8	my ($args) = @_;
	9	my ( $dbh, $out ) = @$args{qw(dbh out)};
	10
	11	$dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'nb', 'language', 'no', 'Norsk bokmål'); });
	12	$dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'nn', 'language', 'no', 'Norsk nynorsk'); });
	13	$dbh->do(q{ INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'no', 'language', 'Norwegian','2024-09-19' ); });
	14	$dbh->do(q{ INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'no','nor'); });
	15	$dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'no', 'language', 'nb', 'Norsk'); });
	16	$dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'no', 'language', 'nn', 'Norsk'); });
	17	$dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'no', 'language', 'no', 'Norsk'); });
	18	$dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'no', 'language', 'en', 'Norwegian'); });
	19	$dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'no', 'language', 'fr', 'Norvégien'); });
	20	$dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'no', 'language', 'de', 'Norwegisch'); });
	21	$dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'no', 'language', 'pl', 'Norweski'); });
	22	$dbh->do(q{ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'NO', 'region', 'no', 'Noreg'); });
	23
	24	say $out "Added nor language code";
	25	},
	26	};