我有一个json文件,如下所示::
{
"1": {
"name": "item1"
"symbol": "symbol1"
"quotes": {
"Amount": "45345"
"other": "value"
}
}
"734": {
"name": "item1"
"symbol": "symbol1"
"quotes": {
"Amount": "45345"
"other": "value"
}
}
"378": {
"name": "item1"
"symbol": "symbol1"
"quotes": {
"Amount": "45345"
"other": "value"
}
}
"2": {
"name": "item1"
"symbol": "symbol1"
"quotes": {
"Amount": "45345"
"other": "value"
}
}
}
放置数字的"type“是一个字符串值。如果这有帮助的话。
通常情况下,不会有人试图做额外的工作,并用整数的值来标记“键”……
我正在尝试将这个文件和其他一些json放入mysql数据库中。
我的研究告诉我,这个过程看起来有点像这样:
# !!!!!!!!is a copy paste from another solution::::::!!!!!
json_obj = json.loads(response.decode('utf-8'))
#print(json_obj["products"][0]["upc"])
for product in json_obj["products"]:
print("upc:", product["upc"])
print("sku:", product["sku"])
print("salePrice:", product["salePrice"])
print('---')
cursor.execute("INSERT INTO bestb (sku, upc, salePrice) VALUES (%s,%s,%s)", (product["sku"], product["upc"], product["salePrice"]))
上面的代码说明,我们将加载json文件并读取它,同时将密钥写入cols。--有道理..。如何使用整数循环来执行此过程...
我从一个while循环开始
i = 1
while 1 < 400:
print(data - to mysql)
我使用python从API中提取数据,然后将数据“标准化”到mysql中,在那里php会将数据提取到一些图表和图形中。
提前感谢您的帮助!
发布于 2018-07-29 06:54:34
尝尝这个
import json
json = {
"1": {
"name": "item1",
"symbol": "symbol1",
"quotes": {
"Amount": "45345",
"other": "value",
}
},
"734": {
"name": "item1",
"symbol": "symbol1",
"quotes": {
"Amount": "45345",
"other": "value",
}
},
"378": {
"name": "item1",
"symbol": "symbol1",
"quotes": {
"Amount": "45345",
"other": "value",
}
},
"2": {
"name": "item1",
"symbol": "symbol1",
"quotes": {
"Amount": "45345",
"other": "value",
}
}
};
jsonSorted = sorted(json.items())
print(jsonSorted)
https://stackoverflow.com/questions/51574834
复制相似问题