Posts

Showing posts with the label sqlalchemy

Amailyser: The E-mail Analyser

Introducing a small software to analyse a mailbox. Recently Ed Daniel (a friend of mine) needed to produce a time analysis report out of his e-mails and asked if I can help him.  Well, obviously I said yes. I thought to myself, he needs charts and graphs and data querying from many aspects that I may not know.  So to me the best option is to load his e-mail important fields into an RDBMS (such as SQLite or PostgreSQL).  Later he can do whatever he wants with the data using reporting tools such as JasperReports and produce nice charts and graphs as he requires. That was the motivation to write Amailyser (github repo) . The language is Python 2.x; I could have done it in Perl but I'm learning Python and it seems like a wonderful practice to me. For DB interaction I used SQLAlchemy a nice ORM mapper for Python. To read the e-mail messages I used Python standard library mailbox. After downloading and extracting, you can run the Amailyzer (after you have modified con...