id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release
10724,[PATCH] render inner macros inside the SQLTable macro,falkb,rjollos,Imagine this construct:\r\n{{{\r\n{{{\r\n#!SQLTable\r\nSELECT DISTINCT\r\n  ( SELECT value FROM session_attribute WHERE name='pagemoderator' AND Sid=m.Sid ) AS "Standard"_\r\n  "[[Image(" || REPLACE(\r\n                         REPLACE(\r\n                                   ( SELECT value FROM session_attribute WHERE name='picture_href' AND Sid=m.Sid )_ '/myproject/raw-attachment/wiki/'_ '' )_ '/'_ ':')\r\n                       || "_ center_ 50px)]][[BR]]" ||   ( SELECT value FROM session_attribute WHERE name='name' AND Sid=m.Sid ) AS "Moderator"_\r\n  ( SELECT value FROM session_attribute WHERE name='email'          AND Sid=m.Sid ) AS "Email"\r\nFROM\r\n  session_attribute m\r\nWHERE\r\n  name='pagemoderator' AND NOT value=''\r\nORDER BY\r\n  Standard\r\n}}}\r\n}}}\r\n\r\nThe following patch let the table appear with all bells and whistles:\r\n{{{\r\n#!diff\r\nIndex: wikitablemacro/trunk/wikitable/table.py\r\n===================================================================\r\n--- wikitablemacro/trunk/wikitable/table.py	(revision 12458)\r\n+++ wikitablemacro/trunk/wikitable/table.py	(working copy)\r\n@@ -14_6 +14_7 @@\r\n from trac.core import implements\r\n from trac.web.chrome import ITemplateProvider_ add_stylesheet\r\n from trac.wiki.formatter import system_message\r\n+from trac.wiki import wiki_to_html\r\n from trac.wiki.macros import WikiMacroBase\r\n from trac.util.html import Markup\r\n from trac.util.text import exception_to_unicode\r\n@@ -64_7 +65_8 @@\r\n             css_class = (idx % 2 == 0) and 'odd' or 'even'\r\n             print >> out_ "  <tr class='%s'>" % css_class\r\n             for col in row:\r\n-                print >> out_ "<td>%s</td>" % col\r\n+                text = wiki_to_html(StringIO(col).getvalue()_ self.env_ req)\r\n+                print >> out_ "<td>%s</td>" % text\r\n             print >> out_ "  </tr>"\r\n \r\n         print >> out_ " </tbody>"\r\n}}},enhancement,closed,normal,WikiTableMacro,normal,duplicate,,,