@Test public void script40_Date() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( eq( person.dateValue(), new DateTime( "2010-03-04T13:24:35", UTC ).toDate() ) ) ); System.out.println( "*** script40_Date: " + query ); verifyUnorderedResults( query, "Jack Doe" ); }
@Test @SuppressWarnings( "unchecked" ) public void script08() throws EntityFinderException { QueryBuilder<Person> qb = this.module.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 @SuppressWarnings( "unchecked" ) public void script09() throws EntityFinderException { QueryBuilder<Female> qb = this.module.newQueryBuilder( Female.class ); Person person = templateFor( Person.class ); Query<Female> query = unitOfWork.newQuery( qb.where( or( eq( person.yearOfBirth(), 1970 ), eq( person.yearOfBirth(), 1975 ) ) ) ); System.out.println( "*** script09: " + query ); verifyUnorderedResults( query, "Ann Doe" ); }
@Test public void script40_DateTime() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( eq( person.dateTimeValue(), new DateTime( "2010-03-04T13:24:35", UTC ) ) ) ); System.out.println( "*** script40_DateTime: " + query ); verifyUnorderedResults( query, "Jack Doe" ); }
@Test public void script40_LocalDate() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( eq( person.localDateValue(), new LocalDate( "2010-03-04", UTC ) ) ) ); System.out.println( "*** script40_LocalDate: " + query ); verifyUnorderedResults( query, "Jack Doe" ); }
@Test public void script50_BigInteger() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( eq( person.bigInteger(), new BigInteger( "23232323232323232323232323" ) ) ) ); System.out.println( "*** script50_BigInteger: " + query ); verifyUnorderedResults( query, "Joe Doe" ); }
@Test @Ignore( "Equality on Property<Map<?,?>> not implemented" ) public void script31() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Map<String, String> info = new HashMap<>( 0 ); Query<Person> query = unitOfWork.newQuery( qb.where( eq( person.additionalInfo(), info ) ) ); System.out.println( "*** script31: " + query ); verifyUnorderedResults( query, "Jack Doe" ); }
@Test public void script24() throws EntityFinderException { final QueryBuilder<Domain> qb = this.module.newQueryBuilder( Domain.class ); final Nameable nameable = templateFor( Nameable.class ); final Query<Domain> query = unitOfWork.newQuery( qb.where( eq( nameable.name(), "Gaming" ) ) ); System.out.println( "*** script24: " + query ); assertThat( query.find().name().get(), is( equalTo( "Gaming" ) ) ); }
@Test public void script02() throws EntityFinderException { final QueryBuilder<Domain> qb = this.module.newQueryBuilder( Domain.class ); final Nameable nameable = templateFor( Nameable.class ); final Query<Domain> query = unitOfWork.newQuery( qb.where( eq( nameable.name(), "Gaming" ) ) ); System.out.println( "*** script02: " + query ); verifyUnorderedResults( query, "Gaming" ); }
@Test public void script38() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( eq( person.title(), Person.Title.DR ) ) ); System.out.println( "*** script38: " + query ); verifyUnorderedResults( query, "Jack Doe" ); }
@Test public void script40_LocalDateTime() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( eq( person.localDateTimeValue(), new LocalDateTime( "2010-03-04T13:23:00", UTC ) ) ) ); System.out.println( "*** script40_LocalDateTime: " + query ); verifyUnorderedResults( query, "Jack Doe" ); }
@Test public void script34() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Female annDoe = unitOfWork.get( Female.class, "anndoe" ); Query<Person> query = unitOfWork.newQuery( qb.where( eq( person.mother(), annDoe ) ) ); System.out.println( "*** script34: " + query ); verifyUnorderedResults( query, "Joe Doe" ); }
@Test public void script04() throws EntityFinderException { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person personTemplate = templateFor( Person.class ); City placeOfBirth = personTemplate.placeOfBirth().get(); Query<Person> query = unitOfWork.newQuery( qb.where( eq( placeOfBirth.name(), "Kuala Lumpur" ) ) ); System.out.println( "*** script04: " + query ); verifyUnorderedResults( query, "Joe Doe", "Ann Doe" ); }
@Test public void script10() throws EntityFinderException { Person person = templateFor( Person.class ); // should return Joe and Jack Doe Iterable<EntityReference> entities = entityFinder.findEntities( Person.class, not( eq( person.yearOfBirth(), 1975 ) ), NO_SORTING, NO_FIRST_RESULT, NO_MAX_RESULTS, NO_VARIABLES ); assertNames( entities, JOE, JACK ); }
@Test public void script32() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( eq( person.address().get().line1(), "Qi Alley 4j" ) ) ); System.out.println( "*** script32: " + query ); verifyUnorderedResults( query, "Joe Doe" ); }
@Test @Ignore( "Traversing of NamedAssociations is not implemented" ) public void script37() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( eq( person.accounts().get( "anns" ).number(), "accountOfAnnDoe" ) ) ); System.out.println( "*** script37: " + query ); verifyUnorderedResults( query, "Jack Doe", "Ann Doe" ); }
@Test @SuppressWarnings( "unchecked" ) public void script07() throws EntityFinderException { QueryBuilder<Nameable> qb = this.module.newQueryBuilder( Nameable.class ); Person person = templateFor( Person.class ); Query<Nameable> query = unitOfWork.newQuery( qb.where( and( ge( person.yearOfBirth(), 1900 ), eq( person.placeOfBirth().get().name(), "Penang" ) ) ) ); System.out.println( "*** script07: " + query ); verifyUnorderedResults( query, "Jack Doe" ); }
@Test( expected = NotQueryableException.class ) public void script27() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); qb.where( eq( person.personalWebsite().get().host().get().value(), "www.qi4j.org" ) ); }
@Override public Query<X509Profile> findByNamePaginated( String name, int firstResult, int maxResults ) { QueryBuilder<X509Profile> builder = qbf.newQueryBuilder( getBoxedClass() ); builder = builder.where( eq( templateFor( X509Profile.class ).name(), name ) ); Query<X509Profile> query = builder.newQuery( uowf.currentUnitOfWork() ). firstResult( firstResult ). maxResults( maxResults ); return query; }
@Test( expected = NotQueryableException.class ) public void script28() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); qb.where( eq( person.personalWebsite().get().port().get().value(), 8080 ) ); }