use of jakarta.nosql.query.JSONQueryValue in project jnosql-diana by eclipse.
the class InsertQueryProviderTest method checkJSONInsertQuery.
private void checkJSONInsertQuery(String query, Duration duration) {
InsertQuery insertQuery = insertQueryProvider.apply(query);
assertEquals("Person", insertQuery.getEntity());
Assertions.assertTrue(insertQuery.getConditions().isEmpty());
Assertions.assertTrue(insertQuery.getValue().isPresent());
JSONQueryValue JSONQueryValue = insertQuery.getValue().get();
JsonObject jsonObject = JSONQueryValue.get();
assertEquals("Ada Lovelace", jsonObject.getString("name"));
assertEquals(duration, insertQuery.getTtl().get());
}
use of jakarta.nosql.query.JSONQueryValue in project jnosql-diana by eclipse.
the class ConditionQueryParser method getEntity.
protected DocumentEntity getEntity(ConditionQuerySupplier query, String collection, Params params, DocumentObserverParser observer) {
DocumentEntity entity = DocumentEntity.of(collection);
if (query.useJSONCondition()) {
JSONQueryValue jsonValue = query.getValue().orElseThrow(() -> new QueryException("It is an invalid state of" + " either Update or Insert."));
List<Document> documents = JsonObjects.getDocuments(jsonValue.get());
entity.addAll(documents);
return entity;
}
query.getConditions().stream().map(c -> Conditions.getCondition(c, params, observer, collection)).map(DocumentCondition::getDocument).forEach(entity::add);
return entity;
}
use of jakarta.nosql.query.JSONQueryValue in project jnosql-diana by eclipse.
the class ConditionQueryParser method getEntity.
protected ColumnEntity getEntity(ConditionQuerySupplier query, String columnFamily, Params params, ColumnObserverParser observer) {
ColumnEntity entity = ColumnEntity.of(columnFamily);
if (query.useJSONCondition()) {
JSONQueryValue jsonValue = query.getValue().orElseThrow(() -> new QueryException("It is an invalid state of" + " either Update or Insert."));
List<Column> columns = JsonObjects.getColumns(jsonValue.get());
entity.addAll(columns);
return entity;
}
query.getConditions().stream().map(c -> Conditions.getCondition(c, params, observer, columnFamily)).map(ColumnCondition::getColumn).forEach(entity::add);
return entity;
}
use of jakarta.nosql.query.JSONQueryValue 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.JSONQueryValue in project jnosql-diana by eclipse.
the class SelectQueryProviderTest method shouldReturnParserQuery28.
@ParameterizedTest(name = "Should parser the query {0}")
@ValueSource(strings = { "select * from God where name = \"Ada\" and age = 20 or" + " siblings = {\"apollo\": \"Brother\", \"Zeus\": \"Father\"} or birthday =" + " convert(\"2007-12-03\", java.time.LocalDate)" })
public void shouldReturnParserQuery28(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);
Assertions.assertEquals(Operator.OR, condition.getOperator());
conditions = ConditionQueryValue.class.cast(condition.getValue()).get();
assertEquals(2, 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"));
condition = conditions.get(1);
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]);
}
Aggregations