Spring Boot + GraphQL + MySQL example with Spring JPA & graphql-spring-boot-starter

GraphQL is a query language that offers an alternative model to developing APIs (REST, SOAP or gRPC) with detailed description.

In this tutorial, we’re gonna build a Spring Boot GraphQL example that will expose CRUD Rest APIs to create, read, update and delete objects in MySQL database with the help of graphql-spring-boot-starter and Spring Data JPA.

Related Post:
– Spring Boot, Spring Data JPA – Building Rest CRUD API example
– Spring Boot Thymeleaf CRUD example
– Documentation: Spring Boot Swagger 3 example
– Unit Test: @DataJpaTest example for Spring Data Repository
– Caching: Spring Boot Redis Cache example

Deployment:
– Deploy Spring Boot App on AWS – Elastic Beanstalk
– Docker Compose: Spring Boot and MySQL example

Spring Boot CRUD GraphQL APIs with MySQL overview

Goal

We have two data models: Author and Tutorial.

Author {
  id: Long
  name: String
  age: Integer
}

Tutorial {
  id: Long
  title: String
  description: String
  author: Author
}

One Author will have many Tutorials, so it is One-to-Many relationship.

The goal of this example is to build a GraphQL APIs to do CRUD operations with MySQL database using only one endpoint: /apis/graphql.

The Spring Boot GraphQL Starter will make GraphQL server running in a short time.

CRUD GraphQL APIs

– Create an Author:

• GraphQL

mutation {
  createAuthor(
    name: "bezkoder",
    age: 27) {
      id name
  }
}

• Response

{
  "data": {
    "createAuthor": {
      "id": "1",
      "name": "bezkoder"
    }
  }
}

– Create a Tutorial:

• GraphQL: we want response including Tutorial id, title and author (name)

mutation {
  createTutorial (
    title: "Tutorial #1",
    description: "Description for Tut#1"
    author: 1)
    {
      id title author { name }
    }
}

• Response

{
  "data": {
    "createTutorial": {
      "id": "1",
      "title": "Tutorial #1",
      "author": {
        "name": "bezkoder"
      }
    }
  }
}

– Read all Authors:

• GraphQL

{
  findAllAuthors{
    id
    name
    age
  }
}

• Response

{
  "data": {
    "findAllAuthors": [
      {
        "id": "1",
        "name": "bezkoder",
        "age": 27
      },
      {
        "id": "2",
        "name": "zKoder",
        "age": 30
      }
    ]
  }
}

– Read all Tutorials:

• GraphQL

{
  findAllTutorials{
    id
    title
    description
    author{
      id
      name
    }
  }
}

• Response

{
  "data": {
    "findAllTutorials": [
      {
        "id": "1",
        "title": "Tutorial #1",
        "description": "Description for Tut#1",
        "author": {
          "id": "1",
          "name": "bezkoder"
        }
      },
      {
        "id": "2",
        "title": "Tutorial #2",
        "description": "Description for Tut#2",
        "author": {
          "id": "1",
          "name": "bezkoder"
        }
      },
      {
        "id": "3",
        "title": "Tutorial #3",
        "description": "Description for Tut#3",
        "author": {
          "id": "2",
          "name": "zKoder"
        }
      }
    ]
  }
}

– Update a Tutorial:

• GraphQL

mutation {
  updateTutorial (
    id: 2
    description: "updated Desc Tut#2")
    {
      id title description author { name }
    }
}

• Response

{
  "data": {
    "updateTutorial": {
      "id": "2",
      "title": "Tutorial #2",
      "description": "updated Desc Tut#2",
      "author": {
        "name": "bezkoder"
      }
    }
  }
}

– Delete a Tutorial:

• GraphQL

mutation {
  deleteTutorial(id: 1)
}

• Response

{
  "data": {
    "deleteTutorial": true
  }
}

– Count number of Tutorials:

• GraphQL

{
  countTutorials
}

• Response

{
  "data": {
    "countTutorials": 2
  }
}

If you check MySQL database, it will have 2 tables: author & tutorial.
The content inside these tables looks like:

mysql> select * from author;
+----+------+----------+
| id | age  | name     |
+----+------+----------+
|  1 |   27 | bezkoder |
|  2 |   30 | zKoder   |
+----+------+----------+


