Multiple actions in one update in DynamoDB - Mini Project: Build & Apply

Multiple Actions in One DynamoDB Update

📖 Scenario: You are managing a simple inventory system for a small store. Each product has a name, quantity in stock, and a list of tags describing the product.Sometimes, you need to update multiple things about a product at once: change the quantity, add a new tag, and update the last restock date.

🎯 Goal: Build a DynamoDB update expression that performs multiple actions in one update: increment the quantity, add a new tag to the tags list, and set the last restock date.

📋 What You'll Learn

Create an update expression that increments the quantity attribute by 10

Add a new tag "sale" to the tags list attribute

Set the last_restock attribute to the string "2024-06-01"

Use a single UpdateItem call with multiple actions in the update expression

💡 Why This Matters

🌍 Real World

In real inventory systems, updating multiple product attributes at once is common to keep data consistent and reduce the number of database calls.

💼 Career

Knowing how to write complex update expressions in DynamoDB is valuable for backend developers and database administrators working with AWS services.

1

Setup the initial item data

Create a dictionary called item representing a product with these exact attributes: product_id set to "P1001", quantity set to 50, tags set to a list containing "new" and "popular", and last_restock set to "2024-05-20".

DynamoDB

# Create the initial item dictionary with product_id, quantity, tags, and last_restock
# Your code here

Need a hint?

Use a Python dictionary with the exact keys and values as described.

2

Prepare the update expression components

Create a variable called update_expression and set it to the string that will increment quantity by 10, add "sale" to the tags list, and set last_restock to "2024-06-01" using DynamoDB update syntax with multiple actions separated by commas.

DynamoDB

item = {
    "product_id": "P1001",
    "quantity": 50,
    "tags": ["new", "popular"],
    "last_restock": "2024-05-20"
}

# Create the update_expression string with multiple actions
# Your code here

Need a hint?

Use SET with multiple actions separated by commas. Use list_append to add to the list.

3

Create the expression attribute values

Create a dictionary called expression_attribute_values with these exact keys and values: :inc set to 10, :new_tag set to a list containing "sale", and :date set to "2024-06-01".

DynamoDB

item = {
    "product_id": "P1001",
    "quantity": 50,
    "tags": ["new", "popular"],
    "last_restock": "2024-05-20"
}

update_expression = "SET quantity = quantity + :inc, tags = list_append(tags, :new_tag), last_restock = :date"

# Create the expression_attribute_values dictionary
# Your code here

Need a hint?

Use a dictionary with the exact keys and values as described.

4

Combine all parts into the final update call

Create a dictionary called update_params with these exact keys and values: Key set to a dictionary with product_id equal to "P1001", UpdateExpression set to the variable update_expression, and ExpressionAttributeValues set to the variable expression_attribute_values.

DynamoDB

item = {
    "product_id": "P1001",
    "quantity": 50,
    "tags": ["new", "popular"],
    "last_restock": "2024-05-20"
}

update_expression = "SET quantity = quantity + :inc, tags = list_append(tags, :new_tag), last_restock = :date"

expression_attribute_values = {
    ":inc": 10,
    ":new_tag": ["sale"],
    ":date": "2024-06-01"
}

# Create the update_params dictionary for the UpdateItem call
# Your code here

Need a hint?

Combine all parts into one dictionary for the update call.