[Mapbender-commits] r8032 -
trunk/mapbender/resources/db/pgsql/UTF-8/update
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Fri Jul 29 08:43:29 EDT 2011
Author: astrid_emde
Date: 2011-07-29 05:43:29 -0700 (Fri, 29 Jul 2011)
New Revision: 8032
Modified:
trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
Log:
update of gettext function and french translations with '
Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql 2011-07-29 10:47:36 UTC (rev 8031)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql 2011-07-29 12:43:29 UTC (rev 8032)
@@ -1 +1,53 @@
-- 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';
More information about the Mapbender_commits
mailing list