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

Example 51 with Node

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

the class DeleteBuilderTest method testDeleteDbEntityCatalogAndSchema.

@Test
public void testDeleteDbEntityCatalogAndSchema() {
    DbEntity entity = new DbEntity("test");
    entity.setSchema("schema");
    entity.setCatalog("catalog");
    DeleteBuilder builder = new DeleteBuilder(entity);
    Node node = builder.build();
    assertThat(node, instanceOf(DeleteNode.class));
    assertSQL("DELETE FROM catalog.schema.test", node);
    assertQuotedSQL("DELETE FROM `catalog`.`schema`.`test`", node);
}

Example 52 with Node

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

the class InsertBuilderTest method testInsertWithColumnsAndValues.

@Test
public void testInsertWithColumnsAndValues() {
    InsertBuilder builder = new InsertBuilder("test");
    builder.column(column("col1")).value(value(1)).column(column("col2")).value(value("test")).column(column("col3")).value(value(null));
    Node node = builder.build();
    assertThat(node, instanceOf(InsertNode.class));
    assertSQL("INSERT INTO test( col1, col2, col3) VALUES( 1, 'test', NULL)", node);
}

Example 53 with Node

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

the class InsertBuilderTest method testInsertWithValues.

@Test
public void testInsertWithValues() {
    InsertBuilder builder = new InsertBuilder("test");
    builder.value(value(1)).value(value("test")).value(value(null));
    Node node = builder.build();
    assertThat(node, instanceOf(InsertNode.class));
    assertSQL("INSERT INTO test VALUES( 1, 'test', NULL)", node);
}

Example 54 with Node

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

the class InsertBuilderTest method testInsertDbEntityCatalog.

@Test
public void testInsertDbEntityCatalog() {
    DbEntity entity = new DbEntity("test");
    entity.setCatalog("catalog");
    InsertBuilder builder = new InsertBuilder(entity);
    Node node = builder.build();
    assertThat(node, instanceOf(InsertNode.class));
    assertSQL("INSERT INTO catalog.test", node);
    assertQuotedSQL("INSERT INTO `catalog`.`test`", node);
}

Example 55 with Node

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

the class InsertBuilderTest method testInsertWithColumns.

@Test
public void testInsertWithColumns() {
    InsertBuilder builder = new InsertBuilder("test");
    builder.column(column("col1")).column(column("col2")).column(column("col3"));
    Node node = builder.build();
    assertThat(node, instanceOf(InsertNode.class));
    assertSQL("INSERT INTO test( col1, col2, col3)", node);
}