json.dumps： dict ——＞ str

已于 2024-04-24 19:29:57 修改
阅读量233 收藏
点赞数 1
文章标签： json java 数据库
于 2024-04-24 19:28:13 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_44976611/article/details/138166355
版权

STEP1 :

https://bibfx.flyhsystem.com/datax/api/manage/reportDataPreview?dashBoardReportId=0fef1a97-fac6-4bb9-ac52-e352c88130fc&where={"conditions":[{"field":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"date_format(trace,'%Y-%m-%d %H:%m:%s')","isEXPR":true},"operator":">=","value":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"'2024-04-16 00:00:00'","isEXPR":true},"command":"AND"},{"field":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"date_format(trace,'%Y-%m-%d %H:%m:%s')","isEXPR":true},"operator":"<","value":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"'2024-04-17 00:00:00'","isEXPR":true},"command":"AND"}]}

STEP2 : 参数提取，给我全部整成斜杠了，我去

url = "https://bibfx.flyhsystem.com/datax/api/manage/reportDataPreview"
params = {
    "dashBoardReportId": "0fef1a97-fac6-4bb9-ac52-e352c88130fc",
    "where": "{\"conditions\":[{\"field\":{\"db\":\"bibfx_tms\",\"table\":\"bibfxuseronline_new\",\"name\":\"date_format(trace,'%Y-%m-%d %H:%m:%s')\",\"isEXPR\":true},\"operator\":\">=\",\"value\":{\"db\":\"bibfx_tms\",\"table\":\"bibfxuseronline_new\",\"name\":\"'2024-04-16 00:00:00'\",\"isEXPR\":true},\"command\":\"AND\"},{\"field\":{\"db\":\"bibfx_tms\",\"table\":\"bibfxuseronline_new\",\"name\":\"date_format(trace,'%Y-%m-%d %H:%m:%s')\",\"isEXPR\":true},\"operator\":\"<\",\"value\":{\"db\":\"bibfx_tms\",\"table\":\"bibfxuseronline_new\",\"name\":\"'2024-04-17 00:00:00'\",\"isEXPR\":true},\"command\":\"AND\"}]}"
}

type(params["where"])
str

params["where"] # 可以看到为JSON字符串
'{"conditions":[{"field":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"date_format(trace,\'%Y-%m-%d %H:%m:%s\')","isEXPR":true},"operator":">=","value":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"\'2024-04-16 00:00:00\'","isEXPR":true},"command":"AND"},{"field":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"date_format(trace,\'%Y-%m-%d %H:%m:%s\')","isEXPR":true},"operator":"<","value":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"\'2024-04-17 00:00:00\'","isEXPR":true},"command":"AND"}]}'

STEP3 : 构建时间变量参数

错误示范


begin_time = '2024-04-01 00:00:00'
end_time = '2024-04-02 00:00:00'

url = "https://bibfx.flyhsystem.com/datax/api/manage/reportDataPreview"
params = {
    "dashBoardReportId": "0fef1a97-fac6-4bb9-ac52-e352c88130fc",
    "where": "{\"conditions\":[{\"field\":{\"db\":\"bibfx_tms\",\"table\":\"bibfxuseronline_new\",\"name\":\"date_format(trace,'%Y-%m-%d %H:%m:%s')\",\"isEXPR\":true},\"operator\":\">=\",\"value\":{\"db\":\"bibfx_tms\",\"table\":\"bibfxuseronline_new\",\"name\":f\"'{begin_time}'\",\"isEXPR\":true},\"command\":\"AND\"},{\"field\":{\"db\":\"bibfx_tms\",\"table\":\"bibfxuseronline_new\",\"name\":\"date_format(trace,'%Y-%m-%d %H:%m:%s')\",\"isEXPR\":true},\"operator\":\"<\",\"value\":{\"db\":\"bibfx_tms\",\"table\":\"bibfxuseronline_new\",\"name\":f\"'{end_time}'\",\"isEXPR\":true},\"command\":\"AND\"}]}"
}

params["where"]  # begin_time、end_time变量未生效

'{"conditions":[{"field":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"date_format(trace,\'%Y-%m-%d %H:%m:%s\')","isEXPR":true},"operator":">=","value":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":f"\'{begin_time}\'","isEXPR":true},"command":"AND"},{"field":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"date_format(trace,\'%Y-%m-%d %H:%m:%s\')","isEXPR":true},"operator":"<","value":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":f"\'{end_time}\'","isEXPR":true},"command":"AND"}]}'

STEP4 : 正确示范

# 将STEP2的基础上打印下来
# 关键一步：

