Attachment 153754 Details for Bug 34328 – Bug 34328: Add Scottish Gaelic to languages

[patch] Bug 34328: Add Scottish Gaelic to languages

Bug-34328-Add-Scottish-Gaelic-to-languages.patch (text/plain), 3.76 KB, created by Marcel de Rooy on 2023-07-21 06:52:46 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2023-07-21 06:52:46 UTC

Size: 3.76 KB

patch

obsolete

>From 2fd951fa447c26d36b3a329f196fb5c510163107 Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Thu, 20 Jul 2023 16:31:40 +0100
>Subject: [PATCH] Bug 34328: Add Scottish Gaelic to languages
>Content-Type: text/plain; charset=utf-8
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>---
> .../data/mysql/atomicupdate/bug_34328.pl      | 46 +++++++++++++++++++
> .../data/mysql/mandatory/subtag_registry.sql  | 23 ++++++++++
> 2 files changed, 69 insertions(+)
> create mode 100755 installer/data/mysql/atomicupdate/bug_34328.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_34328.pl b/installer/data/mysql/atomicupdate/bug_34328.pl
>new file mode 100755
>index 0000000000..50794c67d1
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_34328.pl
>@@ -0,0 +1,46 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number  => "34328",
>+    description => "Add Scottish Gaelic to recognised languages",
>+    up          => sub {
>+        my ($args) = @_;
>+        my ( $dbh, $out ) = @$args{qw(dbh out)};
>+        $dbh->do(q{
>+            INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+            VALUES ( 'gd','gla' )
>+        });
>+
>+        $dbh->do(q{
>+            INSERT INTO language_subtag_registry( subtag, type, description, added)
>+            VALUES ( 'gd', 'language', 'Scottish Gaelic', NOW() )
>+        });
>+
>+        $dbh->do(q{
>+            INSERT INTO language_descriptions(subtag, type, lang, description)
>+            VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic')
>+        });
>+
>+        $dbh->do(q{
>+            INSERT INTO language_descriptions(subtag, type, lang, description)
>+            VALUES ( 'gd', 'language', 'gd', 'GÃ idhlig')
>+        });
>+
>+        $dbh->do(q{
>+            INSERT INTO language_descriptions(subtag, type, lang, description)
>+            VALUES ( 'gd', 'language', 'fr', 'GaÃ©lique Ã©cossais')
>+        });
>+
>+        $dbh->do(q{
>+            INSERT INTO language_descriptions(subtag, type, lang, description)
>+            VALUES ( 'gd', 'language', 'de', 'Schottisch-GÃ¤lisch')
>+        });
>+
>+        $dbh->do(q{
>+            INSERT INTO language_descriptions(subtag, type, lang, description)
>+            VALUES ( 'gd', 'language', 'pl', 'JÄzyk szkocki gaelicki')
>+        });
>+
>+        say $out "Added new language 'Scottish Gaelic'";
>+    },
>+};
>diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql
>index f0e2d33308..c27789b6d7 100644
>--- a/installer/data/mysql/mandatory/subtag_registry.sql
>+++ b/installer/data/mysql/mandatory/subtag_registry.sql
>@@ -425,6 +425,29 @@ VALUES ( 'fr', 'language', 'de', 'FranzÃ¶sisch');
> INSERT INTO language_descriptions(subtag, type, lang, description)
> VALUES ( 'fr', 'language', 'pl', 'Francuski');
> 
>+-- Scottish Gaelic
>+
>+INSERT INTO language_subtag_registry( subtag, type, description, added)
>+VALUES ( 'gd', 'language', 'Scottish Gaelic', NOW() );
>+
>+INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
>+VALUES ( 'gd','gla');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'gd', 'language', 'gd', 'GÃ idhlig');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'gd', 'language', 'fr', 'GaÃ©lique Ã©cossais');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'gd', 'language', 'de', 'Schottisch-GÃ¤lisch');
>+
>+INSERT INTO language_descriptions(subtag, type, lang, description)
>+VALUES ( 'gd', 'language', 'pl', 'JÄzyk szkocki gaelicki');
>+
> -- Galician
> INSERT INTO language_subtag_registry( subtag, type, description, added)
> VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 34328: 153728 | 153754 | 153755 | 156593 | 156594 | 156595 | 158371 | 158372 | 158373