Changes between Version 1 and Version 2 of LeftMenu

Timestamp:

Feb 2, 2016, 9:32:50 AM (9 years ago)

Author:

Pedro Gea

Comment:

--

LeftMenu

@@ -18 +18 @@
 
 = Left Menu =
+
+This page contains the left menu used in the main pages. 
+
+The menu in this page can be applied to the others using the following query:
+{{{
+#!sql
+UPDATE tolsch.wiki a
+SET text = regexp_replace(a.text, '<LEFT-MENU>.*</LEFT-MENU>', m.lmenu) 
+FROM (
+  SELECT name, Max(version) as version
+  FROM tolsch.wiki
+  WHERE text LIKE '%<LEFT-MENU>%' AND name <> 'LeftMenu' 
+  GROUP BY name
+) av, (
+  SELECT (regexp_matches(text, '<LEFT-MENU>.*</LEFT-MENU>'))[1] as lmenu
+  FROM tolsch.wiki b, (
+    SELECT Max(version) as version
+    FROM tolsch.wiki
+    WHERE name = 'LeftMenu'
+  ) bv
+  WHERE b.name = 'LeftMenu' AND b.version = bv.version
+) m
+WHERE a.name = av.name AND a.version = av.version
+}}}