simpledb - Amazon SimpleDB command line interface
version 1.0600
simpledb [opts] create-domain DOMAIN simpledb [opts] delete-domain DOMAIN simpledb [opts] list-domains simpledb [opts] put DOMAIN ITEM [NAME=VALUE]... simpledb [opts] put-replace DOMAIN ITEM [NAME=VALUE]... simpledb [opts] get DOMAIN ITEM simpledb [opts] delete DOMAIN ITEM [NAME[=VALUE]]... simpledb [opts] select SELECTEXPRESSION
--help Print help and exit. --http-proxy-host --http-proxy-port --sdb-service-url URL Defaults to https://sdb.amazonaws.com/ Alternatives: http://docs.aws.amazon.com/general/latest/gr/rande.html#sdb_region --aws-access-key-id KEY AWS access key id [Defaults to $AWS_ACCESS_KEY_ID environment variable] --aws-secret-access-key SECRETKEY AWS secret access key [Defaults to $AWS_SECRET_ACCESS_KEY environment variable] --max COUNT Maximum number of domains/items to retrieve and list. [Defaults to all] --separator STRING Separator between attribute name and value. [Defaults to equals (=)]
DOMAIN Domain name ITEM Item name NAME Attribute name VALUE Attribute value SELECTEXPRESSION SimpleDB select expression
This utility provides a simple command line interface to most Amazon SimpleDB (SDB) actions.
# The following examples assume you have set these environment variables:
export AWS_ACCESS_KEY_ID=... export AWS_SECRET_ACCESS_KEY=... export SDB_SERVICE_URL=https://sdb.eu-west-1.amazonaws.com
# Create a new SimpleDB domain:
simpledb create-domain mydomain
# List the domains for this account:
simpledb list-domains
# Create some items with attribute name=value pairs:
simpledb put mydomain item1 key1=valueA key2=value2 x=why simpledb put mydomain item2 key1=valueB key2=value2 y=zee
# Add another value for an attribute on an item:
simpledb put mydomain item2 y=zed when=now who=you
# Replace all values for specific attributes on an item:
simpledb put-replace mydomain item1 key1=value1 newkey=newvalue
# Delete all values for specific attributes on an item:
simpledb delete mydomain item1 x
# Delete specific values for specific attributes on an item:
simpledb delete mydomain item2 who=you
# List all item names in a domain - note backquotes around domain
simpledb select 'select itemName() from `my-domain`'
# List all items and their attributes matching a given select query:
simpledb select 'select * from mydomain where key2="value2"'
# List all attributes on an item:
simpledb get mydomain item1 simpledb get mydomain item2
# Delete the entire SimpleDB domain including all items and attributes:
simpledb delete-domain mydomain
AWS_ACCESS_KEY_ID Default AWS access key id AWS_SECRET_ACCESS_KEY Default AWS secret access key SDB_SERVICE_URL Default https://sdb.amazonaws.com/ Alternatives: http://docs.aws.amazon.com/general/latest/gr/rande.html#sdb_region
$HOME/.awssecret If the above fail, then the keys are sought here in the format expected by the "aws" toolkit (one per line): access_key_id secret_access_key /etc/passwd-s3fs If all of the above fail, then the keys are sought here in the format expected by s3fs (colon separated): access_key_id:secret_access_key
As currently written this tool does not support keys containing equal signs (=).
Output will be difficult to parse if the values contain newlines.
2013-09-11 Andrew Solomon <andrew at illywhacker dot net> - Rebased on SimpleDB::Client - Removed proxying - Removed attribute parameters from "get" 2010-04-20 Eric Hammond <ehammond@thinksome.com> - Removed support for "query". Please migrate to "select" 2009-09-01 Peter Kaminski <kaminski@istori.com> - Added utf8 binmode for STDOUT - Added select method 2009-03-16 Eric Hammond <ehammond@thinksome.com> - Fix --max options and large result sets without --max http://code.google.com/p/amazon-simpledb-cli/issues/detail?id=2 2008-06-09 Eric Hammond <ehammond@thinksome.com> - Fallback to finding keys in $HOME/.awssecret or /etc/passwd-s3fs 2008-06-03 Eric Hammond <ehammond@thinksome.com> - Completed --max option - bugfix: Corrected --aws-secret-access-key option spelling 2008-05-26 Eric Hammond <ehammond@thinksome.com> - Original release
To install SimpleDB::Client, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SimpleDB::Client
CPAN shell
perl -MCPAN -e shell install SimpleDB::Client
For more information on module installation, please visit the detailed CPAN module installation guide.