Attachment 128094 Details for Bug 29596 – Bug 29596: Add Yiddish language

[patch] Bug 29596: Add Yiddish language

Bug-29596-Add-Yiddish-language.patch (text/plain), 3.36 KB, created by Tomás Cohen Arazi (tcohen) on 2021-11-29 21:37:36 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tomás Cohen Arazi (tcohen)

Created: 2021-11-29 21:37:36 UTC

Size: 3.36 KB

patch

obsolete

>From 902c670850394dd2bb74736039e9cd68f248456c Mon Sep 17 00:00:00 2001
>From: Tomas Cohen Arazi <tomascohen@theke.io>
>Date: Mon, 29 Nov 2021 18:35:46 -0300
>Subject: [PATCH] Bug 29596: Add Yiddish language
>MIME-Version: 1.0
>Content-Type: text/plain; charset=UTF-8
>Content-Transfer-Encoding: 8bit
>
>This patch adds the Yiddish language to Koha. The language codes were
>taken from https://www.loc.gov/standards/iso639-2/php/code_list.php
>
>Sponsored-by: Universidad Nacional de San MartÃn
>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
>---
> .../data/mysql/atomicupdate/bug_29596.pl      | 41 +++++++++++++++++++
> .../data/mysql/mandatory/subtag_registry.sql  | 20 +++++++++
> 2 files changed, 61 insertions(+)
> create mode 100755 installer/data/mysql/atomicupdate/bug_29596.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_29596.pl b/installer/data/mysql/atomicupdate/bug_29596.pl
>new file mode 100755
>index 0000000000..29178bd1d9
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_29596.pl
>@@ -0,0 +1,41 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number  => "29596",
>+    description => "Add Yiddish language",
>+    up => sub {
>+        my ($args) = @_;
>+        my ($dbh, $out) = @$args{qw(dbh)};
>+
>+
>+        $dbh->do(q{
>+            INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added)
>+            VALUES ( 'yi', 'language', 'Yiddish', NOW() );
>+        });
>+
>+        $dbh->do(q{
>+            INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+            VALUES ( 'yi','yid');
>+        });
>+
>+        $dbh->do(q{
>+            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
>+            VALUES ( 'yi', 'language', 'es', 'Yidis');
>+        });
>+
>+        $dbh->do(q{
>+            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
>+            VALUES ( 'yi', 'language', 'en', 'Yiddish');
>+        });
>+
>+        $dbh->do(q{
>+            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
>+            VALUES ( 'yi', 'language', 'fr', 'Yiddish');
>+        });
>+
>+        $dbh->do(q{
>+            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
>+            VALUES ( 'yi', 'language', 'de', 'Jiddisch');
>+        });
>+    },
>+}
>diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql
>index 08761d9256..6ad9b899c6 100644
>--- a/installer/data/mysql/mandatory/subtag_registry.sql
>+++ b/installer/data/mysql/mandatory/subtag_registry.sql
>@@ -1874,3 +1874,23 @@ VALUES ('ik', 'language', 'Inupiaq', now());
> 
> INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
> VALUES ('ik', 'ipk');
>+
>+-- Yiddish
>+
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'yi', 'language', 'Yiddish', NOW() );
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'yi','yid');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'yi', 'language', 'es', 'Yidis');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'yi', 'language', 'en', 'Yiddish');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'yi', 'language', 'fr', 'Yiddish');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'yi', 'language', 'de', 'Jiddisch');
>-- 
>2.34.1

Actions: View | Diff | Splinter Review

Attachments on bug 29596: 128094 | 128097 | 128104 | 128106 | 129974