qldbshell 0.1.0

A basic CLI for interacting with Amazon QLDB

Amazon QLDB Shell

This tool provides an interface to send PartiQL statements to Amazon Quantum Ledger Database (QLDB). This tool is not intended to be incorporated into an application or adopted for production purposes. The objective of the tool is to give developers, devops, database administrators, and anyone else interested the opportunity for rapid experimentation with QLDB and PartiQL.

Prerequisites

Basic Configuration

See Accessing Amazon QLDB for information on connecting to AWS.

Python 3.4 or later

The driver requires Python 3.4 or later. Please see the link below for more detail to install Python:

• Python Installation

Getting Started

Install the QLDB Shell using pip:

pip install qldbshell

Invocation

The shell can then be invoked by using the following command:

$ qldbshell --region <region_code> --ledger <ledger_name>

An example region code that can be used is us-east-1. The currently avaiable regions are addressed in the QLDB General Reference page. By default, the shell will use the credentials specified as environment variables and then in the default profile mentioned in ~/.aws.credentials/ and then in ~/.aws/credentials. Various optional arguments can be added to override the profile, endpoints, and region used. To view the arguments, execute the following:

$ qldbshell --help

Example Usage

Assuming that the ledger, "test-ledger" has already been created:

$ qldbshell --region us-east-1 --ledger test-ledger
qldbshell> CREATE TABLE TestTable
qldbshell> INSERT INTO TestTable `{"Name": "John Doe"}` 
qldbshell> SELECT * FROM TestTable
qldbshell> quit

We use backticks in the example above since we use are using Ion literals. For more on querying Ion literals, go here. Each statement between connect and disconnect is considered as a transaction.

See also

1. Amazon QLDB accepts and stores Amazon ION Documents. Amazon Ion is a richly-typed, self-describing, hierarchical data serialization format offering interchangeable binary and text representations. For more information read the ION docs.
2. Amazon QLDB supports the PartiQL query language. PartiQL provides SQL-compatible query access across multiple data stores containing structured data, semistructured data, and nested data. For more information read the PartiQL docs.
3. We use backticks in our example since we use are using Ion literals. For more on querying Ion with PartiQL, go here.

Development

Setting up the Shell

After cloning this repository, activate a virtual environment and install the package by running:

$ virtualenv venv
...
$ . venv/bin/activate
$ pip install -r requirements.txt
$ pip install -e .

Release Notes

Preview release of the shell. The release supports single line statements and couple of experiences may change in future with the addition of new features

License

This tool is licensed under the Apache 2.0 License.