python用var构造字符串

Question

我有以下字典，其中Incoming Inspection Report是表名。

querystring = {"q":"Select * from "Incoming Inspection Report"","format":"json","headers":"true","metadata":"true","arrays":"false","page":"1","per_page":"20000"}

如何动态地为多个表构建querystring?我试过.format字符串，

table_name = 'Incoming Inspection Report'
querystring = '{"q":"Select * from "{table}"","format":"json","headers":"true","metadata":"true","arrays":"false","page":"1","per_page":"20000"}'.format(table=table_name)

但不工作。

Answer 1

你试过使用f字符串吗?

table_name_1 = 'Incoming Inspection Report'
querystring1 = {"q":f"Select * from "{table_name_1}"","format":"json","headers":"true","metadata":"true","arrays":"false","page":"1","per_page":"20000"}
table_name_2 = 'Table name 2'
querystring2 = {"q":f"Select * from "{table_name_2}"","format":"json","headers":"true","metadata":"true","arrays":"false","page":"1","per_page":"20000"}

Answer 2

我想下面就是你要找的

table_name = 'my_table'
querystring = {"q": f"Select * from {table_name}", "format": "json", "headers": "true",
"metadata": "true", "arrays": "false", "page": "1", "per_page": "20000"}
print(querystring.get('q'))

输出

Select * from my_table