use of jakarta.nosql.query.StringQueryValue in project jnosql-diana by eclipse.
the class SelectQueryProviderTest method shouldReturnParserQuery29.
@ParameterizedTest(name = "Should parser the query {0}")
@ValueSource(strings = { "select * from God where name = \"Ada\" and age = 20 or" + " siblings = {\"apollo\": \"Brother\", \"Zeus\": \"Father\"} and birthday =" + " convert(\"2007-12-03\", java.time.LocalDate)" })
public void shouldReturnParserQuery29(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(4, 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);
Assertions.assertEquals(Operator.OR, condition.getOperator());
assertEquals(1, ConditionQueryValue.class.cast(condition.getValue()).get().size());
Condition c = ConditionQueryValue.class.cast(condition.getValue()).get().get(0);
value = c.getValue();
Assertions.assertEquals(Operator.EQUALS, c.getOperator());
assertEquals("siblings", c.getName());
assertTrue(value instanceof JSONQueryValue);
JsonObject jsonObject = JSONQueryValue.class.cast(value).get();
assertEquals("Brother", jsonObject.getString("apollo"));
assertEquals("Father", jsonObject.getString("Zeus"));
condition = conditions.get(3);
value = condition.getValue();
Assertions.assertEquals(Operator.EQUALS, condition.getOperator());
assertEquals("birthday", condition.getName());
assertTrue(value instanceof FunctionQueryValue);
Function function = FunctionQueryValue.class.cast(value).get();
assertEquals("convert", function.getName());
Object[] params = function.getParams();
assertEquals("2007-12-03", StringQueryValue.class.cast(params[0]).get());
assertEquals(LocalDate.class, params[1]);
}
use of jakarta.nosql.query.StringQueryValue in project jnosql-diana by eclipse.
the class SelectQueryProviderTest method shouldReturnParserQuery16.
@ParameterizedTest(name = "Should parser the query {0}")
@ValueSource(strings = { "select * from God where name = 'diana'" })
public void shouldReturnParserQuery16(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 StringQueryValue);
assertEquals("diana", value.get());
}
use of jakarta.nosql.query.StringQueryValue in project jnosql-diana by eclipse.
the class UpdateQueryProviderTest method shouldReturnParserQuery.
@ParameterizedTest(name = "Should parser the query {0}")
@ValueSource(strings = { "update God (name = \"Diana\")" })
public void shouldReturnParserQuery(String query) {
UpdateQuery updateQuery = checkUpdateFromStart(query);
List<Condition> conditions = updateQuery.getConditions();
assertEquals(1, conditions.size());
Condition condition = conditions.get(0);
assertEquals("name", condition.getName());
assertEquals(Operator.EQUALS, condition.getOperator());
QueryValue<?> value = condition.getValue();
assertTrue(value instanceof StringQueryValue);
assertEquals("Diana", StringQueryValue.class.cast(value).get());
}
use of jakarta.nosql.query.StringQueryValue in project jnosql-diana by eclipse.
the class PutProviderTest method shouldReturnParserQuery.
@ParameterizedTest(name = "Should parser the query {0}")
@ValueSource(strings = { "put {\"Ada\", \"Hunt\"}\n" })
public void shouldReturnParserQuery(String query) {
PutQuery putQuery = provider.apply(query);
QueryValue<?> key = putQuery.getKey();
QueryValue<?> value = putQuery.getValue();
Optional<Duration> ttl = putQuery.getTtl();
assertTrue(key instanceof StringQueryValue);
assertEquals("Ada", StringQueryValue.class.cast(key).get());
assertFalse(ttl.isPresent());
assertTrue(value instanceof StringQueryValue);
assertEquals("Hunt", StringQueryValue.class.cast(value).get());
assertFalse(ttl.isPresent());
}
use of jakarta.nosql.query.StringQueryValue in project jnosql-diana by eclipse.
the class GetProviderTest method shouldReturnParserQuery.
@ParameterizedTest(name = "Should parser the query {0}")
@ValueSource(strings = { "get \"Diana\"" })
public void shouldReturnParserQuery(String query) {
GetQuery getQuery = queryProvider.apply(query);
List<QueryValue<?>> keys = getQuery.getKeys();
assertEquals(1, keys.size());
QueryValue<?> key = keys.get(0);
assertTrue(key instanceof StringQueryValue);
assertEquals("Diana", StringQueryValue.class.cast(key).get());
}
Aggregations