[Mapbender-commits] r8036 - branches/2.7/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2011-07-29 06:04:50 -0700 (Fri, 29 Jul 2011)
New Revision: 8036

Modified:
   branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
Log:
change due to french translation

Modified: branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
===================================================================
--- branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2011-07-29 13:04:30 UTC (rev 8035)
+++ branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2011-07-29 13:04:50 UTC (rev 8036)
@@ -1 +1,52 @@
--- new file for db changes to 2.7.3
+-- new file for db changes to 2.7.3-- new file for db changes to 2.7.3
+
+-- replace gettext to handle ' in french translation
+DROP FUNCTION gettext(text, text);
+CREATE OR REPLACE FUNCTION gettext(locale_arg text, string text)
+  RETURNS character varying AS
+$BODY$
+ DECLARE
+    msgstr varchar(512);
+    trl RECORD;
+ BEGIN
+    -- RAISE NOTICE '>%<', locale_arg;
+
+    SELECT INTO trl * FROM translations
+    WHERE trim(from locale) = trim(from locale_arg) AND msgid = string;
+    -- we return the original string, if no translation is found.
+    -- this is consistent with gettext's behaviour
+    IF NOT FOUND THEN
+        RETURN string;
+    ELSE
+	--RAISE NOTICE '>%<', trl.msgstr;
+	msgstr := replace(trl.msgstr,'''','`');
+        RETURN msgstr;
+    END IF;
+ END;
+ $BODY$
+  LANGUAGE 'plpgsql' VOLATILE;
+
+--
+-- update for franch translation to handle '
+--
+-- 360
+UPDATE translations set msgstr = 'Sauvegarder la vue/l''espace de travail en tant que Web Map Context'
+where locale = 'fr' and msgid = 'Save workspace as web map context document';
+
+--379
+UPDATE translations set msgstr = 'Carte de''aperçu'
+where locale = 'fr' and msgid = 'Overview';
+
+-- 383
+UPDATE translations set msgstr = 'Sélection de l''échelle'
+where locale = 'fr' and msgid = 'Scale Select';
+
+
+-- 384
+UPDATE translations set msgstr = 'Texte de l''échelle'
+where locale = 'fr' and msgid = 'Scale Text';
+
+
+--386
+UPDATE translations set msgstr = 'Sélectionner la carte d''arrière-plan'
+where locale = 'fr' and msgid = 'Set Background';