@Test
@RunOrder(10)
public void queryMaxTest() {
EntityManager em = emf.createEntityManager();
try {
// ============= Query construction ============== //
JpaQueryStream<Long> stream =
JpaQueryProvider.select(em, Person.class)
.where()
.equal(Person::getPersonalNo, Person::getAddrress)
.and()
.like(Person::getLastName, "lname%", 'e')
.and()
.startsWith(Person::getLastName, "lname")
.max(Person::getPersonId);
String sql = stream.sql();
System.out.println(sql);
Long max = stream.firstOrDefault(Long.valueOf(0));
// =============================================//
System.out.println();
System.out.println("-------Entity----");
System.out.println(max);
} finally {
em.close();
}
}
@Test
@RunOrder(9)
public void queryLikeFieldTest() {
EntityManager em = emf.createEntityManager();
try {
// ============= Query construction ============== //
JpaQueryStream<Person> stream =
JpaQueryProvider.select(em, Person.class)
.where()
.equal(Person::getPersonalNo, Person::getAddrress)
.and()
.like(Person::getLastName, GeneralInfo::getFullName, Person::getEscape)
.and()
.startsWith(Person::getLastName, "lname");
String sql = stream.sql();
System.out.println(sql);
Person person = stream.firstOrDefault(new Person());
// =============================================//
System.out.println();
System.out.println("-------Entity----");
System.out.println(person);
} finally {
em.close();
}
}