Unable to update data using where() about laravel-dynamodb

[Geet2312]

Thank you @zoe-edwards for enlightening me. This facade implementation will do for me 👍.

[zoe-edwards]

The way DynamoDB works is that you can only update one item at a time, so an update all isn’t really possible. Hence this package does not support that type of query.

[Geet2312]

Hi, I'm using a composite key, can you give me an example of how to update data using the model? I am asking this because I fail to update the data following the documentation.

[zoe-edwards]

Did you follow the instructions for Composite Keys?

You need

protected $primaryKey = 'customer_id';
protected $compositeKey = ['customer_id', 'agent_id'];

in your model, then you can use it like so:

$model->find(['customer_id' => 'value1', 'agent_id' => 'value2']);

[Geet2312]

Yes, I did follow the instruction and this implementation $model->find(['customer_id' => 'value1', 'agent_id' => 'value2'])->update($attributes); works perfectly fine now. But this update is done by performing two operations, right?

1. Scan operation to find the data
2. UpdateItem operation to update the data
   Please, correct me if I'm wrong.

[zoe-edwards]

Yeah the nature of Laravel and Eloquent is that it’ll fetch anything that you find.

If you’re using the $compositeKey correctly, that will perform a Query, not a Scan.

If you want, you can directly use the DynamoDb facade – but it’s not something that fits in with the Eloquent way of working.

use BaoPham\DynamoDb\Facades\DynamoDb;

$key // string
$attribute // string
$value

DynamoDb::table('YourTable')
    ->setKey(DynamoDb::marshalItem(['id' => $key]))
    ->setUpdateExpression('SET #a = :v')
    ->setExpressionAttributeName('#a', $attribute)
    ->setExpressionAttributeValue(':v', DynamoDb::marshalValue($value))
    ->setReturnValues('ALL_NEW')
    ->prepare(DynamoDb::client('aws_connection'))
    ->updateItem();

And that will write without a read.