Examples with ColumnQuery jakarta.nosql.column.ColumnQuery used on opensource projects

Example 26 with ColumnQuery

use of jakarta.nosql.column.ColumnQuery in project jnosql-diana by eclipse.

the class DefaultColumnMapperSelectBuilderTest method shouldSelectWhereNameAnd.

@Test
public void shouldSelectWhereNameAnd() {
    ColumnQuery query = mapperBuilder.selectFrom(Person.class).where("age").between(10, 20).and("name").eq("Ada").build();
    ColumnQuery queryExpected = select().from("Person").where("age").between(10, 20).and("name").eq("Ada").build();
    assertEquals(queryExpected, query);
}

Example 27 with ColumnQuery

use of jakarta.nosql.column.ColumnQuery in project jnosql-diana by eclipse.

the class DefaultColumnMapperSelectBuilderTest method shouldSelectStart.

@Test
public void shouldSelectStart() {
    ColumnQuery query = mapperBuilder.selectFrom(Worker.class).limit(10).build();
    ColumnQuery queryExpected = select().from("Worker").limit(10L).build();
    assertEquals(queryExpected, query);
}

Example 28 with ColumnQuery

use of jakarta.nosql.column.ColumnQuery in project jnosql-diana by eclipse.

the class DefaultColumnMapperSelectBuilderTest method shouldExecuteQueryPagination.

@Test
public void shouldExecuteQueryPagination() {
    Pagination pagination = Pagination.page(2).size(2);
    ColumnTemplate template = Mockito.mock(ColumnTemplate.class);
    ArgumentCaptor<ColumnQuery> queryCaptor = ArgumentCaptor.forClass(ColumnQuery.class);
    mapperBuilder.selectFrom(Person.class).getResult(template, pagination);
    Mockito.verify(template).select(queryCaptor.capture());
    ColumnQuery query = queryCaptor.getValue();
    assertEquals(pagination.getLimit(), query.getLimit());
    assertEquals(pagination.getSkip(), query.getSkip());
}

Example 29 with ColumnQuery

use of jakarta.nosql.column.ColumnQuery in project jnosql-diana by eclipse.

the class DefaultColumnMapperSelectBuilderTest method shouldCreatePage.

@Test
public void shouldCreatePage() {
    Pagination pagination = Pagination.page(2).size(2);
    ColumnTemplate template = Mockito.mock(ColumnTemplate.class);
    ArgumentCaptor<ColumnQueryPagination> queryCaptor = ArgumentCaptor.forClass(ColumnQueryPagination.class);
    Page<Person> page = mapperBuilder.selectFrom(Person.class).page(template, pagination);
    Mockito.verify(template).select(queryCaptor.capture());
    ColumnQuery query = queryCaptor.getValue();
    assertEquals(pagination.getLimit(), query.getLimit());
    assertEquals(pagination.getSkip(), query.getSkip());
}

Example 30 with ColumnQuery

use of jakarta.nosql.column.ColumnQuery in project jnosql-diana by eclipse.

the class DefaultColumnMapperSelectBuilderTest method shouldSelectOrderDesc.

@Test
public void shouldSelectOrderDesc() {
    ColumnQuery query = mapperBuilder.selectFrom(Worker.class).orderBy("salary").desc().build();
    ColumnQuery queryExpected = select().from("Worker").orderBy("money").desc().build();
    assertEquals(queryExpected, query);
}