params["where"]
'{"conditions":[{"field":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"date_format(trace,\'%Y-%m-%d %H:%m:%s\')","isEXPR":true},"operator":">=","value":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":f"\'{begin_time}\'","isEXPR":true},"command":"AND"},{"field":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"date_format(trace,\'%Y-%m-%d %H:%m:%s\')","isEXPR":true},"operator":"<","value":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":f"\'{end_time}\'","isEXPR":true},"command":"AND"}]}'


# 敲黑板，

# 1 .JSON字符串要打印下来
print(params["where"])
{"conditions":[{"field":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"date_format(trace,'%Y-%m-%d %H:%m:%s')","isEXPR":true},"operator":">=","value":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":f"'{begin_time}'","isEXPR":true},"command":"AND"},{"field":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"date_format(trace,'%Y-%m-%d %H:%m:%s')","isEXPR":true},"operator":"<","value":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":f"'{end_time}'","isEXPR":true},"command":"AND"}]}

# 2. 再复制出来构建日期参数 （）

begin_time = '2024-04-01 00:00:00'
end_time = '2024-04-02 00:00:00'

url = "https://bibfx.flyhsystem.com/datax/api/manage/reportDataPreview"
params = {
    "dashBoardReportId": "0fef1a97-fac6-4bb9-ac52-e352c88130fc",
    "where":{"conditions":[{"field":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"date_format(trace,'%Y-%m-%d %H:%m:%s')","isEXPR":True},"operator":">=","value":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":f"'{begin_time}'","isEXPR":True},"command":"AND"},{"field":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"date_format(trace,'%Y-%m-%d %H:%m:%s')","isEXPR":True},"operator":"<","value":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":f"'{end_time}'","isEXPR":True},"command":"AND"}]}
}


type(params["where"])
dict

params # 字典
{'dashBoardReportId': '0fef1a97-fac6-4bb9-ac52-e352c88130fc',
 'where': {'conditions': [{'field': {'db': 'bibfx_tms',
     'table': 'bibfxuseronline_new',
     'name': "date_format(trace,'%Y-%m-%d %H:%m:%s')",
     'isEXPR': True},
    'operator': '>=',
    'value': {'db': 'bibfx_tms',
     'table': 'bibfxuseronline_new',
     'name': "'2024-04-01 00:00:00'",
     'isEXPR': True},
    'command': 'AND'},
   {'field': {'db': 'bibfx_tms',
     'table': 'bibfxuseronline_new',
     'name': "date_format(trace,'%Y-%m-%d %H:%m:%s')",
     'isEXPR': True},
    'operator': '<',
    'value': {'db': 'bibfx_tms',
     'table': 'bibfxuseronline_new',
     'name': "'2024-04-02 00:00:00'",
     'isEXPR': True},
    'command': 'AND'}]}}
​

STEP4 : dict --> str

begin_time = '2024-04-01 00:00:00'
end_time = '2024-04-12 00:00:00'

url = "https://bibfx.flyhsystem.com/datax/api/manage/reportDataPreview"
params = {
    "dashBoardReportId": "0fef1a97-fac6-4bb9-ac52-e352c88130fc",
    "where":json.dumps({"conditions":[{"field":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"date_format(trace,'%Y-%m-%d %H:%m:%s')","isEXPR":True},"operator":">=","value":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":f"'{begin_time}'","isEXPR":True},"command":"AND"},{"field":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":"date_format(trace,'%Y-%m-%d %H:%m:%s')","isEXPR":True},"operator":"<","value":{"db":"bibfx_tms","table":"bibfxuseronline_new","name":f"'{end_time}'","isEXPR":True},"command":"AND"}]})
}

type(params["where"])
str

params
{'dashBoardReportId': '0fef1a97-fac6-4bb9-ac52-e352c88130fc',
 'where': '{"conditions": [{"field": {"db": "bibfx_tms", "table": "bibfxuseronline_new", "name": "date_format(trace,\'%Y-%m-%d %H:%m:%s\')", "isEXPR": true}, "operator": ">=", "value": {"db": "bibfx_tms", "table": "bibfxuseronline_new", "name": "\'2024-04-01 00:00:00\'", "isEXPR": true}, "command": "AND"}, {"field": {"db": "bibfx_tms", "table": "bibfxuseronline_new", "name": "date_format(trace,\'%Y-%m-%d %H:%m:%s\')", "isEXPR": true}, "operator": "<", "value": {"db": "bibfx_tms", "table": "bibfxuseronline_new", "name": "\'2024-04-12 00:00:00\'", "isEXPR": true}, "command": "AND"}]}'}

