Conditional expressions in DynamoDB - Mini Project: Build & Apply

Using Conditional Expressions in DynamoDB

📖 Scenario: You are managing a simple inventory system for a small store. You want to update the stock quantity of items only if the current stock is above a certain threshold to avoid negative stock.

🎯 Goal: Build a DynamoDB update operation using a conditional expression that updates the stock quantity only if the current stock is greater than 5.

📋 What You'll Learn

Create a DynamoDB table named Inventory with a primary key ItemId.

Insert an item with ItemId 'A101' and Stock 10.

Define a variable min_stock with value 5.

Write an update operation with a conditional expression that updates Stock only if current Stock is greater than min_stock.

💡 Why This Matters

🌍 Real World

Conditional expressions help prevent unwanted data changes in databases, such as avoiding negative stock in inventory systems.

💼 Career

Understanding conditional expressions is important for database administrators and backend developers to maintain data integrity and implement business rules.

1

Create the DynamoDB table and insert an item

Create a DynamoDB table named Inventory with primary key ItemId. Insert an item with ItemId set to 'A101' and Stock set to 10.

DynamoDB

# Create table Inventory with primary key ItemId
# Insert item with ItemId 'A101' and Stock 10

Hint

Define Inventory as a dictionary with table details. Then create items dictionary with ItemId and Stock.

2

Define the minimum stock threshold

Define a variable called min_stock and set it to 5.

DynamoDB

Inventory = {
    'TableName': 'Inventory',
    'KeySchema': [
        {'AttributeName': 'ItemId', 'KeyType': 'HASH'}
    ],
    'AttributeDefinitions': [
        {'AttributeName': 'ItemId', 'AttributeType': 'S'}
    ],
    'ProvisionedThroughput': {
        'ReadCapacityUnits': 5,
        'WriteCapacityUnits': 5
    }
}

items = {
    'ItemId': 'A101',
    'Stock': 10
}

# Define min_stock variable
# Your code here

Hint

Just create a variable named min_stock and assign it the value 5.

3

Write the update operation with conditional expression

Write a dictionary called update_params that represents an update operation on the Inventory table. It should update the Stock attribute to 8 for the item with ItemId 'A101' only if the current Stock is greater than min_stock. Use the key ConditionExpression with the value Stock > :min_stock and define ExpressionAttributeValues accordingly.

DynamoDB

Inventory = {
    'TableName': 'Inventory',
    'KeySchema': [
        {'AttributeName': 'ItemId', 'KeyType': 'HASH'}
    ],
    'AttributeDefinitions': [
        {'AttributeName': 'ItemId', 'AttributeType': 'S'}
    ],
    'ProvisionedThroughput': {
        'ReadCapacityUnits': 5,
        'WriteCapacityUnits': 5
    }
}

items = {
    'ItemId': 'A101',
    'Stock': 10
}

min_stock = 5

# Create update_params dictionary with ConditionExpression and ExpressionAttributeValues
# Your code here

Hint

Use UpdateExpression to set Stock to 8. Use ConditionExpression to check Stock > :min_stock. Define ExpressionAttributeValues with :new_stock and :min_stock.

4

Complete the update operation with return values

Add the key ReturnValues to update_params and set it to ALL_NEW to return the updated item after the update.

DynamoDB

Inventory = {
    'TableName': 'Inventory',
    'KeySchema': [
        {'AttributeName': 'ItemId', 'KeyType': 'HASH'}
    ],
    'AttributeDefinitions': [
        {'AttributeName': 'ItemId', 'AttributeType': 'S'}
    ],
    'ProvisionedThroughput': {
        'ReadCapacityUnits': 5,
        'WriteCapacityUnits': 5
    }
}

items = {
    'ItemId': 'A101',
    'Stock': 10
}

min_stock = 5

update_params = {
    'TableName': 'Inventory',
    'Key': {'ItemId': 'A101'},
    'UpdateExpression': 'SET Stock = :new_stock',
    'ConditionExpression': 'Stock > :min_stock',
    'ExpressionAttributeValues': {
        ':new_stock': 8,
        ':min_stock': min_stock
    }
}

# Add ReturnValues key to update_params
# Your code here

Hint

Add 'ReturnValues': 'ALL_NEW' inside the update_params dictionary.

Practice

1. What is the main purpose of using ConditionExpression in a DynamoDB operation?

easy

A. To create a new table automatically

B. To speed up the query execution

C. To ensure the operation only happens if certain conditions are met

D. To backup data before updating

Solution

1. Step 1: Understand what ConditionExpression does

   ConditionExpression is used to specify rules that must be true for the operation to proceed.

2. Step 2: Identify the purpose in data safety

   This helps prevent unwanted changes by checking conditions before updating or deleting.

