# -*- coding: utf-8 -*- """ This macro shows a list of wiki page, exclude wiki-default pages. $Id: MyTitleIndex.py 4 2006-03-22 03:47:58Z takayama $ """ import time, re import string from StringIO import StringIO wiki_pages = [ "CamelCase", "RecentChanges", "TitleIndex", "TracAccessibility", "TracAdmin", "TracBackup", "TracBrowser", "TracCgi", "TracChangeset", "TracEnvironment", "TracFastCgi", "TracGuide", "TracImport", "TracIni", "TracInstall", "TracInterfaceCustomization", "TracLinks", "TracLogging", "TracModPython", "TracNotification", "TracPermissions", "TracPlugins", "TracQuery", "TracReports", "TracRoadmap", "TracRss", "TracSearch", "TracStandalone", "TracSupport", "TracSyntaxColoring", "TracTickets", "TracTicketsCustomFields", "TracTimeline", "TracUnicode", "TracUpgrade", "TracWiki", "WikiDeletePage", "WikiFormatting", "WikiHtml", "WikiMacros", "WikiNewPage", "WikiPageNames", "WikiProcessors", "WikiRestructuredText", "WikiRestructuredTextLinks" ] def execute(hdf, args, env): db = env.get_db_cnx() cursor = db.cursor() sql = 'SELECT DISTINCT name FROM wiki ORDER BY name' cursor.execute(sql) buf = StringIO() buf.write('