Add Querydsl support
Tip submitted by @omrzljak
In some cases Spring Data query possibilities are not enough to make your queries. You can use @Query
annotation and write your own. Some of us like to write type safe queries like Querydsl provides.
Generated Predicate classes
An important part of Querydsl are generated domain classes for queries so called Predicate. In case of spring-data-mongodb these are generated by the Java annotation post processing tool.
Gradle plugin
There is also Gradle plugin for Querydsl which supports configuration for spring-data-mongodb.
Maven plugin
There is also a plugin for Maven. Maven configuration is fully described in the chapter Maven integration of the documentation. You also need to perform the steps below.
Note: Do not include the org.slf4j
dependency because it is included in Spring Boot.
Changes
build.gradle
Add the Querydsl plugin
configuration to build.gradle
buildscript {
repositories {
jcenter()
}
dependencies {
classpath "com.ewerk.gradle.plugins:querydsl-plugin:1.0.3"
}
}
apply plugin: "com.ewerk.gradle.plugins.querydsl"
querydsl {
// we use mongodb
springDataMongo = true
}
compile "com.mysema.querydsl:querydsl-mongodb:3.6.0"
Note we use MongoDB but Querydsl plugin supports also more options.
If you run gradle build
you will see output like this
Note: Generating net.jogat.names.domain.QName for [net.jogat.names.domain.Name]
For every domain class which is annotated with @Document Querydsl plugin will generate one Predicate class.
pom.xml
After adding com.mysema.maven:apt-maven-plugin
to your project, you need to edit org.bsc.maven:maven-processor-plugin
. You have to add the directory with generated classes of apt-maven-plugin
to configuration of maven-processor-plugin
, for example:
<plugin>
<groupId>org.bsc.maven</groupId>
<artifactId>maven-processor-plugin</artifactId>
<version>2.2.4</version>
<configuration>
<defaultOutputDirectory>
${project.build.directory}/generated-sources/java
</defaultOutputDirectory>
<additionalSourceDirectories>
<additionalSourceDirectory>
${project.build.directory}/generated-sources/java
</additionalSourceDirectory>
</additionalSourceDirectories>
...
</configuration>
...
</plugin>
Change Repository classes
If you have a domain class for example Name
, then you have also a NameRepository
class. You have to change every Repository class to extend from QueryDslPredicateExecutor
.
public interface NameRepository extends MongoRepository<Name, String>, QueryDslPredicateExecutor<Name> {
This will extend your repository class with extra methods supporting Querydsl (see )
Web support
To extend the rest controller for support parameterized request, you have to add com.mysema.query.types.Predicate
annotated with org.springframework.data.querydsl.binding.QuerydslPredicate
to the method parameters:
@RestController
@RequestMapping("/api")
class NameResource {
@Inject
NameRepository nameRepository;
@RequestMapping(value = "/names",
method = RequestMethod.GET,
produces = MediaType.APPLICATION_JSON_VALUE)
@Timed
public ResponseEntity<List<Name>> getAllNames(@QuerydslPredicate(root = Name.class) Predicate predicate,
Pageable pageable) {
log.debug("REST request to get a page of Name");
Page<Name> page = nameRepository.findAll(predicate, pageable);
HttpHeaders headers = PaginationUtil.generatePaginationHttpHeaders(page, "/api/names");
return new ResponseEntity<>(page.getContent(), headers, HttpStatus.OK);
}
...
}
Also in NameResourceIntTest
you have to support QuerydslPredicateArgumentResolver
:
public class NameResourceIntTest {
...
@Inject
private QuerydslPredicateArgumentResolver querydslPredicateArgumentResolver;
@PostConstruct
public void setup() {
MockitoAnnotations.initMocks(this);
NameResource nameResource = new nameResource();
ReflectionTestUtils.setField(nameResource, "nameRepository", nameRepository);
this.restNameMockMvc = MockMvcBuilders.standaloneSetup(nameResource)
.setCustomArgumentResolvers(pageableArgumentResolver, querydslPredicateArgumentResolver)
.setMessageConverters(jacksonMessageConverter).build();
}
...
}
More details can be found in the documentation.
Write type safe queries
Gradle or maven plugins have generated class QName which can be used for writing queries for Name.class. Here is Java example:
QName name = QName.name;
// count all names whose list "categorie" contains string "TOP_EVER"
nameRepository.count(name.categories.contains("TOP_EVER"));