Examples with Column org.springframework.data.relational.core.sql.Column used on opensource projects

Example 11 with Column

use of org.springframework.data.relational.core.sql.Column in project spring-data-jdbc by spring-projects.

the class OrderByClauseVisitorUnitTests method shouldRenderOrderByFullyQualifiedName.

// GH-968
@Test
void shouldRenderOrderByFullyQualifiedName() {
    Table employee = SQL.table("employee");
    Column column = employee.column("name");
    Select select = Select.builder().select(column).from(employee).orderBy(OrderByField.from(column).asc()).build();
    OrderByClauseVisitor visitor = new OrderByClauseVisitor(new SimpleRenderContext(NamingStrategies.asIs()));
    select.visit(visitor);
    assertThat(visitor.getRenderedPart().toString()).isEqualTo("employee.name ASC");
}

Example 12 with Column

use of org.springframework.data.relational.core.sql.Column in project spring-data-jdbc by spring-projects.

the class NameRendererUnitTests method fullyQualifiedReference.

// GH-1003, GH-968
@Test
void fullyQualifiedReference() {
    Column column = Table.aliased("table", "tab_alias").column("col");
    CharSequence rendered = NameRenderer.fullyQualifiedReference(context, column);
    assertThat(rendered).isEqualTo("tab_alias.col");
}

Example 13 with Column

use of org.springframework.data.relational.core.sql.Column in project spring-data-jdbc by spring-projects.

the class NameRendererUnitTests method rendersColumnWithoutTableName.

// GH-1003
@Test
void rendersColumnWithoutTableName() {
    Column column = Column.create("column", Table.create("table"));
    CharSequence rendered = NameRenderer.render(context, column);
    assertThat(rendered).isEqualTo("column");
}

Example 14 with Column

use of org.springframework.data.relational.core.sql.Column in project spring-data-jdbc by spring-projects.

the class UpdateRendererUnitTests method shouldRenderMultipleColumnUpdate.

// DATAJDBC-335
@Test
public void shouldRenderMultipleColumnUpdate() {
    Table table = SQL.table("mytable");
    Column foo = table.column("foo");
    Column bar = table.column("bar");
    Update update = // 
    StatementBuilder.update(table).set(foo.set(SQL.bindMarker()), // 
    bar.set(SQL.bindMarker())).build();
    assertThat(SqlRenderer.toString(update)).isEqualTo("UPDATE mytable SET foo = ?, bar = ?");
}

Example 15 with Column

use of org.springframework.data.relational.core.sql.Column in project spring-data-jdbc by spring-projects.

the class UpdateRendererUnitTests method shouldCreateUpdateWIthCondition.

// DATAJDBC-335
@Test
public void shouldCreateUpdateWIthCondition() {
    Table table = SQL.table("mytable");
    Column column = table.column("foo");
    Update update = StatementBuilder.update(table).set(column.set(SQL.bindMarker())).where(column.isNull()).build();
    assertThat(SqlRenderer.toString(update)).isEqualTo("UPDATE mytable SET foo = ? WHERE mytable.foo IS NULL");
}