How to save json type with flask-sqlalchemy?

Question

I am currently developing an app using Flask + Vue. I use flask-sqlalchemy for ORM.

When saving json to JSON type to MySQL, the action registers the data as a string versus a JSON object.

Is it possible to save the value in JSON?

Sample code:

from flask_sqlalchemy import SQLAlchemy
from flask_marshmallow import Marshmallow

db = SQLAlchemy()
marsh = Marshmallow()

from database import db, marsh
from sqlalchemy.dialects.mysql import insert

class UserInfo(db.Model):
    __tablename__ = 'user_info'

    user_id = db.Column(db.String, nullable=False, primary_key=True)
    json= db.Column(db.JSON, nullable=True)

    def insert_on_duplicate_key_update(user_id, str_json):
        json = json.dumps(str_json, ensure_ascii=False)
        insert_stmt = insert(UserInfo).values({UserInfo.user_id: user_id
                                               UserInfo.json : json })

        print(json)
        // print {"item1": false} 

        on_conflict_stmt = insert_stmt.on_duplicate_key_update(
            json=insert_stmt.inserted.json)

        db.engine.execute(on_conflict_stmt)

        return insert_stmt

class UserInfoSchema(marsh.ModelSchema):
    class Meta:
        model = UserInfo
        fields = ("user_id", "json")

Registration result:

select * from user_info;

{\"item1\": false}

I want to save in the following state.

{"item1": false}

I am Japanese. Sorry for poor English....

c8999c 3f964f64 · Accepted Answer · 2020-03-09 13:30:30Z

2

json.dumps is to make json into string

Here you make json into string:

json = json.dumps(str_json, ensure_ascii=False)

dont need. database will accept json. Possible, I use it. Maybe you need json.loads?

edited Mar 9, 2020 at 13:30

answered Mar 9, 2020 at 13:24

c8999c 3f964f64

1,6491 gold badge18 silver badges32 bronze badges

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

1 Comment

nayuta shiba Over a year ago

This was all the cause. json = json.dumps(str_json, ensure_ascii=False) I didn't notice With my lack of awareness and 「print(json)」result was in json format... Thank you for teaching me!

Collectives™ on Stack Overflow

How to save json type with flask-sqlalchemy?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related