mysql> select * from tutorial;
+----+-----------------------+-------------+-----------+
| id | description           | title       | author_id |
+----+-----------------------+-------------+-----------+
|  2 | updated Desc Tut#2    | Tutorial #2 |         1 |
|  3 | Description for Tut#3 | Tutorial #3 |         2 |
+----+-----------------------+-------------+-----------+

Build Spring Boot GraphQL APIs with MySQL Database

Technology

Our Spring Boot application will use:

• Java 8
• Spring Boot 2 (with Spring Web, Spring Data JPA)
• graphql-spring-boot-starter 5.0.2
• graphql-java-tools 5.2.4
• Maven 3.6.1
• MySQL

Project Structure

This is folders & files structure for our Spring Boot + GraphQL + MySQL application:

– resources/graphql contains .graphqls files that define GraphQL chemas.
– model holds two Entities: Author and Tutorial.
– repository contains Repository interfaces to interact with MySQL database.
– resolver resolves values for query & mutation requests by implementing some Resolver interfaces from GraphQL Java Tools.
– application.properties configures Spring Datasource, Spring Data JPA and GraphQL base Url.
– pom.xml includes dependencies for the whole project.

Set up the project

Create new Spring Boot project using Spring Tool Suite or going to https://start.spring.io/.

Then add these dependencies to pom.xml file:

<dependency>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

<dependency>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-web</artifactId>
</dependency>

<dependency>
	<groupId>com.graphql-java</groupId>
	<artifactId>graphql-spring-boot-starter</artifactId>
	<version>5.0.2</version>
</dependency>

<dependency>
	<groupId>com.graphql-java</groupId>
	<artifactId>graphql-java-tools</artifactId>
	<version>5.2.4</version>
</dependency>

<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<scope>runtime</scope>
</dependency>

Configure Spring Datasource, JPA, GraphQL

Open application.properties and add the following configuration.

spring.datasource.url= jdbc:mysql://localhost:3306/testdb?useSSL=false
spring.datasource.username= root
spring.datasource.password= 123456

spring.jpa.properties.hibernate.dialect= org.hibernate.dialect.MySQL5InnoDBDialect
spring.jpa.hibernate.ddl-auto= update

# Graphql
graphql.servlet.mapping: /apis/graphql

By default, Spring Boot GraphQL starter exposes the GraphQL Service on /graphql endpoint for HTTP POST requests containing the GraphQL payload. In the code above, we config the endpoint with new base url: /apis/graphql.

Create GraphQL Schema

We’re gonna split up your schema into two .graphqls files. The Spring Boot GraphQL starter will automatically find these schema files.

Under src/main/resources folder, create author.graphqls and tutorial.graphqls files.

author.graphqls

type Author {
	id: ID!
	name: String!
	age: Int
}

# Root
type Query {
	findAllAuthors: [Author]!
	countAuthors: Long!
}

# Root
type Mutation {
	createAuthor(name: String!, age: Int): Author!
}

GraphQL accepts only one root Query and one root Mutation types, so we need to bring all the query and mutation operations into the root Types. But in the schemas above, we want to split the logic for each model. How to do this? We extend the Query and Mutation types.

tutorial.graphqls

type Tutorial {
	id: ID!
	title: String!
	description: String
	author: Author
}

extend type Query {
	findAllTutorials: [Tutorial]!
	countTutorials: Long!
}

extend type Mutation {
	createTutorial(title: String!, description: String, author: ID!): Tutorial!
	updateTutorial(id: ID!, title: String, description: String): Tutorial!
	deleteTutorial(id: ID!): Boolean
}

The “!” at the end of some fields indicates non-nullable type. If we don’t use it, GraphQL accepts null value in the response.

Define Data Models

Now we define twom main models with One-to-Many Relationship in model package:

• Author: id, name, age
• Tutorial: id, title, description, author_id

Author.java

package com.bezkoder.springgraphql.mysql.model;

import javax.persistence.*;
// import jakarta.persistence.*; // for Spring Boot 3

@Entity
public class Author {
  @Id
  @GeneratedValue(strategy = GenerationType.AUTO)
  private Long id;

  @Column(name = "name", nullable = false)
  private String name;

  @Column(name = "age")
  private Integer age;

  public Author() {
  }

  public Author(Long id) {
    this.id = id;
  }

  public Author(String name, Integer age) {
    this.name = name;
    this.age = age;
  }

  public Long getId() {
    return id;
  }

  public String getName() {
    return name;
  }

  public void setName(String name) {
    this.name = name;
  }

