import sqlite3
import zlib
good_chars=',-.0123456789=?@ABCDEFGHIJKLMNOPQRSTUVWXYZ_abcdefghijklmnopqrstuvwxyz~ '
conn = sqlite3.connect('gmail.db')
cursor = conn.cursor()
cursor.execute("select _id, fromAddress, subject, bodyCompressed from messages")
# ablob = cursor.fetchone()
rows = cursor.fetchall()
for row in rows:
fname = (str(row[0]) + row[1] + row[2])[:32]
fname = ''.join([c for c in fname if c in good_chars])
print 'fname=', fname
fout = open(fname + '.html', 'wb')
if row[3]:
data = zlib.decompress(row[3])
fout.write(data)
fout.close()
cursor.close()
conn.close()
