如何将值附加到 AWS DynamoDB 上的列表属性?
问题描述
我将 DynamoDB 用作 K-V db(因为没有太多数据,我认为这很好),并且V"的一部分是列表类型(大约 10 个元素).有一些会话可以为其附加一个新值,但我无法在 1 个请求中找到执行此操作的方法.我的做法是这样的:
I'm using DynamoDB as an K-V db (cause there's not much data, I think that's fine) , and part of 'V' is list type (about 10 elements). There's some session to append a new value to it, and I cannot find a way to do this in 1 request. What I did is like this:
item = self.list_table.get_item(**{'k': 'some_key'})
item['v'].append('some_value')
item.partial_save()
我先请求服务器,修改值后保存.这不是原子的,看起来很丑.有没有办法在一个请求中做到这一点?
I request the server first and save it after modified the value. That's not atomic and looks ugly. Is there any way to do this in one request?
解决方案
以下代码应该适用于boto3:
The following code should work with boto3:
table = get_dynamodb_resource().Table("table_name")
result = table.update_item(
Key={
'hash_key': hash_key,
'range_key': range_key
},
UpdateExpression="SET some_attr = list_append(some_attr, :i)",
ExpressionAttributeValues={
':i': [some_value],
},
ReturnValues="UPDATED_NEW"
)
if result['ResponseMetadata']['HTTPStatusCode'] == 200 and 'Attributes' in result:
return result['Attributes']['some_attr']
这里的get_dynamodb_resource方法就是:
The get_dynamodb_resource method here is just:
def get_dynamodb_resource():
return boto3.resource(
'dynamodb',
region_name=os.environ['AWS_DYNAMO_REGION'],
endpoint_url=os.environ['AWS_DYNAMO_ENDPOINT'],
aws_secret_access_key=os.environ['AWS_SECRET_ACCESS_KEY'],
aws_access_key_id=os.environ['AWS_ACCESS_KEY_ID'])
相关文章