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

Example 1 with Condition

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

the class QueryMapperUnitTests method shouldMapIsGte.

// DATAJDBC-318
@Test
public void shouldMapIsGte() {
    Criteria criteria = Criteria.where("name").greaterThanOrEquals("a");
    Condition condition = map(criteria);
    assertThat(condition).hasToString("person.\"NAME\" >= ?[:name]");
}

Example 2 with Condition

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

the class QueryMapperUnitTests method shouldMapIsGt.

// DATAJDBC-318
@Test
public void shouldMapIsGt() {
    Criteria criteria = Criteria.where("name").greaterThan("a");
    Condition condition = map(criteria);
    assertThat(condition).hasToString("person.\"NAME\" > ?[:name]");
}

Example 3 with Condition

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

the class QueryMapperUnitTests method shouldMapFromConcat.

// DATAJDBC-560
@Test
public void shouldMapFromConcat() {
    Criteria criteria = Criteria.from(Criteria.where("name").is("Foo"), // 
    Criteria.where("name").is("Bar").or("age").lessThan(49));
    assertThat(criteria.isEmpty()).isFalse();
    Condition condition = map(criteria);
    assertThat(condition).hasToString("(person.\"NAME\" = ?[:name] AND (person.\"NAME\" = ?[:name1] OR person.age < ?[:age]))");
}

Example 4 with Condition

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

the class QueryMapperUnitTests method shouldConsiderColumnName.

// DATAJDBC-318
@Test
public void shouldConsiderColumnName() {
    Criteria criteria = Criteria.where("alternative").is("foo");
    Condition condition = map(criteria);
    assertThat(condition).hasToString("person.\"another_name\" = ?[:another_name]");
}

Example 5 with Condition

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

the class QueryMapperUnitTests method shouldMapSimpleNullableCriteria.

// DATAJDBC-318
@Test
public void shouldMapSimpleNullableCriteria() {
    Criteria criteria = Criteria.where("name").isNull();
    Condition condition = map(criteria);
    assertThat(condition).hasToString("person.\"NAME\" IS NULL");
}