sqlalchemy generic __repr__

reprbase.py

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm.properties import ColumnProperty

class RepresentableBase(object):

    def __repr__(self):
        prop = filter(lambda p: isinstance(p, ColumnProperty), self.__mapper__.iterate_properties)
        keys = [p.key for p in prop]
        prop_values = dict(zip(keys, [getattr(self, k) for k in keys]))

        values = ", ".join(sorted(map(lambda (k,v): '{}={}'.format(k, v), prop_values.iteritems())))
        return "<{} ({})>".format(self.__class__.__name__, values)

Base = declarative_base(cls=RepresentableBase)