Querying a DynamoDB with Python

Question

When querying a DynamoDB table, the code works fine for a valid entry (msisdn) however, for non-existent entries it does crash.

import boto3
from botocore.exceptions import ClientError

dynamodb = boto3.resource('dynamodb')
table = dynamodb.Table('PhoneList')

# Phone Number 
# -> Existent: 44790000000
msisdn = 44790000000

try:
    response = table.get_item(Key={'MSISDN': msisdn})
    
    name = response['Item']['Name']
    ID = str(response['Item']['ID'])
    birth = response['Item']['Birth']
    
except ClientError as e:
    print(e.response['Error']['Message'])
    print("Phone number not found")
    exit(-1)

print("Phone:", msisdn)
print("Name:", name)
print("ID:", id)
print("Birth:", birth)

Invalid Entry

Traceback (most recent call last):
  File "dyn.py", line 15, in <module>
    name = response['Item']['Name']
KeyError: 'Item'

Database

I think I might not handled correctly the Exception?

Cyril Jouve · Accepted Answer · 2020-08-30 10:18:15Z

1

from the documentation

If there is no matching item, GetItem does not return any data and there will be no Item element in the response.

so you need to catch KeyError instead of ClientError.

answered Aug 30, 2020 at 10:18

Cyril Jouve

1,0607 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Querying a DynamoDB with Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related