/** * @param right * @return */ public BooleanExpression loeAny(CollectionExpression<?, ? super T> right) { return loe(ExpressionUtils.<T>any(right)); }
/** * @param right * @return */ public BooleanExpression loeAll(CollectionExpression<?, ? super T> right) { return loe(ExpressionUtils.<T>all(right)); }
/** * Create a {@code this <= right} expression * * @param <A> * @param right rhs of the comparison * @return {@code this <= right} * @see java.lang.Comparable#compareTo(Object) */ public final <A extends Number & Comparable<?>> BooleanExpression loe(A right) { return loe(ConstantImpl.create(cast(right))); }
/** * Create a {@code from <= this <= to} expression * * @param <A> * @param from * @param to * @return */ public final <A extends Number & Comparable<?>> BooleanExpression between(@Nullable A from, @Nullable A to) { if (from == null) { if (to != null) { return loe(to); } else { throw new IllegalArgumentException("Either from or to needs to be non-null"); } } else if (to == null) { return goe(from); } else { return between(ConstantImpl.create(cast(from)), ConstantImpl.create(cast(to))); } }
@Test @ExcludeIn(ORACLE) public void Divide_BigDecimal() { QSimpleTypes entity = new QSimpleTypes("entity1"); QSimpleTypes entity2 = new QSimpleTypes("entity2"); NumberPath<BigDecimal> bigd1 = entity.bigDecimal; NumberPath<BigDecimal> bigd2 = entity2.bigDecimal; query().from(entity, entity2) .where(bigd1.divide(bigd2).loe(new BigDecimal("1.00"))) .list(entity); query().from(entity, entity2) .where(entity.ddouble.divide(bigd2).loe(new BigDecimal("1.00"))) .list(entity); query().from(entity, entity2) .where(bigd1.divide(entity.ddouble).loe(new BigDecimal("1.00"))) .list(entity); }
@Test @ExcludeIn(ORACLE) public void Multiply_BigDecimal() { QSimpleTypes entity = new QSimpleTypes("entity1"); QSimpleTypes entity2 = new QSimpleTypes("entity2"); NumberPath<BigDecimal> bigd1 = entity.bigDecimal; NumberPath<BigDecimal> bigd2 = entity2.bigDecimal; query().from(entity, entity2) .where(bigd1.multiply(bigd2).loe(new BigDecimal("1.00"))) .list(entity); }
@Test @ExcludeIn(ORACLE) public void Add_BigDecimal() { QSimpleTypes entity = new QSimpleTypes("entity1"); QSimpleTypes entity2 = new QSimpleTypes("entity2"); NumberPath<BigDecimal> bigd1 = entity.bigDecimal; NumberPath<BigDecimal> bigd2 = entity2.bigDecimal; query().from(entity, entity2) .where(bigd1.add(bigd2).loe(new BigDecimal("1.00"))) .list(entity); }
@Test @ExcludeIn(ORACLE) public void Subtract_BigDecimal() { QSimpleTypes entity = new QSimpleTypes("entity1"); QSimpleTypes entity2 = new QSimpleTypes("entity2"); NumberPath<BigDecimal> bigd1 = entity.bigDecimal; NumberPath<BigDecimal> bigd2 = entity2.bigDecimal; query().from(entity, entity2) .where(bigd1.subtract(bigd2).loe(new BigDecimal("1.00"))) .list(entity); }
@Test @ExcludeIn(ORACLE) public void Divide() { QSimpleTypes entity = new QSimpleTypes("entity1"); QSimpleTypes entity2 = new QSimpleTypes("entity2"); query().from(entity, entity2) .where(entity.ddouble.divide(entity2.ddouble).loe(2.0)) .list(entity); query().from(entity, entity2) .where(entity.ddouble.divide(entity2.iint).loe(2.0)) .list(entity); query().from(entity, entity2) .where(entity.iint.divide(entity2.ddouble).loe(2.0)) .list(entity); query().from(entity, entity2) .where(entity.iint.divide(entity2.iint).loe(2)) .list(entity); }
@Test public void Not_4() throws Exception { query().from(cat).where(cat.kittens.size().loe(1).not()).parse(); }
@Test public void Not_7() throws Exception { query().from(cat).where(cat.kittens.size().loe(1).not().not()).parse(); }
@Test @ExcludeIn(ORACLE) public void Multiply() { QSimpleTypes entity = new QSimpleTypes("entity1"); QSimpleTypes entity2 = new QSimpleTypes("entity2"); query().from(entity, entity2) .where(entity.ddouble.multiply(entity2.ddouble).loe(2.0)) .list(entity); }
@Test public void Not_8() throws Exception { query().from(cat).where(cat.kittens.size().loe(1).not().not().not()).parse(); }