MacroBazaar: UserChanges.py

import time
from StringIO import StringIO

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

    author = limit = None
    if args:
        argv = [arg.strip() for arg in args.split(',')]
        if len(argv) > 0:
            author = argv[0].replace('\'', '\'\'')
            if len(argv) > 1:
                limit = int(argv[1])

    sql = 'SELECT name, max(time) FROM wiki '
    if author:
        sql += 'WHERE author LIKE \'%s%%\' ' % author
    sql += 'GROUP BY name ORDER BY max(time) DESC'
    if limit:
        sql += ' LIMIT %d' % limit
    cursor.execute(sql)

    buf = StringIO()
    #debug
    #buf.write('%s<br>' % sql);
    if author == None:
        author = 'all users'
    buf.write('<h2>Recent Changes for %s</h2>' % author)
    prevtime = None
    while 1:
        row = cursor.fetchone()
        if row == None:
            break
        t = time.strftime('%x', time.localtime(int(row[1])))
        if not t == prevtime:
            if prevtime:
                buf.write('</ul>')
            buf.write('<h3>%s</h3><ul>' % t)
            prevtime = t
        buf.write('<li><a href="%s">%s</a></li>\n' % (env.href.wiki(row[0]),
                                                      row[0]))
    if prevtime:
        buf.write('</ul>')

    return buf.getvalue()