stephane-klein / poc-postgraphile-forum Goto Github PK

5.0 1.0 0.0 172 KB

POC Postgraphile - forum example

Dockerfile 0.78% PLpgSQL 85.46% Shell 1.58% TSQL 8.74% JavaScript 2.89% HTML 0.55%

poc postgresql graphql postgraphile

poc-postgraphile-forum's Introduction

POC Postgraphile - forum example

Roadmap:

$ ./scripts/start-pg-and-wait-starting.sh
$ ./scripts/seed.sh
$ ./scripts/fixtures.sh

$ docker-compose up -d

Urls:

Query

{
  posts {
    nodes {
      id
      headline
      body
      summary
      authorId
    }
  }
}

Authenticate

mutation {
  authenticate(input: {email: "[email protected]", password: "password"}) {
    clientMutationId
    jwtToken
  }
}

Result:

{
  "data": {
    "authenticate": {
      "clientMutationId": null,
      "jwtToken": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJyb2xlIjoiZm9ydW1fZXhhbXBsZV9wZXJzb24iLCJwZXJzb25faWQiOiIxZGU5Yzk4Ny0wOGFiLTMyZmUtZTIxOC04OWMxMjRjZDAwMDEiLCJpYXQiOjE1NjQzMTk3ODgsImV4cCI6MTU2NDQwNjE4OCwiYXVkIjoicG9zdGdyYXBoaWxlIiwiaXNzIjoicG9zdGdyYXBoaWxlIn0.SxpP_2s8sG1-3Qc8aV9N1-A99oBPoqv1W_8BfKoYBtY"
    }
  }
}

Use JWT Token in header

{
"Authorization": "bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJyb2xlIjoiZm9ydW1fZXhhbXBsZV9wZXJzb24iLCJwZXJzb25faWQiOiIxZGU5Yzk4Ny0wOGFiLTMyZmUtZTIxOC04OWMxMjRjZDAwMDEiLCJpYXQiOjE1NjQzMTk3ODgsImV4cCI6MTU2NDQwNjE4OCwiYXVkIjoicG9zdGdyYXBoaWxlIiwiaXNzIjoicG9zdGdyYXBoaWxlIn0.SxpP_2s8sG1-3Qc8aV9N1-A99oBPoqv1W_8BfKoYBtY"
}

Create a post

mutation {
  createPost(input: {post: {headline: "headline 1", authorId: "1de9c987-08ab-32fe-e218-89c124cd0001", body: "body1", topic: DISCUSSION}}) {
    clientMutationId
    post {
      id
      author {
        firstName
        id
      }
    }
  }
}

Result:

{
  "data": {
    "createPost": {
      "clientMutationId": null,
      "post": {
        "id": "b6799d54-ac68-4170-9b62-3536921bb164",
        "author": {
          "firstName": "first_name001",
          "id": "1de9c987-08ab-32fe-e218-89c124cd0001"
        }
      }
    }
  }
}

Test worker

$ ./scripts/enter-in-pg.sh
poc-forum=# SELECT graphile_worker.add_job('hello', json_build_object('name', 'Bobby Tables'));
                                                                                        add_job
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 (1,ec43b4ee-f950-402e-8fa4-b223388c00bf,hello,"{""name"" : ""Bobby Tables""}",0,"2019-08-09 11:23:56.034334+00",0,25,,"2019-08-09 11:23:56.034334+00","2019-08-09 11:23:56.034334+00")
(1 row)

See graphile-worker logs:

$ docker-compose logs -f graphile-worker
graphile-worker_1  | Worker connected and looking for jobs... (task names: 'hello')
graphile-worker_1  | Hello, Bobby Tables
graphile-worker_1  | Completed task 1 (hello) with success (0.53ms)

Recommend Projects