mailview.py

import cStringIO
import sqlite3
import mailbox

def index_mailbox(db, mailbox, tablename):

    # create table
    q = "create virtual table %s using fts4(content text);"
    q %= tablename
    db.execute(q)

    # insert each message from mailbox
    q = "insert into %s (content) values (?);"
    q %= tablename
    for i, msg in mailbox.iteritems():
        db.execute("insert into gmail(content) values(?)", (repr(msg.as_string()),))
        if i % 1000 == 0:
            print "%dk messages indexed" % (i/1000, )
    
    # save changes
    db.commit()