Query-by-example skip primitives?

user_1194415 0
Viewed 2473

Spring supports creating queries by examples of the object to look for. Like:

//if not setting the age, it will always look for age=0
Person p = new Person();
p.setLastName("Smith");
List<Person> foundPersons = personRepository.findAll(Example.of(p));

@Entity
public class Person {
  private String firstName;
  private String lastName;
  private LocalDate dob;
  private int age;
}

Problem: if the @Entity has primitive fields, then their default value will actually be used for creating the query. The example above will result in:

SELECT * from persons where lastname := 'Smith' and age := 0

In my example I have a database field where age must always be filled, thus is not allowed to be null. Therefore the entity has a primitive int age field.

Of course I could now change the field to Integer age, but then I'd marking the field being an optional nullable attribute, which is not true.

So, how can I skip primitives that have not been set on the Example?

Reference Example

spring-data-jpa spring java
3 Answers

I use reactive java and spring data. Here is repository:

public interface MyObjectRepository extends ReactiveCrudRepository<MyObject, Long>, ReactiveQueryByExampleExecutor<MyObject> {}

Service:

public Mono<Page<MyObject>> getAllBySupport(Pageable pageable, Boolean isSupported) {
   ExampleMatcher m;
   Example<MyObject> ex;

   if (isSupported != null) {
      m = ExampleMatcher.matching().withIgnoreNullValues();
      ex = Example.of(MyObject.builder().isSupport(isSupported).build(), m);
   } else {
      //isSupport field in Myobject has boolean primitive type
      //if parameter isSupported is null - I ignore this parameter in example
      //and result has objects with true and false isSupport field
      m = ExampleMatcher.matching().withIgnorePaths("isSupport").withIgnoreNullValues();
      ex = Example.of(new MyObject(), m);
   }

    return myObjectRepository.findBy(ex, (p) -> p.page(pageable))
            .map(s -> new PageImpl<>(s.stream()
                    .collect(Collectors.toList()), pageable, s.getTotalElements()));

With this code you also can hava pagination and sorting

Wish you luck:)

user_192121970

In Spring boot, i was getting primitives as 0. so i have solved as below 

     ExampleMatcher matcher = ExampleMatcher.matching().withIgnorePaths("parentId");//ignore primitives
     Example<ConfigMetadata> configExample = Example.of(config, matcher);
     if(config.getParentId()!=null && config.getParentId() != 0) { //if primitives other than null/zero, create new example which includes them
        configExample.getProbe().setParentId(config.getParentId());
        configExample = Example.of(configExample.getProbe());
     }
user_64590980
Related