return numberExpression.lt((N) valueConverted);
return numberExpression.lt((N) valueConverted);
@Test public void Lt() { assertToString("cat.bodyWeight < kitten.bodyWeight", cat.bodyWeight.lt(kitten.bodyWeight)); }
return numberExpression.lt(value);
return numberExpression.lt(value);
@Test public void DoubleLiteral() throws Exception { query().from(cat).where(cat.weight.lt((int) 3.1415)).parse(); }
@Test public void NormalizeNumericArgs() { JPQLSerializer serializer = new JPQLSerializer(HQLTemplates.DEFAULT); NumberPath<Double> doublePath = new NumberPath<Double>(Double.class, "doublePath"); serializer.handle(doublePath.add(1)); serializer.handle(doublePath.between((float)1.0, 1l)); serializer.handle(doublePath.lt((byte)1)); for (Object constant : serializer.getConstantToLabel().keySet()) { assertEquals(Double.class, constant.getClass()); } }
@Test public void Exists_Where() { assertToString("exists (select 1 from Cat cat where cat.weight < ?1)", sub().from(cat).where(cat.weight.lt(1)).exists()); }
@Test public void NotExists_Where() { assertToString("not exists (select 1 from Cat cat where cat.weight < ?1)", sub().from(cat).where(cat.weight.lt(1)).notExists()); }
@Test public void NotExists_Via_Unique() { assertToString("not exists (select 1 from Cat cat where cat.weight < ?1)", sub().from(cat).where(cat.weight.lt(1)).unique(cat).notExists()); }
@Test public void Exists_Via_Unique() { assertToString("exists (select 1 from Cat cat where cat.weight < ?1)", sub().from(cat).where(cat.weight.lt(1)).unique(cat).exists()); }
@Test public void Where_5() throws Exception { query().from(an).where( an.bodyWeight.gt(10), an.bodyWeight.lt(100).or(an.bodyWeight.isNull())) .parse(); }
@Test public void Any_And_Lt() { assertEquals(1, query().from(cat).where( cat.kittens.any().name.eq("Ruth123"), cat.kittens.any().bodyWeight.lt(10.0)).count()); }