Bael 2826 case insensitive spring data jpa (eugenp#6625)

shubhi22 · maibin · commit 3465c347d50f · 2019-03-31T14:47:52.000-07:00
* BAEL-2826: Case Insensitive Comparison Spring data jpa

* BAEL-2826: Fixing imports
diff --git a/persistence-modules/spring-data-jpa/src/main/java/com/baeldung/passenger/PassengerRepository.java b/persistence-modules/spring-data-jpa/src/main/java/com/baeldung/passenger/PassengerRepository.java
@@ -14,4 +14,7 @@ interface PassengerRepository extends JpaRepository<Passenger, Long>, CustomPass
     List<Passenger> findByLastNameOrderBySeatNumberAsc(String lastName);
     
     List<Passenger> findByLastName(String lastName, Sort sort);
+
+    List<Passenger> findByFirstNameIgnoreCase(String firstName);
+
 }
diff --git a/persistence-modules/spring-data-jpa/src/test/java/com/baeldung/passenger/PassengerRepositoryIntegrationTest.java b/persistence-modules/spring-data-jpa/src/test/java/com/baeldung/passenger/PassengerRepositoryIntegrationTest.java
@@ -1,17 +1,5 @@
 package com.baeldung.passenger;
 
-import static org.hamcrest.MatcherAssert.assertThat;
-import static org.hamcrest.Matchers.contains;
-import static org.hamcrest.core.IsNot.not;
-import static org.junit.Assert.assertEquals;
-import static org.junit.Assert.assertTrue;
-
-import java.util.List;
-import java.util.Optional;
-
-import javax.persistence.EntityManager;
-import javax.persistence.PersistenceContext;
-
 import org.junit.Before;
 import org.junit.Test;
 import org.junit.runner.RunWith;
@@ -24,6 +12,17 @@
 import org.springframework.data.domain.Sort;
 import org.springframework.test.context.junit4.SpringRunner;
 
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+import java.util.List;
+import java.util.Optional;
+
+import static org.hamcrest.MatcherAssert.assertThat;
+import static org.hamcrest.Matchers.contains;
+import static org.hamcrest.core.IsNot.not;
+import static org.junit.Assert.assertEquals;
+import static org.junit.Assert.assertTrue;
+
 @DataJpaTest
 @RunWith(SpringRunner.class)
 public class PassengerRepositoryIntegrationTest {
@@ -152,18 +151,36 @@ public void givenPassengers_whenFindByIgnoringMatcher_thenExpectedReturned() {
         Passenger fred = Passenger.from("Fred", "Bloggs", 22);
         Passenger siya = Passenger.from("Siya", "Kolisi", 85);
         Passenger ricki = Passenger.from("Ricki", "Bobbie", 36);
-    
+
         ExampleMatcher ignoringExampleMatcher = ExampleMatcher.matchingAny().withMatcher("lastName",
-          ExampleMatcher.GenericPropertyMatchers.startsWith().ignoreCase()).withIgnorePaths("firstName", "seatNumber");
-    
+            ExampleMatcher.GenericPropertyMatchers.startsWith().ignoreCase()).withIgnorePaths("firstName", "seatNumber");
+
         Example<Passenger> example = Example.of(Passenger.from(null, "b", null),
-          ignoringExampleMatcher);
-    
+            ignoringExampleMatcher);
+
         List<Passenger> passengers = repository.findAll(example);
-    
+
         assertThat(passengers, contains(fred, ricki));
         assertThat(passengers, not(contains(jill)));
         assertThat(passengers, not(contains(eve)));
         assertThat(passengers, not(contains(siya)));
     }
+
+    @Test
+    public void givenPassengers_whenMatchingIgnoreCase_thenExpectedReturned() {
+        Passenger jill = Passenger.from("Jill", "Smith", 50);
+        Passenger eve = Passenger.from("Eve", "Jackson", 95);
+        Passenger fred = Passenger.from("Fred", "Bloggs", 22);
+        Passenger siya = Passenger.from("Siya", "Kolisi", 85);
+        Passenger ricki = Passenger.from("Ricki", "Bobbie", 36);
+
+        List<Passenger> passengers = repository.findByFirstNameIgnoreCase("FRED");
+
+        assertThat(passengers, contains(fred));
+        assertThat(passengers, not(contains(eve)));
+        assertThat(passengers, not(contains(siya)));
+        assertThat(passengers, not(contains(jill)));
+        assertThat(passengers, not(contains(ricki)));
+
+    }
 }

Original file line number	Diff line number	Diff line change
`@@ -14,4 +14,7 @@ interface PassengerRepository extends JpaRepository<Passenger, Long>, CustomPass`
`14`	`14`	`List<Passenger> findByLastNameOrderBySeatNumberAsc(String lastName);`
`15`	`15`
`16`	`16`	`List<Passenger> findByLastName(String lastName, Sort sort);`
	`17`	`+`
	`18`	`+ List<Passenger> findByFirstNameIgnoreCase(String firstName);`
	`19`	`+`
`17`	`20`	`}`