@Test public void script42_Date() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( ne( person.dateValue(), new DateTime( "2010-03-04T14:24:35", forID( "CET" ) ).toDate() ) ) ); System.out.println( "*** script42_Date: " + query ); verifyUnorderedResults( query, "Joe Doe" ); }
@Test public void script41_Date() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( ne( person.dateValue(), new DateTime( "2010-03-04T13:24:35", UTC ).toDate() ) ) ); System.out.println( "*** script41_Date: " + query ); verifyUnorderedResults( query, "Joe Doe" ); }
@Test public void script42_DateTime() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( ne( person.dateTimeValue(), new DateTime( "2010-03-04T14:24:35", forID( "CET" ) ) ) ) ); System.out.println( "*** script42_DateTime: " + query ); verifyUnorderedResults( query, "Jack Doe", "Joe Doe" ); }
@Test public void script42_LocalDate() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( ne( person.localDateValue(), new LocalDate( "2010-03-04", forID( "CET" ) ) ) ) ); System.out.println( "*** script42_LocalDate: " + query ); verifyUnorderedResults( query, "Joe Doe" ); }
@Test public void script41_DateTime() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( ne( person.dateTimeValue(), new DateTime( "2010-03-04T13:24:35", UTC ) ) ) ); System.out.println( "*** script41_DateTime: " + query ); verifyUnorderedResults( query, "Joe Doe" ); }
@Test public void script51_BigInteger() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( ne( person.bigInteger(), new BigInteger( "23232323232323232323232323" ) ) ) ); System.out.println( "*** script51_BigInteger: " + query ); verifyUnorderedResults( query, "Jack Doe" ); }
@Test public void script41_LocalDate() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( ne( person.localDateValue(), new LocalDate( "2010-03-04", UTC ) ) ) ); System.out.println( "*** script41_LocalDate: " + query ); verifyUnorderedResults( query, "Joe Doe" ); }
@Test public void script51_BigDecimal() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( ne( person.bigDecimal(), new BigDecimal( "2342.76931348623157e+307" ) ) ) ); System.out.println( "*** script51_BigDecimal: " + query ); verifyUnorderedResults( query, "Jack Doe" ); }
@Test public void script42_LocalDateTime() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( ne( person.localDateTimeValue(), new LocalDateTime( "2010-03-04T13:23:00", forID( "CET" ) ) ) ) ); System.out.println( "*** script42_LocalDateTime: " + query ); verifyUnorderedResults( query, "Joe Doe" ); }
@Test public void script12_ne() throws EntityFinderException { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( ne( person.email(), "joe@thedoes.net" ) ) ); System.out.println( "*** script12_ne: " + query ); verifyUnorderedResults( query ); }
@Test public void script39() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( ne( person.title(), Person.Title.DR ) ) ); System.out.println( "*** script39: " + query ); verifyUnorderedResults( query, "Ann Doe", "Joe Doe" ); }
@Test public void script41_LocalDateTime() { QueryBuilder<Person> qb = this.module.newQueryBuilder( Person.class ); Person person = templateFor( Person.class ); Query<Person> query = unitOfWork.newQuery( qb.where( ne( person.localDateTimeValue(), new LocalDateTime( "2010-03-04T13:23:00", UTC ) ) ) ); System.out.println( "*** script41_LocalDateTime: " + query ); verifyUnorderedResults( query, "Joe Doe" ); }
@Test public void script04_ne() 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( ne( placeOfBirth.name(), "Kuala Lumpur" ) ) ); System.out.println( "*** script04_ne: " + query ); verifyUnorderedResults( query, "Jack Doe" ); }