#搞定

或者：
在这里插入图片描述
在这里插入图片描述

可视化效果：



url = "https://bibfx.flyhsystem.com/datax/api/manage/reportDataPreview"

begin_time = '2024-04-15 00:00:00'
end_time = '2024-04-18 00:00:00'

params = {
    "dashBoardReportId": "0fef1a97-fac6-4bb9-ac52-e352c88130fc",
    "where": json.dumps({
        "conditions": [
            {
                "field": {
                    "db": "bibfx_tms",
                    "table": "bibfxuseronline_new",
                    "name": f"date_format(trace,'%Y-%m-%d %H:%m:%s')",
                    "isEXPR": True
                },
                "operator": ">=",
                "value": {
                    "db": "bibfx_tms",
                    "table": "bibfxuseronline_new",
                    "name": f"'{begin_time}'",
                    "isEXPR": True
                },
                "command": "AND"
            },
            {
                "field": {
                    "db": "bibfx_tms",
                    "table": "bibfxuseronline_new",
                    "name": f"date_format(trace,'%Y-%m-%d %H:%m:%s')",
                    "isEXPR": True
                },
                "operator": "<",
                "value": {
                    "db": "bibfx_tms",
                    "table": "bibfxuseronline_new",
                    "name": f"'{end_time}'",
                    "isEXPR": True
                },
                "command": "AND"
            }
        ]
    })
}

# 成功

