Search in sources :

Example 56 with Node

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

the class InsertBuilderTest method testInsert.

@Test
public void testInsert() {
    InsertBuilder builder = new InsertBuilder("test");
    Node node = builder.build();
    assertThat(node, instanceOf(InsertNode.class));
    assertSQL("INSERT INTO test", node);
}
Also used : Node(org.apache.cayenne.access.sqlbuilder.sqltree.Node) InsertNode(org.apache.cayenne.access.sqlbuilder.sqltree.InsertNode) InsertNode(org.apache.cayenne.access.sqlbuilder.sqltree.InsertNode) Test(org.junit.Test)

Example 57 with Node

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

the class UpdateBuilderTest method testUpdate.

@Test
public void testUpdate() {
    UpdateBuilder builder = new UpdateBuilder("test");
    Node node = builder.build();
    assertThat(node, instanceOf(UpdateNode.class));
    assertSQL("UPDATE test", node);
}
Also used : UpdateNode(org.apache.cayenne.access.sqlbuilder.sqltree.UpdateNode) Node(org.apache.cayenne.access.sqlbuilder.sqltree.Node) UpdateNode(org.apache.cayenne.access.sqlbuilder.sqltree.UpdateNode) Test(org.junit.Test)

Example 58 with Node

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

the class UpdateBuilderTest method testUpdateDbEntityCatalog.

@Test
public void testUpdateDbEntityCatalog() {
    DbEntity entity = new DbEntity("test");
    entity.setCatalog("catalog");
    UpdateBuilder builder = new UpdateBuilder(entity);
    Node node = builder.build();
    assertThat(node, instanceOf(UpdateNode.class));
    assertSQL("UPDATE catalog.test", node);
    assertQuotedSQL("UPDATE `catalog`.`test`", node);
}
Also used : UpdateNode(org.apache.cayenne.access.sqlbuilder.sqltree.UpdateNode) DbEntity(org.apache.cayenne.map.DbEntity) Node(org.apache.cayenne.access.sqlbuilder.sqltree.Node) UpdateNode(org.apache.cayenne.access.sqlbuilder.sqltree.UpdateNode) Test(org.junit.Test)

Example 59 with Node

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

the class DistinctStageTest method suppressionByType.

@Test
public void suppressionByType() {
    TranslatableQueryWrapper wrapper = new MockQueryWrapperBuilder().withDistinct(true).withMetaData(new MockQueryMetadataBuilder().build()).build();
    TranslatorContext context = new MockTranslatorContext(wrapper);
    DbAttribute attribute = new DbAttribute();
    attribute.setType(Types.LONGVARBINARY);
    Node node = new ColumnNode("t0", "attr", null, attribute);
    context.addResultNode(node);
    assertFalse(context.isDistinctSuppression());
    DistinctStage stage = new DistinctStage();
    stage.perform(context);
    assertTrue(context.isDistinctSuppression());
}
Also used : ColumnNode(org.apache.cayenne.access.sqlbuilder.sqltree.ColumnNode) Node(org.apache.cayenne.access.sqlbuilder.sqltree.Node) DbAttribute(org.apache.cayenne.map.DbAttribute) ColumnNode(org.apache.cayenne.access.sqlbuilder.sqltree.ColumnNode) Test(org.junit.Test)

Example 60 with Node

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

the class SelectBuilderTest method testSelect.

@Test
public void testSelect() {
    SelectBuilder builder = new SelectBuilder();
    Node node = builder.build();
    assertThat(node, instanceOf(SelectNode.class));
    assertSQL("SELECT", node);
}
Also used : SelectNode(org.apache.cayenne.access.sqlbuilder.sqltree.SelectNode) Node(org.apache.cayenne.access.sqlbuilder.sqltree.Node) SelectNode(org.apache.cayenne.access.sqlbuilder.sqltree.SelectNode) Test(org.junit.Test)

Aggregations

Node (org.apache.cayenne.access.sqlbuilder.sqltree.Node)67 Test (org.junit.Test)32 ColumnNode (org.apache.cayenne.access.sqlbuilder.sqltree.ColumnNode)15 OpExpressionNode (org.apache.cayenne.access.sqlbuilder.sqltree.OpExpressionNode)15 FunctionNode (org.apache.cayenne.access.sqlbuilder.sqltree.FunctionNode)14 LimitOffsetNode (org.apache.cayenne.access.sqlbuilder.sqltree.LimitOffsetNode)13 TextNode (org.apache.cayenne.access.sqlbuilder.sqltree.TextNode)11 EmptyNode (org.apache.cayenne.access.sqlbuilder.sqltree.EmptyNode)9 ValueNode (org.apache.cayenne.access.sqlbuilder.sqltree.ValueNode)9 DbEntity (org.apache.cayenne.map.DbEntity)9 SelectNode (org.apache.cayenne.access.sqlbuilder.sqltree.SelectNode)8 InsertNode (org.apache.cayenne.access.sqlbuilder.sqltree.InsertNode)6 TrimmingColumnNode (org.apache.cayenne.access.sqlbuilder.sqltree.TrimmingColumnNode)6 QuotingAppendable (org.apache.cayenne.access.sqlbuilder.QuotingAppendable)5 UpdateNode (org.apache.cayenne.access.sqlbuilder.sqltree.UpdateNode)5 DeleteNode (org.apache.cayenne.access.sqlbuilder.sqltree.DeleteNode)4 InNode (org.apache.cayenne.access.sqlbuilder.sqltree.InNode)4 MysqlLimitOffsetNode (org.apache.cayenne.dba.mysql.sqltree.MysqlLimitOffsetNode)4 Expression (org.apache.cayenne.exp.Expression)4 SimpleNode (org.apache.cayenne.exp.parser.SimpleNode)4