@Test( expected = NotQueryableException.class ) public void script25() { this.moduleInstance.newQueryBuilder( File.class ); }
@Test public void script04() { final Query<Person> query = unitOfWork.newQuery( this.moduleInstance .newQueryBuilder( Person.class ) .where( queries.get( "script04" ) ) ); System.out.println( "*** script04: " + query ); verifyUnorderedResults( query, "Joe Doe", "Ann Doe" ); }
@Test public void script09() { final Query<Female> query = unitOfWork.newQuery( this.moduleInstance .newQueryBuilder( Female.class ) .where( queries.get( "script09" ) ) ); System.out.println( "*** script09: " + query ); verifyUnorderedResults( query, "Ann Doe" ); }
@Test public void script13() { final Query<Person> query = unitOfWork.newQuery( this.moduleInstance .newQueryBuilder( Person.class ) .where( queries.get( "script13" ) ) ); System.out.println( "*** script13: " + query ); verifyUnorderedResults( query, "Jack Doe" ); }
@Test public void script03() { final Query<Nameable> query = unitOfWork.newQuery( this.moduleInstance .newQueryBuilder( Nameable.class ) .where( queries.get( "script03" ) ) ); System.out.println( "*** script03: " + query ); verifyUnorderedResults( query, "Joe Doe", "Felix", "Ann Doe", "Jack Doe", "Penang", "Kuala Lumpur", "Cooking", "Gaming", "Programming", "Cars" ); }
@Test public void script42_LocalDate() { QueryBuilder<Person> qb = this.moduleInstance.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); LocalDate time = ZonedDateTime.of( 2010, 3, 4, 13, 24, 35, 0, ZoneId.of( "CET" ) ).toLocalDate(); Query<Person> query = unitOfWork.newQuery( qb.where( ne( person.localDateValue(), time ) ) ); System.out.println( "*** script42_LocalDate: " + query ); verifyUnorderedResults( query, "Joe Doe" ); }
@Test public void script42_Instant() { QueryBuilder<Person> qb = this.moduleInstance.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); ZonedDateTime cetTime = ZonedDateTime.of( 2010, 3, 4, 14, 24, 35, 0, ZoneId.of( "CET" ) ); Query<Person> query = unitOfWork.newQuery( qb.where( ne( person.instantValue(), cetTime.toInstant() ) ) ); System.out.println( "*** script42_Instant: " + query ); verifyUnorderedResults( query, "Joe Doe" ); }
@Test public void script24() { final Query<Domain> query = unitOfWork.newQuery( this.moduleInstance .newQueryBuilder( Domain.class ) .where( queries.get( "script24" ) ) ); query.setVariable( "domain", "Gaming" ); System.out.println( "*** script24: " + query ); assertThat( query.find().name().get(), is( equalTo( "Gaming" ) ) ); } }
@Test public void script41_LocalDateTime() { QueryBuilder<Person> qb = this.moduleInstance.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( ne( person.localDateTimeValue(), LocalDateTime.of( 2010, 3, 4, 13, 23, 0 ) ) ) ); System.out.println( "*** script41_LocalDateTime: " + query ); verifyUnorderedResults( query, "Joe Doe" ); }
@Test public void script40_LocalDate() { QueryBuilder<Person> qb = this.moduleInstance.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( eq( person.localDateValue(), LocalDate.of( 2010, 3, 4 ) ) ) ); System.out.println( "*** script40_LocalDate: " + query ); verifyUnorderedResults( query, "Jack Doe" ); }
@Test public void script52_BigDecimal() { QueryBuilder<Person> qb = this.moduleInstance.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( ge( person.bigDecimal(), new BigDecimal( "2342.76931348623157e+307" ) ) ) ); System.out.println( "*** script52_BigDecimal: " + query ); verifyUnorderedResults( query, "Jack Doe", "Joe Doe" ); } }
@Test public void script12() { QueryBuilder<Person> qb = this.moduleInstance.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( isNull( person.email() ) ) ); System.out.println( "*** script12: " + query ); verifyUnorderedResults( query, "Ann Doe", "Jack Doe" ); }
@Test public void script22() { QueryBuilder<Nameable> qb = this.moduleInstance.newQueryBuilder( Nameable.class ); Nameable nameable = templateFor( Nameable.class ); // should return Jack and Joe Doe Query<Nameable> query = unitOfWork.newQuery( qb.where( matches( nameable.name(), "J.*Doe" ) ) ); System.out.println( "*** script22: " + query ); verifyUnorderedResults( query, "Jack Doe", "Joe Doe" ); }
@Test public void script16() { QueryBuilder<Nameable> qb = this.moduleInstance.newQueryBuilder( Nameable.class ); // should return only 2 entities Nameable nameable = templateFor( Nameable.class ); Query<Nameable> query = unitOfWork.newQuery( qb ); query.orderBy( orderBy( nameable.name() ) ); query.maxResults( 2 ); System.out.println( "*** script16: " + query ); verifyOrderedResults( query, "Ann Doe", "Cars" ); }
@Test public void script33() { QueryBuilder<Person> qb = this.moduleInstance.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Domain gaming = unitOfWork.get( Domain.class, StringIdentity.identityOf( "Gaming" ) ); Query<Person> query = unitOfWork.newQuery( qb.where( contains( person.interests(), gaming ) ) ); System.out.println( "*** script33: " + query ); verifyUnorderedResults( query, "Joe Doe" ); }
@Test public void script34() { QueryBuilder<Person> qb = this.moduleInstance.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Female annDoe = unitOfWork.get( Female.class, StringIdentity.identityOf( "anndoe" ) ); Query<Person> query = unitOfWork.newQuery( qb.where( eq( person.mother(), annDoe ) ) ); System.out.println( "*** script34: " + query ); verifyUnorderedResults( query, "Joe Doe" ); }
@Test @SuppressWarnings( "unchecked" ) public void script08() { QueryBuilder<Person> qb = this.moduleInstance.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( or( eq( person.yearOfBirth(), 1970 ), eq( person.yearOfBirth(), 1975 ) ) ) ); System.out.println( "*** script08: " + query ); verifyUnorderedResults( query, "Jack Doe", "Ann Doe" ); }
@Test public void script19() { QueryBuilder<Nameable> qb = this.moduleInstance.newQueryBuilder( Nameable.class ); // should return all Nameable entities with a name > "D" sorted by name Nameable nameable = templateFor( Nameable.class ); Query<Nameable> query = unitOfWork.newQuery( qb.where( gt( nameable.name(), "D" ) ) ); query.orderBy( orderBy( nameable.name() ) ); System.out.println( "*** script19: " + query ); verifyOrderedResults( query, "Felix", "Gaming", "Jack Doe", "Joe Doe", "Kuala Lumpur", "Penang", "Programming" ); }
@Test public void script21() { QueryBuilder<Person> qb = this.moduleInstance.newQueryBuilder( Person.class ); // should return all Persons sorted by name of the city they were born, and then by year they were born Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb ); query.orderBy( orderBy( person.placeOfBirth().get().name() ), orderBy( person.yearOfBirth() ) ); System.out.println( "*** script21: " + query ); verifyOrderedResults( query, "Ann Doe", "Joe Doe", "Jack Doe" ); }
@Test( expected = NotQueryableException.class ) public void script27() { QueryBuilder<Person> qb = this.moduleInstance.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); qb.where( eq( person.personalWebsite().get().host().get().value(), "polygene.apache.org" ) ); }