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

Example 61 with Node

use of org.apache.cayenne.access.sqlbuilder.sqltree.Node in project cayenne by apache.

the class SelectBuilderTest method testSelectFromWhereNull.

@Test
public void testSelectFromWhereNull() {
    SelectBuilder builder = new SelectBuilder(column("a")).from(table("b")).where(column("a").eq(value(null)));
    Node node = builder.build();
    assertThat(node, instanceOf(SelectNode.class));
    assertSQL("SELECT a FROM b WHERE a IS NULL", node);
}

Example 62 with Node

use of org.apache.cayenne.access.sqlbuilder.sqltree.Node in project cayenne by apache.

the class SelectBuilderTest method testSelectFrom.

@Test
public void testSelectFrom() {
    SelectBuilder builder = new SelectBuilder(column("a")).from(table("b"));
    Node node = builder.build();
    assertThat(node, instanceOf(SelectNode.class));
    assertSQL("SELECT a FROM b", node);
    assertQuotedSQL("SELECT `a` FROM `b`", node);
}

Example 63 with Node

use of org.apache.cayenne.access.sqlbuilder.sqltree.Node in project cayenne by apache.

the class SelectBuilderTest method testSelectFromDbEntity.

@Test
public void testSelectFromDbEntity() {
    DbEntity entity = new DbEntity("b");
    entity.setSchema("d");
    entity.setCatalog("c");
    SelectBuilder builder = new SelectBuilder(column("a")).from(table(entity));
    Node node = builder.build();
    assertThat(node, instanceOf(SelectNode.class));
    assertSQL("SELECT a FROM c.d.b", node);
    assertQuotedSQL("SELECT `a` FROM `c`.`d`.`b`", node);
}

Example 64 with Node

use of org.apache.cayenne.access.sqlbuilder.sqltree.Node in project cayenne by apache.

the class SelectBuilderTest method testSelectFromWhereComplex.

@Test
public void testSelectFromWhereComplex() {
    SelectBuilder builder = new SelectBuilder(column("a")).from(table("b")).where(column("a").eq(value(123)).and(column("c").lt(column("d"))));
    Node node = builder.build();
    assertThat(node, instanceOf(SelectNode.class));
    assertSQL("SELECT a FROM b WHERE ( a = 123 ) AND ( c < d )", node);
}

Example 65 with Node

use of org.apache.cayenne.access.sqlbuilder.sqltree.Node in project cayenne by apache.

the class GroupByStageTest method groupByWithAggregates.

// result column + aggregate
@Test
public void groupByWithAggregates() {
    context.addResultNode(new ColumnNode("t0", "column", null, null));
    context.addResultNode(new EmptyNode(), true, PropertyFactory.COUNT, "count");
    GroupByStage stage = new GroupByStage();
    stage.perform(context);
    Node node = context.getSelectBuilder().build();
    assertEquals(1, node.getChildrenCount());
    assertThat(node.getChild(0), instanceOf(GroupByNode.class));
    assertEquals(1, node.getChild(0).getChildrenCount());
    assertThat(node.getChild(0).getChild(0), instanceOf(ColumnNode.class));
    ColumnNode columnNode = (ColumnNode) node.getChild(0).getChild(0);
    assertEquals("t0", columnNode.getTable());
    assertEquals("column", columnNode.getColumn());
}