Skip to main content

Dynamo Mode

Prerequistes

  1. Create an API Key

    note
    Following api key is created under `[email protected]/_system` on https://gdn.paas.macrometa.io with `rw` permissions.

    demo.demok1.1a1aad0f4b000ca4d2d3bdb505298cbb9467b65526b0f79364e61e5f00000000
  2. Download & Install AWS Console CLI

    note
    $ aws --version

    aws-cli/2.0.34 Python/3.7.4 Darwin/19.5.0 botocore/2.0.0dev38
  3. Configure cli using aws configure command.

        (base) ~/demos$ aws configure
    AWS Access Key ID [****************0000]: apikey demo.demok1.1a1aad0f4b000ca4d2d3bdb505298cbb9467b65526b0f79364e61e5f00000000
    AWS Secret Access Key [****************0000]:
    Default region name [us-west-1]:
    Default output format [None]:
    note
    1. For API Keys, put `apikey` as prefix. See above example.
    2. For JWT Tokens, put `bearer` as prefix.

Operations

Create global table

    aws dynamodb create-table \
--table-name Music \
--attribute-definitions \
AttributeName=Artist,AttributeType=S \
AttributeName=SongTitle,AttributeType=S \
--key-schema \
AttributeName=Artist,KeyType=HASH \
AttributeName=SongTitle,KeyType=RANGE \
--provisioned-throughput ReadCapacityUnits=5,WriteCapacityUnits=5 \
--endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo

Create local table

    aws dynamodb create-table \
--table-name Music \
--attribute-definitions \
AttributeName=Artist,AttributeType=S \
AttributeName=SongTitle,AttributeType=S \
--key-schema \
AttributeName=Artist,KeyType=HASH \
AttributeName=SongTitle,KeyType=RANGE \
--provisioned-throughput ReadCapacityUnits=5,WriteCapacityUnits=5 \
--endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo \
--tags Key=Local,Value=True
note

Local tables are allowed only if flag dynamo_local_tables=true for the fabric. This flag can be set in _guestDBs collection for the corresponding geofabric.

List global tables

    aws dynamodb list-global-tables --endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo

List local tables

    aws dynamodb list-tables --endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo
note

list-tables will return local tables when dynamo_local_tables flag is True.

Put items

    aws dynamodb put-item \
--table-name Music \
--item '{"Artist": {"S": "Obscure Indie Band"}, "SongTitle": {"S": "Call Me Today"}}' \
--condition-expression "attribute_not_exists(Artist)" \
--return-values ALL_NEW \
--endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo
    aws dynamodb put-item \
--table-name Music \
--item '{"Artist": {"S": "Luke Combs"}, "SongTitle": {"S": "Tequila"}}' \
--condition-expression "attribute_not_exists(Artist)" \
--return-values ALL_NEW \
--endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo

Batch get item

    aws dynamodb batch-get-item \
--request-items '{"Music": {"Keys": [{"Artist": {"S": "Obscure Indie Band"},"SongTitle": {"S": "Call Me Today"}},{"Artist": {"S": "Luke Combs"},"SongTitle": {"S": "Tequila"}}],"ProjectionExpression":"Artist"}}' \
--return-consumed-capacity TOTAL \
--endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo

Batch write item

   aws dynamodb batch-write-item \
--request-items '{"Music": [{"PutRequest": {"Item": {"Artist": {"S": "TestName1"},"SongTitle": {"S": "The Best1"}}}},{"PutRequest": {"Item": {"Artist": {"S": "TestName2"},"SongTitle": {"S": "The Best2"}}}}]}' \
--return-consumed-capacity INDEXES \
--return-item-collection-metrics SIZE \
--endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo

Scan

    aws dynamodb scan \
--table-name Music \
--filter-expression "Artist = :a" \
--projection-expression "#ST, #AT" \
--expression-attribute-names '{"#ST": "SongTitle","#AT":"Artist"}' \
--expression-attribute-values '{":a": {"S": "TestName1"}}' \
--endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo

Query items

Query All Items:

    aws dynamodb query \
--table-name Music \
--endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo

Query By Artist Name:

    aws dynamodb query \
--table-name Music \
--key-condition-expression "Artist == :name" \
--expression-attribute-values '{":name":{"S":"Luke Combs"}}' \
--endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo

Query By complex conditions:

    aws dynamodb query \
--table-name Music \
--key-condition-expression "Artist == :n1 OR begins_with(Artist, :n2)" \
--expression-attribute-values '{":n1":{"S":"Luke Combs"}, ":n2":{"S":"Obscure"}}' \
--endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo
    aws dynamodb query \
--table-name Music \
--key-condition-expression "Artist == :n1 OR begins_with(Artist, :n2)" \
--filter-expression "#a <> :n1" \
--expression-attribute-names '{"#a": "Artist"}' \
--expression-attribute-values '{":n1":{"S":"Luke Combs"}, ":n2":{"S":"Obscure"}}' \
--endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo

Count items

    aws dynamodb query \
--table-name Music \
--select COUNT \
--endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo

Update item

    aws dynamodb update-item \
--table-name Music \
--key '{"Artist": {"S": "Luke Combs"}, "SongTitle": {"S": "Tequila"}}' \
--update-expression "SET Year = :y, SongTitle = :t" \
--expression-attribute-values '{":y":{"N":"2020"}, ":t":{"S":"Happy Day"}}' \
--return-values ALL_NEW \
--endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo

Query all items

    aws dynamodb query \
--table-name Music \
--endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo

Delete item

    aws dynamodb delete-item \
--table-name Music \
--key '{"Artist": {"S": "Luke Combs"}, "SongTitle": {"S": "Happy Day"}}' \
--return-values ALL_OLD \
--endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo

Delete table

    aws dynamodb delete-table \
--table-name Music \
--endpoint-url https://api-gdn.paas.macrometa.io/_api/dynamo