Examples with Criteria org.springframework.data.relational.core.query.Criteria used on opensource projects

Example 31 with Criteria

use of org.springframework.data.relational.core.query.Criteria in project spring-data-jdbc by spring-projects.

the class QueryMapperUnitTests method shouldMapIsIn.

// DATAJDBC-318
@Test
public void shouldMapIsIn() {
    Criteria criteria = Criteria.where("name").in("a", "b", "c");
    Condition condition = map(criteria);
    assertThat(condition).hasToString("person.\"NAME\" IN (?[:name], ?[:name1], ?[:name2])");
}

Example 32 with Criteria

use of org.springframework.data.relational.core.query.Criteria in project spring-data-jdbc by spring-projects.

the class QueryMapperUnitTests method shouldMapNestedGroup.

// DATAJDBC-318
@Test
public void shouldMapNestedGroup() {
    Criteria initial = Criteria.empty();
    Criteria criteria = // 
    initial.and(Criteria.where("name").is("Foo")).and(// 
    Criteria.where("name").is("Bar").or("age").lessThan(// 
    49).or(// 
    Criteria.where("name").not("Bar").and("age").greaterThan(// 
    49)));
    assertThat(criteria.isEmpty()).isFalse();
    Condition condition = map(criteria);
    assertThat(condition).hasToString("(person.\"NAME\" = ?[:name]) AND (person.\"NAME\" = ?[:name1] OR person.age < ?[:age] OR (person.\"NAME\" != ?[:name2] AND person.age > ?[:age1]))");
}

Example 33 with Criteria

use of org.springframework.data.relational.core.query.Criteria in project spring-data-jdbc by spring-projects.

the class QueryMapperUnitTests method shouldMapBetween.

// DATAJDBC-318
@Test
public void shouldMapBetween() {
    Criteria criteria = Criteria.where("name").between("a", "b");
    Condition condition = map(criteria);
    assertThat(condition).hasToString("person.\"NAME\" BETWEEN ?[:name] AND ?[:name1]");
}

Example 34 with Criteria

use of org.springframework.data.relational.core.query.Criteria in project spring-data-jdbc by spring-projects.

the class QueryMapperUnitTests method shouldMapSimpleCriteriaWithoutEntity.

// DATAJDBC-318
@Test
public void shouldMapSimpleCriteriaWithoutEntity() {
    Criteria criteria = Criteria.where("name").is("foo");
    Condition condition = mapper.getMappedObject(new MapSqlParameterSource(), criteria, Table.create("person"), null);
    assertThat(condition).hasToString("person.name = ?[:name]");
}

Example 35 with Criteria

use of org.springframework.data.relational.core.query.Criteria in project spring-data-jdbc by spring-projects.

the class QueryMapperUnitTests method shouldMapIsNotNull.

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