[Mapbender-commits] r8352 - branches/2.7/resources/db/pgsql/UTF-8/update trunk/mapbender/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2012-05-16 00:57:22 -0700 (Wed, 16 May 2012)
New Revision: 8352

Modified:
   branches/2.7/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
Log:
corrected sql

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	2012-05-14 13:13:12 UTC (rev 8351)
+++ branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2012-05-16 07:57:22 UTC (rev 8352)
@@ -53,8 +53,18 @@
 
 -- update all body elements for guis containing wz_jsgraphics.js
 ---> otherwise new wz_jsgraphics version leads to an error
-UPDATE gui_element set
-e_mb_mod = CASE WHEN e_mb_mod IS NULL THEN '../extensions/RaphaelJS/raphael-1.4.7.min.js' ELSE e_mb_mod::text ||',../extensions/RaphaelJS/raphael-1.4.7.min.js' END where e_id = 'body' and fkey_gui_id IN (SELECT DISTINCT fkey_gui_id FROM gui_element where e_js_file LIKE '%wz_jsgraphics%' OR e_mb_mod LIKE '%wz_jsgraphics%');
+UPDATE gui_element set e_mb_mod = 
+CASE 
+WHEN e_mb_mod IS NULL 
+THEN '../extensions/RaphaelJS/raphael-1.4.7.min.js' 
+ELSE
+	CASE 
+	WHEN e_mb_mod LIKE '%../extensions/RaphaelJS/raphael-1.4.7.min.js%'
+	THEN e_mb_mod
+	ELSE  e_mb_mod::text ||',../extensions/RaphaelJS/raphael-1.4.7.min.js' 
+	END
+END 
+where e_id = 'body' and fkey_gui_id IN (SELECT DISTINCT fkey_gui_id FROM gui_element where e_js_file LIKE '%wz_jsgraphics%' OR e_mb_mod LIKE '%wz_jsgraphics%');
 
 --update all gui elements using jquery-ui version 1.8.1 to 1.8.16
 update gui_element set e_mb_mod = replace(e_mb_mod, 'jquery-ui-1.8.1.custom', 'jquery-ui-1.8.16.custom') where e_mb_mod LIKE '%jquery-ui-1.8.1.custom%';

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	2012-05-14 13:13:12 UTC (rev 8351)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2012-05-16 07:57:22 UTC (rev 8352)
@@ -53,8 +53,18 @@
 
 -- update all body elements for guis containing wz_jsgraphics.js
 ---> otherwise new wz_jsgraphics version leads to an error
-UPDATE gui_element set
-e_mb_mod = CASE WHEN e_mb_mod IS NULL THEN '../extensions/RaphaelJS/raphael-1.4.7.min.js' ELSE e_mb_mod::text ||',../extensions/RaphaelJS/raphael-1.4.7.min.js' END where e_id = 'body' and fkey_gui_id IN (SELECT DISTINCT fkey_gui_id FROM gui_element where e_js_file LIKE '%wz_jsgraphics%' OR e_mb_mod LIKE '%wz_jsgraphics%');
+UPDATE gui_element set e_mb_mod = 
+CASE 
+WHEN e_mb_mod IS NULL 
+THEN '../extensions/RaphaelJS/raphael-1.4.7.min.js' 
+ELSE
+	CASE 
+	WHEN e_mb_mod LIKE '%../extensions/RaphaelJS/raphael-1.4.7.min.js%'
+	THEN e_mb_mod
+	ELSE  e_mb_mod::text ||',../extensions/RaphaelJS/raphael-1.4.7.min.js' 
+	END
+END 
+where e_id = 'body' and fkey_gui_id IN (SELECT DISTINCT fkey_gui_id FROM gui_element where e_js_file LIKE '%wz_jsgraphics%' OR e_mb_mod LIKE '%wz_jsgraphics%');
 
 --update all gui elements using jquery-ui version 1.8.1 to 1.8.16
 update gui_element set e_mb_mod = replace(e_mb_mod, 'jquery-ui-1.8.1.custom', 'jquery-ui-1.8.16.custom') where e_mb_mod LIKE '%jquery-ui-1.8.1.custom%';