python-3.x - 如何在对象 DynamoDB 和 Python 中的列表中搜索对象

Question

我需要一些帮助才能从 DynamoDB 中的嵌套 JSONschema 中获取项目。我会向您解释架构，您可以告诉我是否可行。

架构是:

{
    "updated_at": "2018/05/02 08:32:10",
    "created_at": "2018/05/02 08:32:10",
    "updated_by": "igor",
    "created_by": "igor",
    "application": [
        {
            "name": "driver app",
            "features": [
                {
                    "name": "passenger list",
                    "settings": [],
                    "description": "feature for passenger list",
                    "id": 2
                }
            ],
            "id": 1,
            "url": "play store"
        },
        {
            "name": "passsenger app",
            "features": [],
            "id": 2,
            "url": "play store"
        }
    ],
    "address": "New York",
    "id": 4,
    "url": "https://airlink.moovex.com",
    "name": "airlink",
    "service_locations": [
        {
            "title": "IL",
            "latitude": 32,
            "longitude": 35
        }
    ]
}

我需要通过查询从我的应用程序列表中获取对象。

Answer 1

我不确定这是否能回答您的问题，但是，如果您需要检索具有特定 ID 的对象的应用程序列表，这就是您要做的

import boto3

DyDB = boto3.resource('dynamodb')

table = DyDB.Table('YourTableName')

response = table.query(
    ProjectionExpression='application',
    KeyConditionExpression=Key('id').eq(4) # where 4 is the id you need to query
)

# this is just to test the result
for app in response['Items'][0]['application']:
    print(app['id'])

响应将返回给你(在列表项中)，其中包含应用程序列表的应用程序属性