SQL Alchemy JSON Encoder

sqlalchemy_parse.py

import decimal, datetime

def alchemyencoder(obj):
    """JSON encoder function for SQLAlchemy special classes."""
    if isinstance(obj, datetime.date):
        return obj.isoformat()
    elif isinstance(obj, str):
    	return obj.strip()
    elif isinstance(obj, decimal.Decimal):
        return float(obj)

def _example():
    res = conn.execute(select([accounts]))
    # use special handler for dates and decimals
    return json.dumps([dict(r) for r in res], default=alchemyencoder)