php - 在python中对以整数开头的json数组进行排序

Question

我有一个如下所示的 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"
       }
      }
 } 

放置数字的“类型”是字符串值。如果有帮助的话。

通常，有人不会尝试做额外的工作并用整数值标记“键”...

我正在尝试将此文件和其他一些 json 放入 mysql 数据库中。

我的研究告诉我，这个过程看起来有点像这样::

    # !!!!!!!!!!This 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 会将数据提取到一些图表和图形中。

提前感谢您的帮助!

Answer 1

试试这个

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)