Install dependencies :
yarn
# or
npm installUpdate src/database.js file with your credentials:
import Knex from 'knex';
export default new Knex({
client: 'mysql2',
connection: {
host : '127.0.0.1',
user : 'root',
password : '',
database : 'express-graphql-example'
}
});Init the database. You can find the SQL script int database.sql.
Run the project :
npm startOpen GraphiQL in your browser http://localhost:8088/graphql
Get list of authors (it will return only first 10 authors!):
query {
authors {
edges {
node {
id
_id
firstName
lastName
}
}
}
}Filter authors based of first name, also return total number of such authors:
query {
authors(firstName: "Robert") {
totalCount
edges {
node {
id
_id
firstName
lastName
}
}
}
}Order authors by first name and last name:
query {
authors(orderBy:[
{
field:FIRST_NAME
direction:ASC
}
{
field:LAST_NAME
direction:ASC
}
]) {
edges {
cursor
node {
_id
firstName
lastName
}
}
}
}Get name of author with ID = 4:
query {
author(id: 4) {
id
_id
firstName
lastName
}
}Get list of quotes:
query {
quotes {
edges {
node {
id
_id
quote
}
}
}
}Create new author:
mutation {
createAuthor(input:{
firstName:"Kent"
lastName:"Beck"
}) {
id
_id
firstName
lastName
}
}Update existing author:
mutation {
updateAuthor(input:{
id: 1
firstName: "JOHN"
lastName: "JOHNSON"
}) {
id
_id
firstName
lastName
}
}Here is a link to an old version, that used sequelize and did not use connections:
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent