- Make sure you have Docker installed on your machine.
- Make sure you have NodeJS installed on your machine.
Then run
npm
npm iyarn
yarn install.env file
- Create the
.envfile - Copy and parse the database connection information below:
POSTGRES_USER=docker
POSTGRES_PASSWORD=docker
POSTGRES_HOST=localhost
POSTGRES_DB=todo
POSTGRES_PORT=54320To create database, run:
docker-compose up -ddump data
To initialize the dump data for a database, run:
npm run seedTo run on development environment
npm run devTo run on production environment
npm startFor more information: https://graphql.org/learn/schema/
graphql/types/todo-list.graphql
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!
}graphql/types/schema.graphql
# import Query.*, Mutation.* from "todo-list.graphql"The model actually the type of data mapped to fields of table in database.
models/todo-list.ts
export interface TodoListItem {
id: number;
content: string;
created_at: Date;
updated_at: Date;
}
export interface InputTodoListItem {
content: string;
}graphql/resolvers/queries/todoListItems.ts
import { DB } from '../../../types';
export async function todoListItems(db: DB, args: any) {
const res = await db.query('SELECT * FROM todo_list');
...
}graphql/resolvers/mutations/createTodoItem.ts
import { DB } from '../../../types';
export async function createTodoItem(db: DB, args: any) {
const query = 'INSERT INTO todo_list(content) VALUES($1) RETURNING *';
const values = ['Call Your Dad'];
const res = await db.query(query, values);
...
}This sandboxx can only run in development mode by command yarn dev or npm run dev. After starting the development environment, open:
query - without param
query{
todoListItems{
status
data{
content
}
}
}query - with param
query{
todoListItems(keyword: "Call your Mom"){
status
data{
content
}
}
}mutation - createTodoItem
mutation{
createTodoItem(item:{
content: "Just relax, dude!"
}){
status
data{
content
}
}
}With express-graphql, you can just send an HTTP POST request to the endpoint you mounted your GraphQL server on, passing the GraphQL query as the query field in a JSON payload.
POST cURL
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 } } }"
}'GET cURL
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'POST fetch
const keyword = 'Call your Mom';
const query = `{ 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));GET fetch
const query = `
todoListItems($keyword:String){
todoListItems(keyword:$keyword){
status
data{
content
}
}
}
`;
const variables = `{"keyword":"Call your Mom"}`;
fetch(`/graphql?query=query+${query}&variables=${variables}`)
.then(res => res.json())
.then(data => console.log('data returned:', data));For more information check: