source: trac/trunk/wiki-macros/SubWiki.2.py @ 2591

"""
Inserts an alphabetic list of sub-wiki pages into the output.
A sub-wiki page is a page that is is deeper in the hierachy than the current page.  e.g. if the current page is People, the this will return a list of all wiki entries that start with "People/"

Accepts a prefix string as parameter: if provided, only pages with names that
start with the prefix are included in the resulting list. If this parameter is
omitted, all pages are listed.

This now takes the 2nd line (or whatever you decide in the line_number below) and grabs that line, and returns it as a description.  This is useful for us.

"""

from StringIO import StringIO

def execute(hdf, args, env):
    line_number = 2
    db = env.get_db_cnx()
    cursor = db.cursor()
    cs = db.cursor()

    prefix = None
    if args:
        prefix = args.replace('\'', '\'\'')
    else :
        prefix = hdf.getValue('wiki.page_name', '') + '/'

    sql = 'SELECT DISTINCT name FROM wiki '
    if prefix:
        sql += 'WHERE name LIKE \'%s%%\' ' % prefix
    sql += 'ORDER BY name'
    cursor.execute(sql)

    buf = StringIO()
    buf.write('<ul>')
    while 1:
        row = cursor.fetchone()
        if row == None:
            break
        name = row[0]
        sql = 'SELECT name,text from wiki where name = \'%s\' order by version desc limit 1' % name
        cs.execute(sql)
        while 1:
                csrow = cs.fetchone()
                if csrow == None:
                        break
                name = csrow[0]
                desc = csrow[1]
                try:
                        desc = desc.split('\n')
                        desc = desc[line_number]
                except IndexError:
                        desc = ''
                buf.write('<li><a href="%s">' % env.href.wiki(name))
                buf.write(name)
                buf.write('</a>&nbsp; &nbsp;')
                buf.write(desc)
                buf.write('</li>\n')
    buf.write('</ul>')

    return buf.getvalue()