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")
rows = cursor.fetchall()
for row in rows:
fname = (str(row[0]) + row[1] + row[2])[:48]
fname = ''.join([c for c in fname if c in good_chars])
print fname
with open(fname + '.html', 'wb') as fout:
if row[3]:
data = zlib.decompress(row[3])
fout.write('<html><body>' + data + '</body></html>')
cursor.close()
conn.close()
Diff to Previous Revision
--- revision 4 2012-11-28 16:23:31
+++ revision 5 2013-03-22 11:45:11
@@ -12,7 +12,7 @@
fname = (str(row[0]) + row[1] + row[2])[:48]
fname = ''.join([c for c in fname if c in good_chars])
print fname
- with open(os.path.join(BLOBDIR, fname + '.html'), 'wb') as fout:
+ with open(fname + '.html', 'wb') as fout:
if row[3]:
data = zlib.decompress(row[3])
fout.write('<html><body>' + data + '</body></html>')