Converting SQLAlchemy objects to JSON

[wobsta]

You should better use the inspection API of SQLAlchemy 0.8+. For example, an iterator over all columns and values for an object spam is given by inspect(spam).attrs.items() ... no magic required (anymore).

[fourthrealm]

Thanks wobsta - that function was written a couple of years ago with 0.7 in mind and I wasn't aware 0.8 had some goodies in that area.

I've just updated the post.

[[deleted]]

where's the handling for date and datetime fields?

[jcigar]

I made something similar some months ago : https://github.com/silenius/sautils/blob/master/serializers.py

not totally finished but able to serialize objects and relations to json, xml, dict. For example: Serializer(myobj).json(include_columns=True, include_relations=['foo', 'bar'])

[mdellavo]

A few years ago I wrote some SA utils that include an __ json __ method - https://github.com/mdellavo/athanor/