Querying dynamoDB with a list of elements

Question

I need to design a script that queries dynamoDB with a list of elements.

I've already tried looping over every element of the list, and querying that element and appending the result, but I was wondering if there is a more efficient way of performing that operation.

KeyConditionExpression=Key('id').eq('occupation') & Key('sort').begins_with(locations + '#' + occup + '#' + contract)

The code I've shown above performs a query for a single location, but instead of just one I wonder if I use the list and sort of lower the number of queries.

E.G.

locations = ['Glasgow','London']

and the result of this to be elements with both locations.

mucio · Accepted Answer · 2019-08-26 12:53:15Z

1

You are looking for the batch_get_item method, check this question here for an example and the boto3 documentation here.

answered Aug 26, 2019 at 12:53

mucio

7,1271 gold badge23 silver badges36 bronze badges

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

1 Comment

Mario Vasilev Over a year ago

That's exactly what I was looking for!

Collectives™ on Stack Overflow

Querying dynamoDB with a list of elements

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related