Obtener los tickets en diferentes Trac

import os
import sqlite3

TRAC_DIRECTORY = "/var/devel/trac"
DB_DIRECTORY = "/db/trac.db"
OUTPUT_FILENAME = "/home/fernando/tracs.csv"
OUTPUT_PATTERN = "%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s\n"

SQL_ACTIVE_TICKETS = "SELECT id, type, time, changetime, component, severity, priority, status, replace(summary, ',', '.'), milestone  FROM ticket"

def processTrac(tracName):
    ''' Procesamos un trac dado. '''
    print "Procesando el TRAC " + tracName

    databaseFile = TRAC_DIRECTORY + "/" + tracName + DB_DIRECTORY
    conn = sqlite3.connect( databaseFile )
    c = conn.cursor()

    c.execute( SQL_ACTIVE_TICKETS )
    row = c.fetchone()

    while row != None:
        output_str = OUTPUT_PATTERN % (row[0], row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[8], row[9], tracName )
        f.write( output_str.encode('UTF-8') )
        row = c.fetchone()


def mustIgnore( dirName ):
    ''' Determia si se debe procesar o no un directorio '''
    if dirName[0] == ".":
        return True
    else:
        return False

# Iteramos por todos los trac del directorio y los vamos procesando
f = open( OUTPUT_FILENAME, "w" )

dirList = os.listdir(TRAC_DIRECTORY)
for fname in dirList:
    if not mustIgnore(fname):
        processTrac( fname )

f.close()