  public Integer getAge() {
    return age;
  }

  public void setAge(Integer age) {
    this.age = age;
  }

  @Override
  public String toString() {
    return "User [id=" + id + ", name=" + name + ", age=" + age + "]";
  }

}

Tutorial.java

package com.bezkoder.springgraphql.mysql.model;

import javax.persistence.*;
// import jakarta.persistence.*; // for Spring Boot 3

@Entity
public class Tutorial {
  @Id
  @GeneratedValue(strategy = GenerationType.AUTO)
  private Long id;

  @Column(name = "title", nullable = false)
  private String title;

  @Column(name = "description")
  private String description;

  @ManyToOne
  @JoinColumn(name = "author_id", nullable = false, updatable = false)
  private Author author;

  public Tutorial() {
  }

  public Tutorial(String title, String description, Author author) {
    this.title = title;
    this.description = description;
    this.author = author;
  }

  public Long getId() {
    return id;
  }

  public String getTitle() {
    return title;
  }

  public void setTitle(String title) {
    this.title = title;
  }

  public String getDescription() {
    return description;
  }

  public void setDescription(String description) {
    this.description = description;
  }

  public Author getAuthor() {
    return author;
  }

  public void setAuthor(Author author) {
    this.author = author;
  }

  @Override
  public String toString() {
    return "Tutorial [id=" + id + ", title=" + title + ", description=" + description + ", author=" + author + "]";
  }

}

Create Repositories

In repository package, create two interfaces that implement JpaRepository.

AuthorRepository.java

package com.bezkoder.springgraphql.mysql.repository;

import org.springframework.data.jpa.repository.JpaRepository;

import com.bezkoder.springgraphql.mysql.model.Author;

public interface AuthorRepository extends JpaRepository<Author, Long> {

}

TutorialRepository.java

package com.bezkoder.springgraphql.mysql.repository;

import org.springframework.data.jpa.repository.JpaRepository;

import com.bezkoder.springgraphql.mysql.model.Tutorial;

public interface TutorialRepository extends JpaRepository<Tutorial, Long> {

}

Once we extends the JpaRepository, Spring Data JPA will automatically generate implementation with find, save, delete, count methods for the entities.

Implement GraphQL Root Query Resolver

Every field in the schema root query should have a method in the Query Resolver class with the same name.

Now look back to the schemas we defined above.

# author.graphqls
type Query {
	findAllAuthors: [Author]!
	countAuthors: Long!
}

# tutorial.graphqls
extend type Query {
	findAllTutorials: [Tutorial]!
	countTutorials: Long!
}

This Query class implements GraphQLQueryResolver.

resolver/Query.java

package com.bezkoder.springgraphql.mysql.resolver;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import com.bezkoder.springgraphql.mysql.model.Author;
import com.bezkoder.springgraphql.mysql.model.Tutorial;
import com.bezkoder.springgraphql.mysql.repository.AuthorRepository;
import com.bezkoder.springgraphql.mysql.repository.TutorialRepository;
import com.coxautodev.graphql.tools.GraphQLQueryResolver;

@Component
public class Query implements GraphQLQueryResolver {
  private AuthorRepository authorRepository;
  private TutorialRepository tutorialRepository;

  @Autowired
  public Query(AuthorRepository authorRepository, TutorialRepository tutorialRepository) {
    this.authorRepository = authorRepository;
    this.tutorialRepository = tutorialRepository;
  }

  public Iterable<Author> findAllAuthors() {
    return authorRepository.findAll();
  }

  public Iterable<Tutorial> findAllTutorials() {
    return tutorialRepository.findAll();
  }

  public long countAuthors() {
    return authorRepository.count();
  }

  public long countTutorials() {
    return tutorialRepository.count();
  }

}

Implement GraphQL Root Mutation Resolver

Mutation class will implement GraphQLMutationResolver.
Just like Query Resolver, every field in the schema mutation query should have a method in the Mutation Resolver class with the same name.

resolver/Mutation.java

package com.bezkoder.springgraphql.mysql.resolver;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import com.bezkoder.springgraphql.mysql.model.Author;
import com.bezkoder.springgraphql.mysql.model.Tutorial;
import com.bezkoder.springgraphql.mysql.repository.AuthorRepository;
import com.bezkoder.springgraphql.mysql.repository.TutorialRepository;
import com.coxautodev.graphql.tools.GraphQLMutationResolver;

import javassist.NotFoundException;

