From e010ec4b2df385a765314a7a917e3c2ed66ba3b1 Mon Sep 17 00:00:00 2001 From: Nicolas Hunstein Date: Thu, 12 Sep 2024 13:01:28 +0000 Subject: [PATCH] Bug 36833: Added German translations for new languages Content-Type: text/plain; charset=utf-8 To test: -Apply patch -Run database update -Install German language -Activate German translations in system preferences -Go to advance search -Check language pull down shows translations for languages included in this patch Signed-off-by: William Lavoie Signed-off-by: Marcel de Rooy --- .../data/mysql/atomicupdate/bug_36833.pl | 185 ++++++++++++++++++ .../data/mysql/mandatory/subtag_registry.sql | 69 +++++++ 2 files changed, 254 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_36833.pl diff --git a/installer/data/mysql/atomicupdate/bug_36833.pl b/installer/data/mysql/atomicupdate/bug_36833.pl new file mode 100755 index 0000000000..12d6067c2d --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_36833.pl @@ -0,0 +1,185 @@ +use Modern::Perl; +use Koha::Installer::Output qw(say_warning say_failure say_success say_info); + +return { + bug_number => "36833", + description => "Add German translations for new languages", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + # Do you stuffs here + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'kl', 'language', 'de', 'Grönländisch'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'kn', 'language', 'de', 'Kannada'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'krl', 'language', 'de', 'Karelisch'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'kw', 'language', 'de', 'Kornisch'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'my', 'language', 'de', 'Burmesisch'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'pa', 'language', 'de', 'Panjabi'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'ps', 'language', 'de', 'Paschtu'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES( 'rmf', 'language', 'de', 'Finnisch Kalo'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sia', 'language', 'de', 'Akkalasamisch'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sjd', 'language', 'de', 'Kildinsamisch'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sjt', 'language', 'de', 'Tersamisch'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sje', 'language', 'de', 'Pitesamisch'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sjk', 'language', 'de', 'Kemisamisch'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sju', 'language', 'de', 'Umesamisch'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sma', 'language', 'de', 'Südsamisch'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sme', 'language', 'de', 'Nordsamisch'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'smi', 'language', 'de', 'Samische Sprachen'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'smj', 'language', 'de', 'Lulesamisch'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'smn', 'language', 'de', 'Inarisamisch'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sms', 'language', 'de', 'Skoltsamisch'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'so', 'language', 'de', 'Somali'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'st', 'language', 'de', 'Sotho'); +} + ); + + $dbh->do( + q{ + INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'vot', 'language', 'de', 'Wotisch'); +} + ); + + say_success( $out, "Added German translations for new languages" ); + + $dbh->do( + q{ + UPDATE language_descriptions +SET description = 'Latein' +WHERE subtag = 'la' AND type = 'language' AND lang = 'de'; +} + ); + + say_success( $out, "Updated German translation for Latin" ); + }, +}; diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql index 9c3b460dae..aba10ebb43 100644 --- a/installer/data/mysql/mandatory/subtag_registry.sql +++ b/installer/data/mysql/mandatory/subtag_registry.sql @@ -706,6 +706,9 @@ VALUES ( 'kl', 'language', 'en', 'Greenlandic'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kl', 'language', 'kl', 'Kalaallisut'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'kl', 'language', 'de', 'Grönländisch'); + -- Kannada INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'kn', 'language', 'Kannada','2014-10-30'); @@ -722,6 +725,9 @@ VALUES ( 'kn', 'language', 'en', 'Kannada'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kn', 'language', 'pl', 'Kannada'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'kn', 'language', 'de', 'Kannada'); + -- Khmer INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'km', 'language', 'Khmer','2014-10-30'); @@ -776,6 +782,9 @@ VALUES ( 'krl', 'language', 'en', 'Karelian'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'krl', 'language', 'krl', 'Karjala'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'krl', 'language', 'de', 'Karelisch'); + -- Kurdish INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ku', 'language', 'Kurdish','2014-05-13'); @@ -814,6 +823,9 @@ VALUES ( 'kw', 'language', 'en', 'Cornish'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'kw', 'language', 'kw', 'Kernowek'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'kw', 'language', 'de', 'Kornisch'); + -- Latin INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'la', 'language', 'Latin','2005-10-16' ); @@ -947,6 +959,9 @@ VALUES ( 'my', 'language', 'en', 'Burmese'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'my', 'language', 'my', 'မြန်မာစာ'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'my', 'language', 'de', 'Burmesisch'); + -- Norwegian (bokmål) INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' ); @@ -1082,6 +1097,9 @@ VALUES ( 'pa', 'language', 'en', 'Punjabi'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'pa', 'language', 'pa', 'پنجابی'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'pa', 'language', 'de', 'Panjabi'); + -- Pangwa INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'pbr', 'language', 'Pangwa','2014-10-30'); @@ -1146,6 +1164,9 @@ VALUES ( 'ps', 'language', 'en', 'Pashto'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ps', 'language', 'ps', 'پښتو'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'ps', 'language', 'de', 'Paschtu'); + -- Portuguese INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' ); @@ -1181,6 +1202,9 @@ VALUES( 'rmf', 'language', 'fi', 'Suomen romanikieli'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'rmf', 'language', 'rmf', 'Fíntika Rómma'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'rmf', 'language', 'de', 'Finnisch Kalo'); + -- Romanian INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ro', 'language', 'Romanian','2005-10-16' ); @@ -1314,6 +1338,9 @@ VALUES ( 'sia', 'language', 'en', 'Akkala Sami'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sia', 'language', 'sia', 'ču´kksuâlis'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sia', 'language', 'de', 'Akkalasamisch'); + -- Kildin Sami INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjd', 'language', 'Kildin Sami', '2017-04-21'); @@ -1327,6 +1354,9 @@ VALUES ( 'sjd', 'language', 'en', 'Kildin Sami'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjd', 'language', 'sjd', 'Кӣллт са̄мь кӣлл'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sjd', 'language', 'de', 'Kildinsamisch'); + -- Ter Sami INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjt', 'language', 'Ter Sami', '2017-04-21'); @@ -1340,6 +1370,9 @@ VALUES ( 'sjt', 'language', 'en', 'Ter Sami'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjt', 'language', 'sjt', 'saa´mekiill'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sjt', 'language', 'de', 'Tersamisch'); + -- Pite Sami INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sje', 'language', 'Pite Sami', '2017-04-21'); @@ -1353,6 +1386,9 @@ VALUES ( 'sje', 'language', 'en', 'Pite Sami'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sje', 'language', 'sje', 'Bidumsámegiella'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sje', 'language', 'de', 'Pitesamisch'); + -- Kemi Sami INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sjk', 'language', 'Kemi Sami', '2017-04-21'); @@ -1366,6 +1402,9 @@ VALUES ( 'sjk', 'language', 'en', 'Kemi Sami'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sjk', 'language', 'sjk', 'samääškiela'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sjk', 'language', 'de', 'Kemisamisch'); + -- Ume Sami INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sju', 'language', 'Ume Sami', '2017-04-21'); @@ -1379,6 +1418,9 @@ VALUES ( 'sju', 'language', 'en', 'Ume Sami'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sju', 'language', 'sju', 'Ubmejensámien giella'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sju', 'language', 'de', 'Umesamisch'); + -- Southern Sami INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sma', 'language', 'Southern Sami', '2017-04-21'); @@ -1392,6 +1434,9 @@ VALUES ( 'sma', 'language', 'en', 'Southern Sami'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sma', 'language', 'sma', 'Åarjelsaemien gïele'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sma', 'language', 'de', 'Südsamisch'); + -- Northern Sami INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sme', 'language', 'Northern Sami', '2017-04-21'); @@ -1411,6 +1456,9 @@ VALUES ( 'sme', 'language', 'sv', 'Nordsamiska'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sme', 'language', 'sme', 'davvisámegiella'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sme', 'language', 'de', 'Nordsamisch'); + -- Sami languages INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smi', 'language', 'Sami languages', '2017-04-21'); @@ -1430,6 +1478,9 @@ VALUES ( 'smi', 'language', 'sv', 'Samiska'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smi', 'language', 'smi', 'Saami'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'smi', 'language', 'de', 'Samische Sprachen'); + -- Lule Sami INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smj', 'language', 'Lule Sami', '2017-04-21'); @@ -1443,6 +1494,9 @@ VALUES ( 'smj', 'language', 'en', 'Lule Sami'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smj', 'language', 'smj', 'julevsámegiella'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'smj', 'language', 'de', 'Lulesamisch'); + -- Inari Sami INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'smn', 'language', 'Inari Sami', '2017-04-21'); @@ -1456,6 +1510,9 @@ VALUES ( 'smn', 'language', 'en', 'Inari Sami'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'smn', 'language', 'smn', 'anarâškielâ'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'smn', 'language', 'de', 'Inarisamisch'); + -- Skolt Sami INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sms', 'language', 'Skolt Sami', '2017-04-21'); @@ -1469,6 +1526,9 @@ VALUES ( 'sms', 'language', 'en', 'Skolt Sami'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sms', 'language', 'sms', 'sääʹmǩiõll'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'sms', 'language', 'de', 'Skoltsamisch'); + -- Somali INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'so', 'language', 'Somali', '2017-04-21'); @@ -1482,6 +1542,9 @@ VALUES ( 'so', 'language', 'en', 'Somali'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'so', 'language', 'so', 'Af-Soomaali'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'so', 'language', 'de', 'Somali'); + -- Albanian INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sq', 'language', 'Albanian','2014-10-30'); @@ -1536,6 +1599,9 @@ VALUES ( 'st', 'language', 'en', 'Sotho'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'st', 'language', 'st', 'Sesotho'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'st', 'language', 'de', 'Sotho'); + -- Swedish INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); @@ -1757,6 +1823,9 @@ VALUES ( 'vot', 'language', 'en', 'Votic'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vot', 'language', 'vot', 'vađđa ceeli'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'vot', 'language', 'de', 'Wotisch'); + -- Chinese INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'zh', 'language', 'Chinese','2005-10-16'); -- 2.39.5