Bugzilla – Attachment 171396 Details for
Bug 36833
Update German translations for new languages added
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 36833: Added German translations for new languages
Bug-36833-Added-German-translations-for-new-langua.patch (text/plain), 16.12 KB, created by
Katrin Fischer
on 2024-09-12 13:26:47 UTC
(
hide
)
Description:
Bug 36833: Added German translations for new languages
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2024-09-12 13:26:47 UTC
Size:
16.12 KB
patch
obsolete
>From e57425f25d13c1c964345d1bffc32b163bf2cb6d Mon Sep 17 00:00:00 2001 >From: Nicolas Hunstein <nicolas.hunstein@bsz-bw.de> >Date: Thu, 12 Sep 2024 13:01:28 +0000 >Subject: [PATCH] Bug 36833: Added German translations for new languages > >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 >--- > .../data/mysql/atomicupdate/bug_36833.pl | 186 ++++++++++++++++++ > .../data/mysql/mandatory/subtag_registry.sql | 69 +++++++ > 2 files changed, 255 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 00000000000..de239ab4d3c >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_36833.pl >@@ -0,0 +1,186 @@ >+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 40cf57d646c..dd494f051db 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' ); >@@ -1048,6 +1063,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'); >@@ -1112,6 +1130,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' ); >@@ -1147,6 +1168,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' ); >@@ -1280,6 +1304,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'); >@@ -1293,6 +1320,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'); >@@ -1306,6 +1336,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'); >@@ -1319,6 +1352,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'); >@@ -1332,6 +1368,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'); >@@ -1345,6 +1384,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'); >@@ -1358,6 +1400,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'); >@@ -1377,6 +1422,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'); >@@ -1396,6 +1444,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'); >@@ -1409,6 +1460,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'); >@@ -1422,6 +1476,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'); >@@ -1435,6 +1492,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'); >@@ -1448,6 +1508,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'); >@@ -1502,6 +1565,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' ); >@@ -1723,6 +1789,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.2
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 36833
:
171396
|
176459
|
179048