如何创建从json字符串中获取记录的查询

import json

# 示例JSON字符串
json_str = '''
{
  "employees": [
    {
      "firstName": "John",
      "lastName": "Doe",
      "age": 30,
      "city": "New York"
    },
    {
      "firstName": "Jane",
      "lastName": "Smith",
      "age": 25,
      "city": "San Francisco"
    },
    {
      "firstName": "Bob",
      "lastName": "Johnson",
      "age": 35,
      "city": "Chicago"
    }
  ]
}
'''

# 解析JSON字符串
data = json.loads(json_str)

# 定义查询条件
query = {
    "city": "New York"
}

# 遍历数据结构并提取满足条件的记录
results = []
for employee in data["employees"]:
    if all(employee.get(key) == value for key, value in query.items()):
        results.append(employee)

# 打印结果
for result in results:
    print(result)