如何增改DynamoDB条目：创建或向列表属性追加元素（Python/boto3）

Looks like you're trying to build an upsert logic for DynamoDB where you either create a new item with a single-element list (if the partition key doesn't exist) or append a new string to an existing list (if the key does exist). Let's get that code working correctly with boto3.

Working Code with boto3 Client #

If you're using the low-level DynamoDB client (which requires explicit data type markers like S for strings, L for lists), here's the complete implementation:

import boto3

# Set up your DynamoDB client
ddb_client = boto3.client('dynamodb')

# Replace these with your actual values
target_table = "your-table-name"
partition_key_value = "encrypted-hashed-pw-value"
new_list_item = "test"

response = ddb_client.update_item(
    TableName=target_table,
    Key={
        'email-hash': {'S': partition_key_value}
    },
    UpdateExpression="SET attribute_list = if_not_exists(attribute_list, :initial_list) + :new_element",
    ExpressionAttributeValues={
        ':initial_list': {'L': [{'S': new_list_item}]},  # Initialize list with one item if it doesn't exist
        ':new_element': {'L': [{'S': new_list_item}]}     # The item to append (wrapped in a list)
    },
    ReturnValues="UPDATED_NEW"  # Optional: returns the updated list for verification
)

print("Updated item response:", response)

Simplified Version with boto3 Resource #

If you prefer a more Pythonic approach without manual data type markers, use the DynamoDB resource instead:

import boto3

# Set up DynamoDB resource and table
ddb_resource = boto3.resource('dynamodb')
table = ddb_resource.Table(target_table)

response = table.update_item(
    Key={
        'email-hash': partition_key_value
    },
    UpdateExpression="SET attribute_list = if_not_exists(attribute_list, :initial_list) + :new_element",
    ExpressionAttributeValues={
        ':initial_list': [new_list_item],
        ':new_element': [new_list_item]
    },
    ReturnValues="UPDATED_NEW"
)

Key Logic Breakdown #

Let's walk through what makes this work:

• if_not_exists Function: Checks if the attribute_list exists on the item. If not, it initializes the list with :initial_list (your single string wrapped in a list). If the list does exist, it returns the existing list.
• List Append with + Operator: DynamoDB uses the + operator to append lists. By adding :new_element (your string wrapped in a list) to the result of if_not_exists, we either append to an existing list or create a new one with the initial item.
• ReturnValues: Setting this to UPDATED_NEW gives you back the updated attribute_list value, which is helpful for debugging or verifying the operation worked.

Verification #

• When the email-hash partition key doesn't exist: A new item is created, and attribute_list is set to ["test"].
• When the email-hash exists: The new string is appended to the end of attribute_list (e.g., if it was ["test"], it becomes ["test", "test"] after the update).

内容的提问来源于stack exchange，提问作者matthewcummings516