@Component
public class Mutation implements GraphQLMutationResolver {
  private AuthorRepository authorRepository;
  private TutorialRepository tutorialRepository;

  @Autowired
  public Mutation(AuthorRepository authorRepository, TutorialRepository tutorialRepository) {
    this.authorRepository = authorRepository;
    this.tutorialRepository = tutorialRepository;
  }

  public Author createAuthor(String name, Integer age) {
    Author author = new Author();
    author.setName(name);
    author.setAge(age);

    authorRepository.save(author);

    return author;
  }

  public Tutorial createTutorial(String title, String description, Long authorId) {
    Tutorial tutorial = new Tutorial();
    tutorial.setAuthor(new Author(authorId));
    tutorial.setTitle(title);
    tutorial.setDescription(description);

    tutorialRepository.save(tutorial);

    return tutorial;
  }

  public boolean deleteTutorial(Long id) {
    tutorialRepository.deleteById(id);
    return true;
  }

  public Tutorial updateTutorial(Long id, String title, String description) throws NotFoundException {
    Optional<Tutorial> optTutorial = tutorialRepository.findById(id);

    if (optTutorial.isPresent()) {
      Tutorial tutorial = optTutorial.get();

      if (title != null)
        tutorial.setTitle(title);
      if (description != null)
        tutorial.setDescription(description);

      tutorialRepository.save(tutorial);
      return tutorial;
    }

    throw new NotFoundException("Not found Tutorial to update!");
  }

}

Implement GraphQL Field Resolver

For complex fields like author in Tutorial, we have to resolve the value of those fields.
TutorialResolver implements GraphQLResolver interface and has getAuthor() method.

resolver/TutorialResolver.java

package com.bezkoder.springgraphql.mysql.resolver;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import com.bezkoder.springgraphql.mysql.model.Author;
import com.bezkoder.springgraphql.mysql.model.Tutorial;
import com.bezkoder.springgraphql.mysql.repository.AuthorRepository;
import com.coxautodev.graphql.tools.GraphQLResolver;

@Component
public class TutorialResolver implements GraphQLResolver<Tutorial> {
  @Autowired
  private AuthorRepository authorRepository;

  public TutorialResolver(AuthorRepository authorRepository) {
    this.authorRepository = authorRepository;
  }

  public Author getAuthor(Tutorial tutorial) {
    return authorRepository.findById(tutorial.getAuthor().getId()).orElseThrow(null);
  }
}

If the client want to get a Tutorial without author field, the GraphQL Server will never do the work to retrieve it. So the getAuthor() method above will never be executed.

Run & Check result

Run Spring Boot application with command: mvn spring-boot:run

Tables will be automatically generated in Database.
If you check MySQL database, you can see them:

mysql> describe author;
+-------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| id    | bigint(20)   | NO   | PRI | NULL    |       |
| age   | int(11)      | YES  |     | NULL    |       |
| name  | varchar(255) | NO   |     | NULL    |       |
+-------+--------------+------+-----+---------+-------+


mysql> describe tutorial;
+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| id          | bigint(20)   | NO   | PRI | NULL    |       |
| description | varchar(255) | YES  |     | NULL    |       |
| title       | varchar(255) | NO   |     | NULL    |       |
| author_id   | bigint(20)   | NO   | MUL | NULL    |       |
+-------------+--------------+------+-----+---------+-------+

For checking result, you can use Postman to make HTTP POST request to http://localhost:8080/apis/graphql.

Conclusion

As an alternative approach to REST APIs, GraphQL minimize complexity between client & server.

Today we’ve learned how to use Spring Boot GraphQL Starter and the GraphQL Java Tools to build GraphQL Rest Apis. Our Spring Boot project also can communicate with MySQL database using Spring Data JPA.

Happy learning! See you again.

Further Reading

• GraphQL documentation
• https://www.graphql-java.com/tutorials/getting-started-with-spring-boot/
• graphql-java Github

Deployment:
– Deploy Spring Boot App on AWS – Elastic Beanstalk
– Docker Compose: Spring Boot and MySQL example

Documentation: Spring Boot + Swagger 3 example (with OpenAPI 3)

Source Code

You can find the complete source code for this tutorial on Github.

– Unit Test: @DataJpaTest example for Spring Data Repository
– Documentation: Spring Boot + Swagger 3 example (with OpenAPI 3)
– Caching: Spring Boot Redis Cache example