# astore

astore is a simple library and CLI program to query and manipulate a file hierarchy of JSON files.

## Commands

### `astore repl`

```console
$ cabal run astore -- repl
>>> SELECT * FROM c
{"foo":"bar","id":1,"j_id":1}
{"id":2,"j_id":3}
>>> SELECT * FROM j
{"id":1,"is_j":true}
{"id":2,"is_j":true}
>>> SELECT c.id, j.id, is_j FROM c LEFT JOIN j ON j.id == c.j_id
{"c":{"id":1},"is_j":true,"j":{"id":1}}
{"c":{"id":2},"is_j":null,"j":{"id":null}}
>>> SELECT c.id, j.id FROM c RIGHT JOIN j ON j.id == c.j_id
{"c":{"id":1},"j":{"id":1}}
{"c":{"id":null},"j":{"id":2}}
>>> SELECT c.id, j.id FROM c FULL JOIN j ON j.id == c.j_id
{"c":{"id":1},"j":{"id":1}}
{"c":{"id":2},"j":{"id":null}}
{"c":{"id":null},"j":{"id":2}}
>>> SELECT c, j FROM c EMBED j ON j.id == c.j_id
{"c":null,"j":[{"id":1,"is_j":true}]}
{"c":null,"j":[]}
```

### `astore serve`

```console
$ cabal run astore -- serve &
$ curl -d 'SELECT * FROM c' http://localhost:8080
[{"foo":"bar","id":1,"j_id":1},{"id":2,"j_id":3}]
```