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

Example 31 with Select

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

the class MySqlDialectRenderingUnitTests method shouldRenderSelectWithLimitWithLockRead.

// DATAJDBC-498
@Test
public void shouldRenderSelectWithLimitWithLockRead() {
    Table table = Table.create("foo");
    LockMode lockMode = LockMode.PESSIMISTIC_READ;
    Select select = StatementBuilder.select(table.asterisk()).from(table).limit(10).lock(lockMode).build();
    String sql = SqlRenderer.create(factory.createRenderContext()).render(select);
    assertThat(sql).isEqualTo("SELECT foo.* FROM foo LIMIT 10 LOCK IN SHARE MODE");
}

Example 32 with Select

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

the class PostgresDialectRenderingUnitTests method shouldRenderSimpleSelect.

// DATAJDBC-278
@Test
public void shouldRenderSimpleSelect() {
    Table table = Table.create("foo");
    Select select = StatementBuilder.select(table.asterisk()).from(table).build();
    String sql = SqlRenderer.create(factory.createRenderContext()).render(select);
    assertThat(sql).isEqualTo("SELECT foo.* FROM foo");
}

Example 33 with Select

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

the class PostgresDialectRenderingUnitTests method shouldRenderSelectWithLimit.

// DATAJDBC-278
@Test
public void shouldRenderSelectWithLimit() {
    Table table = Table.create("foo");
    Select select = StatementBuilder.select(table.asterisk()).from(table).limit(10).build();
    String sql = SqlRenderer.create(factory.createRenderContext()).render(select);
    assertThat(sql).isEqualTo("SELECT foo.* FROM foo LIMIT 10");
}

Example 34 with Select

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

the class PostgresDialectRenderingUnitTests method shouldApplyNamingStrategy.

// DATAJDBC-278
@Test
public void shouldApplyNamingStrategy() {
    factory.setNamingStrategy(NamingStrategies.toUpper());
    Table table = Table.create("foo");
    Select select = StatementBuilder.select(table.asterisk()).from(table).build();
    String sql = SqlRenderer.create(factory.createRenderContext()).render(select);
    assertThat(sql).isEqualTo("SELECT FOO.* FROM FOO");
}

Example 35 with Select

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

the class PostgresDialectRenderingUnitTests method shouldRenderSelectOrderByWithNoOptions.

// GH-821
@Test
void shouldRenderSelectOrderByWithNoOptions() {
    Table table = Table.create("foo");
    Select select = StatementBuilder.select(table.asterisk()).from(table).orderBy(OrderByField.from(Column.create("bar", table))).build();
    String sql = SqlRenderer.create(factory.createRenderContext()).render(select);
    assertThat(sql).isEqualTo("SELECT foo.* FROM foo ORDER BY foo.bar");
}