Examples with StringBuilderAppendable org.apache.cayenne.access.sqlbuilder.StringBuilderAppendable used on opensource projects

Example 1 with StringBuilderAppendable

use of org.apache.cayenne.access.sqlbuilder.StringBuilderAppendable in project cayenne by apache.

the class QualifierTranslatorTest method translateComplexAnd.

@Test
public void translateComplexAnd() {
    Node and = translate("a < 2 and b in (5,6) and b = 7");
    assertNotNull(and);
    assertThat(and, instanceOf(OpExpressionNode.class));
    assertEquals("AND", ((OpExpressionNode) and).getOp());
    assertEquals(3, and.getChildrenCount());
    SQLGenerationVisitor visitor = new SQLGenerationVisitor(new StringBuilderAppendable());
    and.visit(visitor);
    assertEquals(" ( t0.a < 2 ) AND t0.b IN ( 5, 6) AND ( t0.b = 7 )", visitor.getSQLString());
}

Example 2 with StringBuilderAppendable

use of org.apache.cayenne.access.sqlbuilder.StringBuilderAppendable in project cayenne by apache.

the class QualifierTranslatorIT method testCompoundPK.

@Test
public void testCompoundPK() {
    CompoundPkTestEntity testEntity = ObjectSelect.query(CompoundPkTestEntity.class).selectFirst(context);
    assertNotNull(testEntity);
    ObjectSelect<CompoundFkTestEntity> query = ObjectSelect.query(CompoundFkTestEntity.class).where(CompoundFkTestEntity.TO_COMPOUND_PK.eq(testEntity)).and(CompoundFkTestEntity.NAME.like("test%")).and(CompoundFkTestEntity.NAME.contains("a"));
    DefaultSelectTranslator translator = new DefaultSelectTranslator(query, runtime.getDataDomain().getDefaultNode().getAdapter(), context.getEntityResolver());
    QualifierTranslator qualifierTranslator = translator.getContext().getQualifierTranslator();
    Node node = qualifierTranslator.translate(query.getWhere());
    SQLGenerationVisitor visitor = new SQLGenerationVisitor(new StringBuilderAppendable());
    node.visit(visitor);
    assertEquals(" ( ( ( t0.F_KEY1 = 'PK1' ) AND ( t0.F_KEY2 = 'PK2' ) ) AND t0.NAME LIKE 'test%' ) AND t0.NAME LIKE '%a%'", visitor.getSQLString());
}