json文件
{"tasks": [{"name": "allen", "params": {"ftpDatasourceId": 2,"targetConfig": {"database": "ods", "description": "", "table": "allen_keep_moving"}, "basePath": "/allen_keep_moving/$[yyyyMMdd-1]" }}]}
import json
"""python中读取文件中的内容,并更修改"""
with open("idp_backend.json",'rb') as f:
# 获取json文件对象
loads = json.loads(f.read())
# 逐个遍历数组中的对象,更改数组中对应对象的值
for item in loads['tasks']:
item['name'] = "allen"
item['params']['targetConfig']['table'] = "allen_keep_moving"
item['params']['basePath'] ="/allen_keep_moving/$[yyyyMMdd-1]"
# 写入到目标文件
with open("json_value_change","w") as f:
json.dump(loads,f)
print("-------文件加载success----------")
总结:json文件是我们数据开发路上一直需要接触的数据类型,熟练掌握开发方法,能帮助我们更熟练上手数据开发的工作。