Filtering

Filtering is a Scala GraphQL investigation project called upon to find out how to properly filter queries in Scala GraphQL.

Libraries

Play Framework: https://www.playframework.com/documentation/2.8.x/Home

Play JSON: https://www.playframework.com/documentation/2.8.x/ScalaJson

Dependency Injection with Guice: https://www.playframework.com/documentation/2.8.x/ScalaDependencyInjection

Slick: https://scala-slick.org/doc/3.3.3/

Sangria (GraphQL): https://sangria-graphql.github.io/learn/

Running

The following command will start up Play in development mode:

sbt "~run 9990"

Creating tables

This project uses MySQL database driver compatible with Percona database. To create the test tables, run init.sql against the database.

Running queries

The first query for testing purposes:

query  {
  ordersCounts(limit: 5, offset: 0, date: "1990-01-01", filters: {
    field: "name",
    like: "yellow"
  }
  ) {
    ordersList {
      id,
      name,
      userId,
      expectedDeliveryDate,
      createdAt,
      updatedAt,
      isDeleted,
      userInfo {
        id,
        email,
        verified,
        birthdate,
        createdAt,
        updatedAt,
        isDeleted
      }
    }
    count
  }
}

The goal

The goal is to find a generalized way to filter GraphQL queries and keep the GraphQL fetchers working effectively, i.e. fetchers have to apply filters before executing database queries.