# Hasura

[Hasura](https://hasura.io/) is an open source engine that connects to your databases & microservices and auto-generates a production-ready GraphQL backend.

## Setup

- Install [Docker](https://docs.docker.com/install/)
- Install [Docker Compose](https://docs.docker.com/compose/install/)
- Install the [Hasura CLI](https://hasura.io/docs/1.0/graphql/manual/hasura-cli/install-hasura-cli.html)

### Generate JWT Config

https://hasura.io/jwt-config/

Paste the generated JWT Config into docker-compose.yaml.

**TODO: Don't commit this into the repo**

```yaml
environment:
  # ...
  HASURA_GRAPHQL_JWT_SECRET: "{...}"
```

## Run

```bash
docker-compose up -d
```

## Console

Run a web server to serve the Hasura console for the GraphQL engine to manage the database and build queries.

```bash
hasura console --admin-secret myadminsecretkey
```

Accessing the console via http://localhost:9695/ automatically adds database migration and metadata files on changes ([docs](https://hasura.io/docs/1.0/graphql/manual/migrations/index.html#how-is-hasura-state-managed)).

## Migrations

### Apply all

```bash
hasura migrate apply --admin-secret myadminsecretkey
```

### Down

```bash
hasura migrate apply --admin-secret myadminsecretkey --down N
```

### Apply metadata

```bash
hasura metadata apply --admin-secret myadminsecretkey
```

### Recreate DB

Run only postgres (not hasura)

```bash
docker-compose up postgres
```

Drop the DB

```bash
docker-compose exec postgres dropdb postgres -U postgres
```

Create the DB

```bash
docker-compose exec postgres createdb postgres -U postgres
```