@Override public void removeProductsMoreExpensiveThan(BigDecimal price) { delete(product).where(product.price.gt(price)).execute(); } }
return numberExpression.gt((N) valueConverted);
return numberExpression.gt((N) valueConverted);
@Test public void Gt() { assertToString("cat.bodyWeight > kitten.bodyWeight", cat.bodyWeight.gt(kitten.bodyWeight)); }
return numberExpression.gt(value);
return numberExpression.gt(value);
@Test public void Delete2() { queryFactory2.delete(QAnimal.animal) .where(QAnimal.animal.bodyWeight.gt(0)); }
@Test public void DoubleLiteral2() throws Exception { query().from(cat).where(cat.weight.gt((int) 3.1415e3)).parse(); }
@Test public void LogicalOperations_And2() { assertToString("cat is null and (kitten is null or kitten.bodyWeight > ?1)", cat.isNull().and(kitten.isNull().or(kitten.bodyWeight.gt(10)))); }
@Test public void And_Operation() { Predicate predicate = cat.kittens.any().name.eq("Ruth123").and(cat.kittens.any().bodyWeight.gt(10.0)); assertMatches("exists \\(select 1\n"+ "from cat.kittens as cat_kittens.*\n" + "where cat_kittens.*\\.name = \\?1\\) and exists \\(select 1\n" + "from cat.kittens as cat_kittens.*\n" + "where cat_kittens.*\\.bodyWeight > \\?2\\)", serialize(predicate)); }
@Test public void GroupBy2() { // select cat0_.name as col_0_0_, cat0_.breed as col_1_0_, sum(cat0_.bodyWeight) as col_2_0_ // from animal_ cat0_ where cat0_.DTYPE in ('C', 'DC') and cat0_.bodyWeight>? // group by cat0_.name , cat0_.breed query().from(cat) .where(cat.bodyWeight.gt(0)) .groupBy(cat.name, cat.breed) .list(cat.name, cat.breed, cat.bodyWeight.sum()); }
@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 DocoExamples911() throws Exception { query().from(fatcat).where( fatcat.weight.gt(sub().from(cat).unique(cat.weight.avg()))) .parse(); }
@Test public void Any_And_Gt() { assertEquals(0, query().from(cat).where( cat.kittens.any().name.eq("Ruth123"), cat.kittens.any().bodyWeight.gt(10.0)).count()); }
Assert.assertEquals(CYPHER+"START n=node(1,2,3) WHERE n.firstName=\"P\" and n.age>25 RETURN n", start(node( person.toString(), 1, 2, 3 )) .where($(person.getFirstName()).eq("P").and($(person.getAge()).gt(25))) .returns(identifier( person.toString() )) .toString()); Assert.assertEquals(CYPHER+"START person=node(1,2,3) WHERE person.firstName=\"P\" and person.age>25 RETURN person", start(node(person, 1, 2, 3)) .where(person.firstName.eq("P").and(person.age.gt(25))) .returns(identifier( person )) .toString()); Assert.assertEquals(CYPHER+"START n=node(1,2,3) WHERE n.firstName=\"P\" and n.age>25 RETURN n", start(node(n, 1, 2, 3)) .where(n.firstName.eq("P").and(n.age.gt(25))) .returns(identifier( n )) .toString()); Assert.assertEquals(CYPHER+"START n=node(1,2,3) WHERE n.firstName={name} and n.age>{age} RETURN n", start(node(n, 1, 2, 3)) .where(n.firstName.eq(new Param<String>(String.class, "name")).and(n.age.gt(new Param<Integer>(Integer.class, "age")))) .returns(identifier( n )) .toString());