python - 在 Python 3 中替换字典中的多个值

Question

我想替换字典列表中的多个值。示例:

# this will set the schema and table dynamically based on the input.
input = {'schema_name': 'test_schema', 'stage_table': 'test_table'}
# need to replace the schemaname and stagetable from the input dict
output = [{id:100, 'query':'SELECT DISTINCT column FROM ${SchemaName}.${StageTable}'}]
# desired output
final_output = select distinct column_name from test_schema.test_table

Answer 1

字符串有一个format方法，但是你需要调整变量名:

# this will set the schema and table dynamically based on the input.
fill = {'schema_name': 'test_schema', 'stage_table': 'test_table'}
# need to replace the schemaname and stagetable from the input dict
output = [{id:100, 'query':'SELECT DISTINCT column FROM ${schema_name}.${stage_table}'}]

我调整了 input 数组中和你的名字，以便它们与你的字符串的签名相匹配。现在我将向您展示如何使用 format:

output[0]['query'].format(**fill)
#'SELECT DISTINCT column FROM $test_schema.$test_table'

得到你想要的结果。