AWS DynamoDB CLI Tutorial

Veröffentlicht am: 11 Juni 2021
auf dem Kanal: In The Cloud

4,394

In this video we will create a DynamoDB Database using the AWS CLI.

Instructions on installing the AWS CLI:: https://docs.aws.amazon.com/cli/lates...

Commands used in this video:
get the default region
aws configure get default.region

dynamodb cli help
aws dynamodb help

create a table with the Primary Key of "author" (partition key) and "title" (sort key):
aws dynamodb create-table \
--table-name books \
--attribute-definitions AttributeName=author,AttributeType=S AttributeName=title,AttributeType=S \
--key-schema AttributeName=author,KeyType=HASH AttributeName=title,KeyType=RANGE \
--provisioned-throughput ReadCapacityUnits=1,WriteCapacityUnits=1

list tables

add an item to the table
aws dynamodb put-item \
--table-name books \
--item '{
"author": {"S": "tom"},
"title": {"S": "book 1"},
"yearPublished": {"N": "2000"}
}' \
--return-consumed-capacity TOTAL

list items in your table
aws dynamodb scan --table-name books

put another item in the table
aws dynamodb put-item \
--table-name books \
--item '{
"author": {"S": "tom"},
"title": {"S": "book 2"},
"published": {"N": "2000"}
}' \
--return-consumed-capacity TOTAL

remove the attribute "published" from an item
aws dynamodb update-item \
--table-name books \
--key '{"author":{"S":"tom"},"title":{"S":"book 2"}}' \
--update-expression 'REMOVE published' \
--return-values ALL_NEW \
--return-consumed-capacity TOTAL

update an item to add the yearPublished attribute
aws dynamodb update-item \
--table-name books \
--key '{"author":{"S":"tom"},"title":{"S":"book 2"}}' \
--update-expression 'SET yearPublished = :t' \
--expression-attribute-values '{":t" : { "N": "1989" } }' \
--return-values ALL_NEW \
--return-consumed-capacity TOTAL

update an item to add publish date, display only updated values
aws dynamodb update-item \
--table-name books \
--key '{"author":{"S":"tom"},"title":{"S":"book 2"}}' \
--update-expression 'SET yearPublished = :t' \
--expression-attribute-values '{":t" : { "N": "1900" } }' \
--return-values UPDATED_NEW \
--return-consumed-capacity TOTAL

json file contents for batch write command below
{
"books": [
{
"PutRequest": {
"Item": {
"author": {
"S": "jane"
},
"title": {
"S": "my first book"
},
"yearPublished": {
"N": "2000"
}
}
}
},
{
"PutRequest": {
"Item": {
"author": {
"S": "jane"
},
"title": {
"S": "my second book"
},
"yearPublished": {
"N": "2001"
}
}
}
}
]
}

batch write an item from a json file
aws dynamodb batch-write-item --request-items file://books.json \
--return-consumed-capacity TOTAL

this doesn't work as we need to include the entire primary key, not just part of it
aws dynamodb get-item \
--table-name books \
--key '{"author":{"S":"tom"}}'

projection-expression allows us to retrieve only specific values
aws dynamodb get-item \
--table-name books \
--key '{"author":{"S":"tom"},"title":{"S":"book 1"}}' \
--consistent-read \
--projection-expression "title" \
--return-consumed-capacity TOTAL

another projection-expression example where we retrieve two values
aws dynamodb get-item \
--table-name books \
--key '{"author":{"S":"tom"},"title":{"S":"book 1"}}' \
--consistent-read \
--projection-expression "title,yearPublished" \
--return-consumed-capacity TOTAL

example query where we query by the partition key
aws dynamodb query \
--table-name books \
--key-condition-expression "author = :name" \
--expression-attribute-values '{":name":{"S":"tom"}}'

example query using hte partition key and sort key
aws dynamodb query \
--table-name books \
--key-condition-expression "author = :name" \
--expression-attribute-values '{":name":{"S":"jane"}}'

display information about the table
aws dynamodb describe-table --table-name books

delete an item from the database using the partition and sort key
aws dynamodb delete-item --table-name books \
--key '{"author":{"S":"tom"},"title":{"S":"book 2"}}' \
--return-value ALL_OLD

delete the entire table
aws dynamodb delete-table --table-name books

Auf dieser Seite können Sie das Online-Video AWS DynamoDB CLI Tutorial mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer In The Cloud 11 Juni 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 4,394 Mal angesehen und es wurde von 37 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

54,509