python使用.format格式化json格式的入参

python使用.format格式化json格式的入参

(.format只适合格式化只有一层{}的参数,例如像这种的有多层的{}字典形式data= {data:{"name":{name},"gender":{gender}}},无法格式化)

sql = "select * from userinfo where t.name = {name} and t.gender = {gender}"
req_data = {"name": "zhangsan", "gender": "man"}
res_data = sql.format(**req_data)
print(res_data )
# 结果:select * from userinfo where t.name = zhangsan and t.gender = man