params["where"]
南湖渔歌
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
读取文件、字典（json.dumps（dict）}）
weixin_59818557的博客
04-15 585
一、文件读写 1、'W':可写入，清除文件内容在写入，文件不存在则新建，但不可读取 "w+"：可同时读写，清除文件内容在写入，文件不存在则新建，比如原文件内容”1222“，新写入是”AA“，则文件内容是”AA” "r+":可同时读写，覆盖写入，文件不存在时报错，比如原文件内容”1222“，新写入是”AA“，则文件内容是”AA22” "a+":可同时读写，追加写入，文件不存在则新建 读写： #"w+" file1=r"D:\A_daily\testa.txt" data2=open(file1
序列化json.dumps(dict)和反序列化json.loads(json)
CPS1016347441的博客
10-01 1402
#coding:utf-8 #序列化---json.dumps()和反序列化----json.loads() import json #将 dict==>json 序列化，用json.dumps() #将 json==>dict 反序列，用json.loads() d={"a":"apple","b":"banana"} json_data=json.dumps(d)# dict_d...
python序列化json.dumps(dict)和反序列化json.loads(json):
weixin_42326887的博客
06-06 183
Dict2json、json2dict：序列化json.dumps(dict)和反序列化json.loads(json):代码如下：
Python json 操作
Hero_Never_GIVE_UP的博客
01-12 270
最近需要用到取流操作，在编辑requests.post()请求时需要用到json，记一下基本操作： import json ''' 涉及的数据类型：dict，str 涉及的方法：dump、dumps，load、loads 其他：涉及文件的读写操作，入with open(filename,"r") as f ''' dict 就是python字典，json数据对象看着很像字典，但是json操作的对象是字符串，这是刚接触时容易误犯的错误。字典是字典，在字典外面加单引号就是字符串。json.dump
json.dumps loads 终于区分出来了
盛夏清风的草地
07-15 4万+
每次遇到json loads/dumps始终搞不清方向，写段代码试下： import json dict_ = {1:2, 3:4, "55":"66"} # test json.dumps print type(dict_), dict_ json_str = json.dumps(dict_) print "json.dumps(dict) return:" print type(js
python json.dumps() json.dump()的区别详解
09-16
Python的JSON模块提供了序列化和反序列化JSON数据的功能，其中`json.dumps()`和`json.dump()`是两个常用的方法，但它们在使用上有明显的区别。 `json.dumps()`方法用于将Python对象转换为JSON字符串。例如，如果你...
自学 json.pdf python
08-28
json_str = json.dumps(item, ensure_ascii=False) ``` 这样，`json_str`就是一个可以发送到服务器或写入文件的JSON字符串。 在处理JSON数据时，`indent`参数常用于美化输出，使其更易读。例如，当`json.dump()`的...
json.rar_JSON
09-21
json_str = json.dumps(data) # 将字典转换为JSON字符串 print(json_str) ``` 反过来，如果收到一个JSON字符串，可以使用`json.loads()`将其解析为Python数据结构： ```python json_data = '{"name": "张三", "age...
Json概述以及python对json的相关操作
weixin_33742618的博客
12-14 489
什么是json： JSON(JavaScript Object Notation) 是一种轻量级的数据交换格式。易于人阅读和编写。同时也易于机器解析和生成。它基于JavaScript Programming Language, Standard ECMA-262 3rd Edition - December 1999的一个子集。JSON采用完全独立于语言的文本格式，但是也使用了类似于C语言家族的...
Python JSON - json.dump() 函数使用示例
既然选择了远方 便只顾风雨兼程 - 永强
09-27 4600
Python JSON - json.dump() 函数使用示例
python中json.dumps(dict)中文编码错误
weixin_45828972的博客
05-26 867
python中json.dumps(dict)中文出现编码错误 解析： ①python3里面默认编码是unicode ②做dump与dumps操作时，会默认将中文转换为unicode，但在做逆向操作load和loads时会转换为中文，但是中间态(例如存储的json文件)的中文编码方式仍然是unicode 解决办法： 在dump里面添加 ensure_ascii=False data = json.dumps(dict, ensure_ascii=False) ...
学习笔记——字典（json.dumps和 json.dump）
喵酱
10-17 1274
一、json.dumps和 json.dump 转载自：https://www.cnblogs.com/wswang/p/5411826.html 1.1首先说明基本功能： dumps是将dict转化成str格式，loads是将str转化成dict格式。 dump和load也是类似的功能，只是与文件操作结合起来了。 看代码 import json a={'name': 'wang',...
python3 json.dump 字典和json字符串
qq284489030的博客
04-02 465
import json dict = {'one':1,'two':0,'three':False,'four':None} j = json.dumps(dict) dict2 = json.loads(j) print('================字典进，字典出================') with open('fjson.json','w') as f: json...
json.dumps 和json.dump
qq742820488的博客
06-12 1011
import jsona={'name':'test','age':1}a_json_str=json.dumps(a)    #将dict转储为json的字符串（str）格式a_dict=json.loads(a_json_str)    #将json的str形式转为dict格式#假设有一个json文件a.jsonfp=open('a.json','r')dict_=json.load(fp) ...
python 中Dict 转 Json
shadou0109的专栏
06-18 2万+
最近在公司需要写个小工具
json.dumps()转换dict为json时，可以保留双引号，不变为单引号
火云明月的博客
09-07 9788
问题描述 已知： 有 request_content = [ {“content” : “问题描述” , “category” : “问题”} , {“content” : “今天天气多少度？” , “category” : “问题”} ] 想要得到request给后台的结果。request的方法使用requests.request(url, header=header, data=request...
Python之dict(或对象)与json之间的互相转化
热门推荐
Widsom的博客
10-21 19万+
Python之dict(或对象)与json之间的互相转化在Python语言中，json数据与dict字典以及对象之间的转化，是必不可少的操作。在Python中自带json库。通过import json导入。在json模块有2个方法， loads()：将json数据转化成dict数据 dumps()：将dict数据转化成json数据 load()：读取json文件数据，转成dict数据 dump()：
HTTP Client
最新发布
Mr.xing的博客
07-08 77
从jdk9开始引入HTTP Client 标准化，根据用户的反馈在jdk10开始更新，有了显著的改进，使用方式基本保持不变。通过CompletableFutures提供了非阻塞请求和响应式。流量控制可以在java.util.concurrent.Flow API 提供支持。在jdk9和jdk10时进行时几乎完全重写了实现，实现了完全异步，以前的http1.1实现是阻塞的，RX Flow概念的使用已经实现，现在可以更容易的跟踪数据流：从用户请求发布者和响应订阅者，一直到底层套接字。
python中json.dumps报TypeError: keys must be str, int, float, bool or None, not tuple
05-20
这个错误通常是因为你在使用 `json.dumps()` 函数时，传入了一个字典的键值对中的键是元组类型的数据。 JSON 格式不支持使用元组作为键，只支持字符串、数字、布尔类型和 None 类型作为键。 可以通过将元组类型的键转换为字符串类型来解决这个问题。例如，如果字典中的键是元组类型，可以使用 `str()` 函数将其转换为字符串类型，再将结果作为新的键，如下所示： ```python import json my_dict = {('name', 'first'): 'John', ('name', 'last'): 'Doe', 'age': 42} new_dict = {} for key, value in my_dict.items(): new_key = str(key) new_dict[new_key] = value json.dumps(new_dict) ``` 这里我们先创建一个新的空字典 `new_dict`，然后遍历原始字典 `my_dict` 中的每一个键值对，将键转换为字符串类型并作为新的键添加到新字典 `new_dict` 中，最后使用 `json.dumps()` 函数将新字典转换为 JSON 格式的字符串。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值