Python Files in changeset

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi

I whould like to write a Macro witch shows me witch files are changed for a
spezified Ticket.
So far I got all changesets from this Ticket.

But how I can get a filelist from a changeset.

Someone can help me please?

Here are my Current Code.

from StringIO import StringIO

def execute(hdf, args, env):
    db = env.get_db_cnx()
    cursor = db.cursor()
    sql = 'SELECT DISTINCT rev FROM revision '
    sql += 'WHERE message LIKE \'%%#%s%%\' ' % args
    sql += 'ORDER BY rev'
    cursor.execute(sql)

    output = '<ul>'
    while 1:
        row = cursor.fetchone()
        if row == None:
            break
        output += '<li>' + str(row[0])
        output += '</li>\n'
    output+= '</ul>'
    return output





Thanks in Advance.
Regards Ivo 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)

iD8DBQFBm1o+1D336/QJ+4YRAuxwAJ9lzzzl5sDUnqNX1dM8PTfWlyns7wCdF+jG
LRtvQlJf1F7QvBeIioEmifI=
=NblT
-----END PGP SIGNATURE-----