use of jakarta.nosql.query.SelectQuery in project jnosql-diana by eclipse.
the class SelectQueryProviderTest method shouldReturnParserQuery27.
@ParameterizedTest(name = "Should parser the query {0}")
@ValueSource(strings = { "select * from God where name = \"Ada\" and age = 20 or" + " siblings = {\"apollo\": \"Brother\", \"Zeus\": \"Father\"}" })
public void shouldReturnParserQuery27(String query) {
SelectQuery selectQuery = checkSelectFromStart(query);
assertTrue(selectQuery.getWhere().isPresent());
Where where = selectQuery.getWhere().get();
Condition condition = where.getCondition();
QueryValue<?> value = condition.getValue();
Assertions.assertEquals(Operator.AND, condition.getOperator());
assertEquals("_AND", condition.getName());
assertTrue(value instanceof ConditionQueryValue);
List<Condition> conditions = ConditionQueryValue.class.cast(value).get();
assertEquals(3, conditions.size());
condition = conditions.get(0);
value = condition.getValue();
Assertions.assertEquals(Operator.EQUALS, condition.getOperator());
assertEquals("name", condition.getName());
assertTrue(value instanceof StringQueryValue);
assertEquals("Ada", StringQueryValue.class.cast(value).get());
condition = conditions.get(1);
value = condition.getValue();
Assertions.assertEquals(Operator.EQUALS, condition.getOperator());
assertEquals("age", condition.getName());
assertTrue(value instanceof NumberQueryValue);
assertEquals(20L, NumberQueryValue.class.cast(value).get());
condition = conditions.get(2);
value = condition.getValue();
Assertions.assertEquals(Operator.OR, condition.getOperator());
conditions = ConditionQueryValue.class.cast(condition.getValue()).get();
assertEquals(1, conditions.size());
condition = conditions.get(0);
value = condition.getValue();
Assertions.assertEquals(Operator.EQUALS, condition.getOperator());
assertEquals("siblings", condition.getName());
assertTrue(value instanceof JSONQueryValue);
JsonObject jsonObject = JSONQueryValue.class.cast(value).get();
assertEquals("Brother", jsonObject.getString("apollo"));
assertEquals("Father", jsonObject.getString("Zeus"));
}
use of jakarta.nosql.query.SelectQuery in project jnosql-diana by eclipse.
the class SelectQueryProviderTest method shouldReturnParserQuery14.
@ParameterizedTest(name = "Should parser the query {0}")
@ValueSource(strings = { "select * from God where age between 10 and 30" })
public void shouldReturnParserQuery14(String query) {
SelectQuery selectQuery = checkSelectFromStart(query);
assertTrue(selectQuery.getWhere().isPresent());
Where where = selectQuery.getWhere().get();
Condition condition = where.getCondition();
QueryValue<?> value = condition.getValue();
Assertions.assertEquals(Operator.BETWEEN, condition.getOperator());
assertEquals("age", condition.getName());
assertTrue(value instanceof ArrayQueryValue);
ArrayQueryValue arrayValue = ArrayQueryValue.class.cast(value);
QueryValue<?>[] values = arrayValue.get();
assertThat(Stream.of(values).map(QueryValue::get).collect(toList()), contains(10L, 30L));
}
use of jakarta.nosql.query.SelectQuery in project jnosql-diana by eclipse.
the class SelectQueryProviderTest method shouldReturnParserQuery17.
@ParameterizedTest(name = "Should parser the query {0}")
@ValueSource(strings = { "select * from God where name = {\"diana\"}" })
public void shouldReturnParserQuery17(String query) {
SelectQuery selectQuery = checkSelectFromStart(query);
assertTrue(selectQuery.getWhere().isPresent());
Where where = selectQuery.getWhere().get();
Condition condition = where.getCondition();
QueryValue<?> value = condition.getValue();
Assertions.assertEquals(Operator.EQUALS, condition.getOperator());
assertEquals("name", condition.getName());
assertTrue(value instanceof ArrayQueryValue);
List<?> values = Stream.of(ArrayQueryValue.class.cast(value).get()).map(QueryValue::get).collect(toList());
assertThat(values, contains("diana"));
}
use of jakarta.nosql.query.SelectQuery in project jnosql-diana by eclipse.
the class SelectQueryProviderTest method shouldReturnParserQuery21.
@ParameterizedTest(name = "Should parser the query {0}")
@ValueSource(strings = { "select * from God where age = convert(12, java.lang.Integer)" })
public void shouldReturnParserQuery21(String query) {
SelectQuery selectQuery = checkSelectFromStart(query);
assertTrue(selectQuery.getWhere().isPresent());
Where where = selectQuery.getWhere().get();
Condition condition = where.getCondition();
QueryValue<?> value = condition.getValue();
Assertions.assertEquals(Operator.EQUALS, condition.getOperator());
assertEquals("age", condition.getName());
assertTrue(value instanceof FunctionQueryValue);
Function function = FunctionQueryValue.class.cast(value).get();
assertEquals("convert", function.getName());
Object[] params = function.getParams();
assertEquals(12L, NumberQueryValue.class.cast(params[0]).get());
assertEquals(Integer.class, params[1]);
}
use of jakarta.nosql.query.SelectQuery in project jnosql-diana by eclipse.
the class SelectQueryProviderTest method shouldReturnParserQuery11.
@ParameterizedTest(name = "Should parser the query {0}")
@ValueSource(strings = { "select * from God where stamina >= 10.23" })
public void shouldReturnParserQuery11(String query) {
SelectQuery selectQuery = checkSelectFromStart(query);
assertTrue(selectQuery.getWhere().isPresent());
Where where = selectQuery.getWhere().get();
Condition condition = where.getCondition();
QueryValue<?> value = condition.getValue();
Assertions.assertEquals(Operator.GREATER_EQUALS_THAN, condition.getOperator());
assertEquals("stamina", condition.getName());
assertTrue(value instanceof NumberQueryValue);
assertEquals(10.23, value.get());
}
Aggregations