A dict-serializable (JSON compatible) mixin for SQLAlchemy models

JSONSerializable.py

# -*- coding: utf-8 -*-

class JSONSerializable:
    def _serialize(self, value):
        if type(value) not in (int, float, bool, type(None)):
            return str(value)

        return value

    def as_dict(self):
        return {c.name:self._serialize(getattr(self, c.name)) for c in self.__table__.columns}