sqlalchemy+mysql+json列更新不工作

7cwmlq89 于 2021-06-23 发布在 Mysql

关注(0)|答案(1)|浏览(417)

我在我的项目中使用sqlalchemy。当我在sqlalchemy模型中修改json列时，它一点也没有改变。这就是我的代码：

class Order(DB.Model):

    uid = DB.Column(DB.Integer, primary_key=True, index=True, unique=True)
    status_uid = DB.Column( DB.Integer, default=1 )
    json_data = DB.Column( DB.JSON, nullable=True )

orderobj = Order(json_data{'key':'old value'})
DB.session.add( orderobj )

# That is work fine

DB.session.commit()

# Trying to update

orderobj = Order.query.filter_by( status_uid=1 ).first()
orderobj.json_data['key'] = 'new value'

print(orderobj.json_data['key']) # -> 'old value'

DB.session.commit()

print(orderobj.json_data['key']) # -> 'old value'

mysql flask-sqlalchemy flask sqlalchemy

来源：https://stackoverflow.com/questions/50043077/flask-sqlalchemy-mysql-json-column-update-not-working

1条答案

按热度按时间

slhcrj9b1#

class Order(DB.Model):

    uid = DB.Column(DB.Integer, primary_key=True, index=True, unique=True)
    status_uid = DB.Column( DB.Integer, default=1 )
    json_data = DB.Column( DB.JSON, nullable=True )

orderobj = Order(json_data{'key':'old value'})
DB.session.add( orderobj )

# That is work fine

DB.session.commit()

# Trying to update

orderobj = Order.query.filter_by( status_uid=1 ).first()

json_data = deepcopy(orderobj.json_data)
json_data['key'] = 'new value'

orderobj.json_data=json_data

print(orderobj.json_data['key']) # -> 'old value'

DB.session.commit()

print(orderobj.json_data['key']) # -> 'old value'

赞(0）回复(0）举报 2021-06-23

我来回答

sqlalchemy+mysql+json列更新不工作

1条答案

相关问题

热门标签

最新问答