Exception > Dict > SQLite

exc_info_to_db.py

import datetime as dt
import logging
import sys

from playhouse.dataset import DataSet  # this can be any DB ;)


params = 'timestamp name level pathname lineno msg args exc_info func sinfo'.split(' ')

db = DataSet('sqlite:///db.sqlite')
logs = db['logs']


class DictHandler(logging.Handler):
    def emit(self, record):
        record_dict = {p: getattr(record, p) for p in params if hasattr(record, p)}
        logs.insert(**record_dict)


def ehook(etype, evalue, etrace):
    exc_info = (etype, evalue, etrace)
    logging.exception(evalue, exc_info=exc_info, stack_info=True, extra=dict(timestamp=dt.datetime.utcnow()))
    sys.__excepthook__(*exc_info)


default_logger = logging.getLogger()

default_logger.addHandler(DictHandler())
default_logger.setLevel(logging.INFO)

sys.excepthook = ehook

def main():
    open('nope.txt', 'r')

main()