storing serialized data in postgres by SQLAlchemy

Question

I am building an App by using Flask with Postgress and SQLAlchemy. There is a table column where I need to store serialized data (JSON). How do I define the field in the model class?

Can I just use string field for the column?

from flask.ext.sqlalchemy import SQLAlchemy
from main import app

db = SQLAlchemy(app)

class Fame (db.Model):
    __tablename__ = "toto"
    id = db.Column('id', db.Integer, primary_key=True)
    data = db.Column('data', db.JSON)
    creation_date = db.Column('creation_date', db.Date, default=datetime.utcnow)

But I got this error:

AttributeError: 'SQLAlchemy' object has no attribute 'JSON'

RazerM · Accepted Answer · 2016-09-10 21:50:18Z

2

You need to import JSON or JSONB from sqlalchemy.dialects.postgresql

answered Sep 10, 2016 at 21:50

RazerM

5,5522 gold badges27 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

storing serialized data in postgres by SQLAlchemy

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related