Search in sources :

Example 36 with ColumnCondition

use of org.jnosql.diana.api.column.ColumnCondition in project jnosql-diana by eclipse.

the class BaseQueryBuilder method likeImpl.

protected void likeImpl(String value) {
    requireNonNull(value, "value is required");
    ColumnCondition newCondition = ColumnCondition.like(Column.of(name, value));
    appendCondition(newCondition);
}
Also used : ColumnCondition(org.jnosql.diana.api.column.ColumnCondition)

Example 37 with ColumnCondition

use of org.jnosql.diana.api.column.ColumnCondition in project jnosql-diana by eclipse.

the class BaseQueryBuilder method betweenImpl.

protected void betweenImpl(Number valueA, Number valueB) {
    requireNonNull(valueA, "valueA is required");
    requireNonNull(valueB, "valueB is required");
    ColumnCondition newCondition = ColumnCondition.between(Column.of(name, asList(valueA, valueB)));
    appendCondition(newCondition);
}
Also used : ColumnCondition(org.jnosql.diana.api.column.ColumnCondition)

Example 38 with ColumnCondition

use of org.jnosql.diana.api.column.ColumnCondition in project jnosql-diana by eclipse.

the class BaseQueryBuilder method gtImpl.

protected void gtImpl(Number value) {
    requireNonNull(value, "value is required");
    ColumnCondition newCondition = ColumnCondition.gt(Column.of(name, value));
    appendCondition(newCondition);
}
Also used : ColumnCondition(org.jnosql.diana.api.column.ColumnCondition)

Example 39 with ColumnCondition

use of org.jnosql.diana.api.column.ColumnCondition in project jnosql-diana by eclipse.

the class DefaultDeleteQueryBuilderTest method shouldSelectWhereNameNot.

@Test
public void shouldSelectWhereNameNot() {
    String columnFamily = "columnFamily";
    String name = "Ada Lovelace";
    ColumnDeleteQuery query = delete().from(columnFamily).where("name").not().eq(name).build();
    ColumnCondition condition = query.getCondition().get();
    Column column = condition.getColumn();
    ColumnCondition negate = column.get(ColumnCondition.class);
    assertTrue(query.getColumns().isEmpty());
    assertEquals(columnFamily, query.getColumnFamily());
    assertEquals(Condition.NOT, condition.getCondition());
    assertEquals(Condition.EQUALS, negate.getCondition());
    assertEquals("name", negate.getColumn().getName());
    assertEquals(name, negate.getColumn().get());
}
Also used : Column(org.jnosql.diana.api.column.Column) ColumnCondition(org.jnosql.diana.api.column.ColumnCondition) ColumnDeleteQuery(org.jnosql.diana.api.column.ColumnDeleteQuery) Test(org.junit.jupiter.api.Test)

Example 40 with ColumnCondition

use of org.jnosql.diana.api.column.ColumnCondition in project jnosql-diana by eclipse.

the class DefaultDeleteQueryBuilderTest method shouldSelectWhereNameOr.

@Test
public void shouldSelectWhereNameOr() {
    String columnFamily = "columnFamily";
    String name = "Ada Lovelace";
    ColumnDeleteQuery query = delete().from(columnFamily).where("name").eq(name).or("age").gt(10).build();
    ColumnCondition condition = query.getCondition().get();
    Column column = condition.getColumn();
    List<ColumnCondition> conditions = column.get(new TypeReference<List<ColumnCondition>>() {
    });
    assertEquals(Condition.OR, condition.getCondition());
    assertThat(conditions, Matchers.containsInAnyOrder(ColumnCondition.eq(Column.of("name", name)), ColumnCondition.gt(Column.of("age", 10))));
}
Also used : Column(org.jnosql.diana.api.column.Column) List(java.util.List) ColumnCondition(org.jnosql.diana.api.column.ColumnCondition) ColumnDeleteQuery(org.jnosql.diana.api.column.ColumnDeleteQuery) Test(org.junit.jupiter.api.Test)

Aggregations

ColumnCondition (org.jnosql.diana.api.column.ColumnCondition)69 Test (org.junit.jupiter.api.Test)46 Column (org.jnosql.diana.api.column.Column)29 ColumnQuery (org.jnosql.diana.api.column.ColumnQuery)29 ColumnDeleteQuery (org.jnosql.diana.api.column.ColumnDeleteQuery)23 List (java.util.List)20 Person (org.jnosql.artemis.model.Person)13 Collections.singletonList (java.util.Collections.singletonList)7 Pagination (org.jnosql.artemis.Pagination)7 Condition (org.jnosql.diana.api.Condition)7 Sort (org.jnosql.diana.api.Sort)7 Proxy (java.lang.reflect.Proxy)6 Duration (java.time.Duration)6 Optional (java.util.Optional)6 Consumer (java.util.function.Consumer)6 Inject (javax.inject.Inject)6 CDIExtension (org.jnosql.artemis.CDIExtension)6 Converters (org.jnosql.artemis.Converters)6 DynamicQueryException (org.jnosql.artemis.DynamicQueryException)6 RepositoryAsync (org.jnosql.artemis.RepositoryAsync)6