Metadata-Version: 2.1
Name: RockSQL
Version: 1.0.0
Summary: An SQL shell for executing Rockset queries.
Home-page: https://github.com/gadhagod/RockSQL
Author: Aarav Borthakur
Author-email: gadhaguy13@gmail.com
License: UNKNOWN
Platform: UNKNOWN
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Requires-Python: >=3.6
Description-Content-Type: text/markdown
Requires-Dist: rockset
Requires-Dist: colorama

# RockSQL
An SQL shell for executing Rockset queries.

## Installation

    pip3 install RockSQL

## Usage
1. Authentication:
```shell
$ export `ROCKSET_TOKEN`=[API key] `ROCKSET_SERVER`=[API server]```
```
**Note**: You can also authorize using `rsql [API key] [API server]` in the next step.

2. Enter the shell:
```shell
$ rsql
```

3. Execute a query

```shell
$ SELECT * FROM my_collection
```

4. Exit

```shell
$ exit
```

#### Shell commands
* `help`
* `cls`/`clear`
* `exit` (^D)

#### Save results
To save query results to a file, append `>` to the end of your query.

    $ SELECT * FROM my_collection > collection.json

