Dynamo Mode¶

Prerequistes¶

Create an API Key
- Login to your tenant account on https://gdn1.macrometa.io
- Create an API key via REST API. Make a copy of the key.
Note

Following api key is created under demo@macrometa.io/_system on https://gdn1.macrometa.io with rw permissions.
```
    demo.demok1.1a1aad0f4b000ca4d2d3bdb505298cbb9467b65526b0f79364e61e5f00000000
```
Download & Install AWS Console CLI
- URL: https://aws.amazon.com/cli/
- Mac OS: https://awscli.amazonaws.com/AWSCLIV2.pkg
Note

$ aws --version

aws-cli/2.0.34 Python/3.7.4 Darwin/19.5.0 botocore/2.0.0dev38

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

For API Keys, put apikey as prefix. See above example.
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-gdn1.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-gdn1.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-gdn1.macrometa.io/_api/dynamo

List local tables¶

    aws dynamodb list-tables --endpoint-url https://api-gdn1.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-gdn1.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-gdn1.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-gdn1.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-gdn1.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-gdn1.macrometa.io/_api/dynamo

Query items¶

Query All Items:

    aws dynamodb query \
        --table-name Music \
        --endpoint-url https://api-gdn1.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-gdn1.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-gdn1.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-gdn1.macrometa.io/_api/dynamo

Count items¶

    aws dynamodb query \
        --table-name Music \
        --select COUNT \
        --endpoint-url https://api-gdn1.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-gdn1.macrometa.io/_api/dynamo

Query all items¶

    aws dynamodb query \
        --table-name Music \
        --endpoint-url https://api-gdn1.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-gdn1.macrometa.io/_api/dynamo

Delete table¶

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