Getting started

npm i

yarn install

.env file

POSTGRES_USER=dockerPOSTGRES_PASSWORD=dockerPOSTGRES_HOST=localhostPOSTGRES_DB=todoPOSTGRES_PORT=54320

Database

docker-compose up -d

Seeding data

npm run seed

Development

npm run dev

Production

npm start

How to write GraphQL

1. Define the schema & type

type ResponseTodoList {  status: String!  message: String!  data: [TodoListItem]}type TodoListItem {  id: ID!  content: String!}input InputTodoListItem {  content: String!}type Query {  todoListItems(keyword: String): ResponseTodoList!}type Mutation {  createTodoItem(item: InputTodoListItem): ResponseTodoList!}

2. Register *.graphql in schema.graphql

# import Query.*, Mutation.* from "todo-list.graphql"

3. Define models for data

exportinterfaceTodoListItem{id:number;content:string;created_at:Date;updated_at:Date;}exportinterfaceInputTodoListItem{content:string;}

4. Implement the resolvers

import{DB}from'../../../types';exportasyncfunctiontodoListItems(db:DB,args:any){constres=awaitdb.query('SELECT * FROM todo_list');  ...}

import{DB}from'../../../types';exportasyncfunctioncreateTodoItem(db:DB,args:any){constquery='INSERT INTO todo_list(content) VALUES($1) RETURNING *';constvalues=['Call Your Dad'];constres=awaitdb.query(query,values);  ...}

Playground

query{  todoListItems{    status    data{      content    }  }}

query{  todoListItems(keyword:"Call your Mom"){    status    data{      content    }  }}

mutation{  createTodoItem(item:{    content:"Just relax, dude!"  }){    status    data{      content    }  }}

Usage

curl -X POST \  http://localhost:4000/graphql \  -H'Content-Type: application/json' \  -H'Postman-Token: c011dc94-6f67-483a-84cb-2bd4ed442a95' \  -H'cache-control: no-cache' \  -d'{"query": "{ todoListItems{ data { content } } }"}'

curl -X GET \'http://localhost:4000/graphql?query=query+todoListItems%28$keyword:String%29{todoListItems%28keyword:$keyword%29{status}}&variables={%22keyword%22:%22Call%20your%20Mom%22}' \  -H'Postman-Token: f92396a4-4f51-47f0-ac20-3c900289358f' \  -H'cache-control: no-cache'

constkeyword='Call your Mom';constquery=`{ todoListItems(keyword: "${keyword}"){ data { content } } }`;fetch('/graphql',{method:'POST',headers:{'Content-Type':'application/json',Accept:'application/json',},body:JSON.stringify({ query}),}).then(res=>res.json()).then(data=>console.log('data returned:',data));

constquery=`  todoListItems($keyword:String){    todoListItems(keyword:$keyword){      status      data{        content      }    }  }`;constvariables=`{"keyword":"Call your Mom"}`;fetch(`/graphql?query=query+${query}&variables=${variables}`).then(res=>res.json()).then(data=>console.log('data returned:',data));

References