ReQL command line interface

Run RethinkDB ReQL commands in the terminal.

Makes it easy to both look at your data in a nice colorized format.

If you pipe the output to another program, it turns off the colors and condenses the JSON to one document per line for easy processing with other tools like jq

Installation

$ pip install reql_cli

Usage

$ rql --help
usage: rql [-h] [--port PORT] [--host HOST] [--db DB] [--pagesize PAGESIZE]
           QUERY

Run ReQL commands in the terminal. If the output is being piped, will print
one document per line and not use color

positional arguments:
  QUERY                 ReQL query to run

optional arguments:
  -h, --help            show this help message and exit
  --port PORT, -p PORT  RethinkDB driver port
  --host HOST, -t HOST  RethinkDB host address
  --db DB, -d DB        default database for queries
  --pagesize PAGESIZE, -g PAGESIZE
                        Documents per page. No effect on piped output

Examples:

Create a new table:

$ rql 'r.table_create("widgets")'
{
    "created": 1
}

Ran:
 r.table_create('posts')

Slurp in data from some api:

$ rql 'r.table("posts").insert(r.http("jsonplaceholder.typicode.com/posts"))'
{
    "deleted": 0,
    "errors": 0,
    "inserted": 100,
    "replaced": 0,
    "skipped": 0,
    "unchanged": 0
}

Ran:
 r.table('widgets').insert(r.http('jsonplaceholder.typicode.com/posts'))

Page through your nice pretty data:

$ rql --pagesize=2 'r.table("posts").without("body")'
{
    "id": 2,
    "title": "qui est esse",
    "userId": 1
}

{
    "id": 15,
    "title": "eveniet quod temporibus",
    "userId": 2
}

[2] Hit any key to continue (or q to quit)...

Piping it out to another process compacts the data for machine consumption (one document per line, no extraneous spaces):

$ rql 'r.table("posts").without("body").limit(5)' | cat
{"userId":1,"id":1,"title":"sunt aut faceret"}
{"userId":1,"id":4,"title":"eum et est occaecati"}
{"userId":1,"id":2,"title":"qui est esse"}
{"userId":1,"id":6,"title":"dolorem eum magni eos aperiam quia"}
{"userId":1,"id":7,"title":"magnam facilis autem"}

OK, that's pretty great. What else?

Uhh, you could use your RethinkDB server as a calculator if you want:

$ rql '1 + 3 + (4 * 3)'
16

Ran:
 16

Bugs