dynamodb notes

updateallitems.py

import boto3

dynamodb = boto3.resource('dynamodb')

table = dynamodb.Table('table')

response = table.scan(
    ProjectionExpression='#k,#s',
    ExpressionAttributeNames={
        '#k' : 'id', #partition key
        '#s' : 'sortkey' #sort key
    }
)

items = response['Items']

for item in items:
    response = table.update_item(
        Key=item,
        UpdateExpression='SET #s = :status, #d = :del',
        ExpressionAttributeNames={
            '#s' : 'status',
            '#d' : 'deleted'
        },
        ExpressionAttributeValues={
            ':status' : 'live',
            ':del'    : False
        }

    )

Hi @sunnycyk does this take care of pagination?

@andresvia no. You need to check if LastEvaluatedKey is in the scan response to know if the results have been paginated. Then the last evaluated key should be provided in the next scan as ExclusiveStartKey.