take MySQL RunLog text dump and save to sqlite

gistfile1.py

def upload_runlog():
    import sqlite3 as sqlite
    f = open('/tmp/runlog.txt')
    db = sqlite.connect('/Users/kocolosk/data/analysis.db')
    dbc = db.cursor()
    for line in f:
        data = line.split('|')[1:-1]
        run = int(data[0].strip())
        trigId = int(data[1].strip())
        prescale = float(data[2].strip())
        nevents = int(data[3].strip())
        if trigId > 90000:
            dbc.execute('''INSERT INTO runlog (run,trigId,prescale,nevents)
                VALUES(?,?,?,?)''', (run,trigId,prescale,nevents))
    db.commit()
    dbc.close()