SQLAlchemy set default value for postgres JSON column

Question

I want to set the default value of my SQLAlchemy postgres JSON column to an empty dictionary.

from sqlalchemy.dialects.postgresql import JSON

info = Column(JSON, default='{}')
info = Column(JSON, default={})

Neither of these work.

It's probably because the same dict instance is being used across all instances of your model. Try default=lambda: {}. — univerio, Aug 15 at 20:22
Thanks univerio that works. You can submit an answer and I can accept if you'd like. Otherwise I'll write my own answer. — Allen Lin, Aug 15 at 21:17

Allen Lin · Accepted Answer · 2016-08-17 14:51:30Z

up vote 0 down vote accepted

Using default=lambda: {} works. Credit goes to univerio in the comments.

answered Aug 17 at 14:51

Allen Lin

456313

add a comment |

1 Answer 1