MacroBazaar: WikiInclude.0.11.py

from StringIO import StringIO
from trac.util.html import Markup
from trac.wiki.formatter import Formatter 
from trac.wiki.macros import WikiMacroBase

class WikiIncludeMacro(WikiMacroBase):
        def expand_macro(self, formatter, name, args):
                
                args = args.split('|')
                
                if len(args) < 1 :
                        return '';
                        
                target = args[0]
                db = self.env.get_db_cnx()
                
                sql = "SELECT text from wiki where name = '%s' order by version desc limit 1" % target
                cs = db.cursor()
                cs.execute(sql)
                
                row = cs.fetchone()
                
                if row == None:
                        return ''
                
                text = row[0]
                
                if len(args) > 1 :
                        i = 0
                        for arg in args:
                                if i > 0 :
                                        text = text.replace('{{%d}}' % (i-1), unicode(args[i]))
                                i += 1
                
                out = StringIO()
                Formatter(formatter.env, formatter.context).format(text, out)
                return Markup(out.getvalue())