如何将json文件中的“”更改为“”[duplicate]

Question

我怎么把“”改成“”？我需要使用来自sqlalchemy的数据编写database.json

all_data = Data.query.all()
data_schema = DataSchema(many=True)
output = data_schema.dump(all_data) 
OutputJson = jsonify({'products':output})

while True:
    with open('database.json',"w") as file:
        file.write(str({'products': output}))
    
    with open('database.json',"r") as files:
        FinalOutput = files.read()

        return FinalOutput

{'products': [
    {'id': 0,
     'name': 0,
     'price': 0,
     'quantity': 1
    }
]}

应该是这样的：

{
  "products": [
    {
      "id": 1,
      "name": "Aspirina",
      "price": 100,
      "quantity": 1
    }
  ]
}

Answer 1

修改此物料：

with open('database.json',"w") as file:
        file.write(str({'products': output}))

作为

import json
json_data = {}
with open('database.json',"r") as file:
        json_data = json.load(file)
json_data['products'] = output
with open('database.json',"w+") as file:
        json.dump(json_data)