3. Final Answer:

   To ensure the operation only happens if certain conditions are met -> Option C

4. Quick Check:

   ConditionExpression controls operation execution [OK]

Hint: ConditionExpression controls when changes happen [OK]

Common Mistakes:

• Thinking it speeds up queries
• Confusing with table creation
• Assuming it backs up data

2. Which of the following is the correct syntax to use a conditional expression that checks if attribute status equals active in a DynamoDB update?

easy

A. ConditionExpression: "status = 'active'"

B. ConditionExpression: "status != 'active'"

C. ConditionExpression: "status == active"

D. ConditionExpression: "#s = :active" with ExpressionAttributeNames and ExpressionAttributeValues

Solution

1. Step 1: Recognize reserved word handling

   Since status can be a reserved word, use placeholders like #s and :active.

2. Step 2: Correct syntax for equality check

   The expression must use single equals = and placeholders, not direct attribute names or double equals.

3. Final Answer:

   ConditionExpression: "#s = :active" with ExpressionAttributeNames and ExpressionAttributeValues -> Option D

4. Quick Check:

   Use placeholders for reserved words [OK]

Hint: Use placeholders (#, :) for reserved words in conditions [OK]

Common Mistakes:

• Using double equals (==) instead of single equals (=)
• Not using placeholders for reserved words
• Using wrong inequality operator

3. Given this DynamoDB update command snippet:

UpdateExpression: "SET #qty = :newQty"
ConditionExpression: "#qty < :maxQty"
ExpressionAttributeNames: {"#qty": "quantity"}
ExpressionAttributeValues: {":newQty": 10, ":maxQty": 20}

What happens if the current quantity is 25?

medium

A. The update fails because condition is false

B. The update throws a syntax error

C. The update ignores the condition and sets quantity to 10

D. The update succeeds and sets quantity to 10

Solution

1. Step 1: Understand the condition check

   The condition requires current quantity to be less than 20 for update to proceed.

2. Step 2: Compare current quantity with maxQty

   Since current quantity is 25, which is not less than 20, the condition fails.

3. Final Answer:

   The update fails because condition is false -> Option A

4. Quick Check:

   Condition false blocks update [OK]

Hint: Update only if condition is true, else it fails [OK]

Common Mistakes:

• Assuming update ignores condition
• Thinking condition causes syntax error
• Believing update always succeeds

4. You wrote this DynamoDB update:

UpdateExpression: "SET total = :p"
ConditionExpression: "total > :min"
ExpressionAttributeValues: {":p": 100, ":min": 50}

But it returns a validation error. What is the likely cause?

medium

A. Using total directly without placeholder in ConditionExpression

B. Using incorrect operator in ConditionExpression

C. Missing ExpressionAttributeNames for reserved word total

D. Missing comma in ExpressionAttributeValues

Solution

1. Step 1: Check if total is reserved

   total is a reserved word in DynamoDB, so it must use a placeholder like #pr.

2. Step 2: Identify missing placeholder usage

   The ConditionExpression uses total directly, causing validation error.

3. Final Answer:

   Using total directly without placeholder in ConditionExpression -> Option A

4. Quick Check:

   Reserved words need placeholders [OK]

Hint: Always use placeholders for reserved words in conditions [OK]

Common Mistakes:

• Ignoring reserved word rules
• Assuming operators cause error
• Overlooking syntax in ExpressionAttributeValues

5. You want to update a user's score only if the current score is less than 100 and the status is active. Which is the correct ConditionExpression to use?

hard

A. "score < 100 AND status = 'active'" without placeholders

B. "#sc < :maxScore AND #st = :activeStatus" with ExpressionAttributeNames {"#sc": "score", "#st": "status"} and ExpressionAttributeValues {":maxScore": 100, ":activeStatus": "active"}

C. "score <= 100 OR status = 'active'" with placeholders

D. "#sc > :maxScore AND #st = :activeStatus" with placeholders

Solution

1. Step 1: Use placeholders for reserved words

   Both score and status can be reserved, so use #sc and #st.

2. Step 2: Combine conditions correctly

   Use AND to require both conditions: score less than 100 and status equals active.

3. Step 3: Use correct operators and values

   Use < for less than, and equals = for status check with placeholders for values.

4. Final Answer:

   "#sc < :maxScore AND #st = :activeStatus" with ExpressionAttributeNames {"#sc": "score", "#st": "status"} and ExpressionAttributeValues {":maxScore": 100, ":activeStatus": "active"} -> Option B

5. Quick Check:

   Use AND with placeholders for multiple conditions [OK]

Hint: Use AND and placeholders for multiple conditions [OK]

Common Mistakes:

• Using OR instead of AND
• Not using placeholders for reserved words
• Using wrong comparison operators