在Python中向JSON属性追加新值

Question

我有一个JSON字符串，我从我的数据库(MySQL)检索，我需要添加另一个值到daysOff属性在JSON字符串中。一旦我将新值添加到JSON字符串中，我需要用新值更新我的表。

我是Python的新手，我理解字符串是不可变的，我遇到麻烦的部分是遍历数组以向daysOff添加新值地产

这是我目前为止写的:

import mysql.connector as mysqlConnector
import sys
import json
from datetime import date
query = "SELECT option_value FROM my_tbl WHERE option_name='my_holiday_settings'"
try:
cur.execute(query)
myresult = cur.fetchall()
for x in myresult:
dictionary = json.loads(*x)
key = 'daysOff'
checkKey(dictionary, key)
print(dict)
print(dictionary)
print(type(dictionary))
except Exception as e:
print('error:', e)
finally:
cur.close()

def checkKey(dict, key):
if key in dict.keys():
test_dict = {"name":"test","startDate":"9999-01-01","endDate":"9999-09-09","repeat":"0"}
dict[key]=test_dict
print("value updated =", 600)
else:
print("Not Exist")

这是我的JSON

{
"notifications": {
"whatsAppBusinessID": "None",
"whatsAppLanguage": "Alien"
},
"daysOff": [
{
"name": "Xmas",
"startDate": "2022-01-09",
"endDate": "2022-01-09",
"repeat": true
},
{
"name": "Australia Day",
"startDate": "2022-01-26",
"endDate": "2022-01-26",
"repeat": true
},
{
"name": "Good Friday",
"startDate": "2022-04-15",
"endDate": "2022-04-15",
"repeat": true
},
{
"name": "Holy Saturday",
"startDate": "2022-04-16",
"endDate": "2022-04-16",
"repeat": true
}
]
}

Answer 1

cursor.fetchall()

返回一个元组列表，这意味着for循环中的x是一个元组。您可以使用

将元组转换为字典

tuple_as_dict = dict(tuple)

---

如果将数据存储为json字符串，则首先需要解压缩元组并将其转换为字符串

dictionary = json.loads(*tuple)

---

json.loads(string)

也返回一个字典，但是接受字符串而不是元组作为参数