JsonObject value = row.value(); if (fields == null) { value = value.getObject(bucketName);
JsonObject content = row.value(); if (fields == null) {
@Test public void shouldExecuteN1ql() { getBucket().query(N1qlQuery.simple("INSERT INTO " + TEST_BUCKET + " (KEY, VALUE) VALUES ('" + ID + "', " + DOCUMENT + ")")); N1qlQueryResult query = getBucket().query(N1qlQuery.simple("SELECT * FROM " + TEST_BUCKET + " USE KEYS '" + ID + "'")); Assert.assertTrue(query.parseSuccess()); Assert.assertTrue(query.finalSuccess()); List<N1qlQueryRow> n1qlQueryRows = query.allRows(); Assert.assertEquals(1, n1qlQueryRows.size()); Assert.assertEquals(DOCUMENT, n1qlQueryRows.get(0).value().get(TEST_BUCKET).toString()); }
private List<JsonObject> executeQuery(N1qlQuery query) { if(this.bucket.isClosed()){ throw new RuntimeException("bucket has been closed before performing the query"); } N1qlQueryResult queryResult = this.bucket.query(query); List<JsonObject> result = null; if (queryResult != null && queryResult.info().errorCount() == 0 && queryResult.info().resultCount() > 0) { result = new ArrayList<JsonObject>(); for (N1qlQueryRow queryRow : queryResult) { result.add(queryRow.value()); } } return result; } }
/** * Execute query. * * @param stmt * the statement * @param em * the entity manager * @return the list */ public List executeQuery(Statement stmt, EntityMetadata em) { N1qlQuery query = N1qlQuery.simple(stmt, N1qlParams.build().consistency(ScanConsistency.REQUEST_PLUS)); N1qlQueryResult list = bucket.query(query); LOGGER.debug("Executed query : " + query.toString() + " on the " + bucket.name() + " Bucket"); validateQueryResults(stmt.toString(), list); List records = new ArrayList<>(); for (N1qlQueryRow row : list) { MetamodelImpl metaModel = (MetamodelImpl) kunderaMetadata.getApplicationMetadata() .getMetamodel(em.getPersistenceUnit()); EntityType entityType = metaModel.entity(em.getEntityClazz()); JsonObject jsonObj = row.value().containsKey(em.getSchema()) ? row.value().getObject(em.getSchema()) : row.value(); records.add(handler.getEntityFromDocument(em.getEntityClazz(), jsonObj, entityType)); } return records; }
// query with a simple string System.out.println("Simple string query:"); N1qlQuery airlineQuery = N1qlQuery.simple("SELECT `travel-sample`.* FROM `travel-sample` WHERE name=\"United Airlines\" AND type=\"airline\""); N1qlQueryResult queryResult = bucket.query(airlineQuery); for (N1qlQueryRow result: queryResult) { System.out.println(result.value()); } //query with a parameter using the DSL System.out.println("Parameterized query using the DSL:"); Statement statement = select(path(i("travel-sample"), "*")).from(i("travel-sample")).where(x("name").eq(x("$airline_param")).and(x("type").eq(s("airline")))); JsonObject placeholderValues = JsonObject.create().put("airline_param", "United Airlines"); N1qlQuery airlineQueryParameterized = N1qlQuery.parameterized(statement, placeholderValues); N1qlQueryResult queryResultParameterized = bucket.query(airlineQueryParameterized); for (N1qlQueryRow row : queryResultParameterized) { System.out.println(row); }
/** {@inheritDoc} */ @Override public Map<String, Property<?>> readAllProperties() { N1qlQuery queryFeatures = N1qlQuery.simple("SELECT * FROM " + couchBaseConnection.getFf4jPropertyBucketName()); N1qlQueryResult queryResult = getPropertyBucket().query(queryFeatures); Map<String, Property<?>> allProperties = new HashMap<>(); for (N1qlQueryRow row : queryResult.allRows()) { Property<?> p = PropertyJsonParser.parseProperty(row.value().get(couchBaseConnection.getFf4jPropertyBucketName()).toString()); allProperties.put(p.getName(), p); } return allProperties; }
/** {@inheritDoc} */ @Override public Map<String, Feature> readAll() { // To retrieve the items we use the BUCKET (not view as KEY/VALUE searches) N1qlQuery queryFeatures = N1qlQuery.simple("SELECT * FROM " + couchBaseConnection.getFf4jFeatureBucketName()); N1qlQueryResult queryResult = getFeatureBucket().query(queryFeatures); Map<String, Feature> allFeatures = new HashMap<>(); for (N1qlQueryRow row : queryResult.allRows()) { Feature f = FeatureJsonParser.parseFeature(row.value().get(couchBaseConnection.getFf4jFeatureBucketName()).toString()); allFeatures.put(f.getUid(), f); } return allFeatures; }
@Override public <T> List<T> findByN1QLProjection(N1qlQuery n1ql, Class<T> entityClass) { checkN1ql(); try { N1qlQueryResult queryResult = queryN1QL(n1ql); if (queryResult.finalSuccess()) { List<N1qlQueryRow> allRows = queryResult.allRows(); List<T> result = new ArrayList<T>(allRows.size()); for (N1qlQueryRow row : allRows) { JsonObject json = row.value(); T decoded = translationService.decodeFragment(json.toString(), entityClass); result.add(decoded); } return result; } else { StringBuilder message = new StringBuilder("Unable to execute query due to the following n1ql errors: "); for (JsonObject error : queryResult.errors()) { message.append('\n').append(error); } throw new CouchbaseQueryExecutionException(message.toString()); } } catch (TranscodingException e) { throw new CouchbaseQueryExecutionException("Unable to execute query", e); } }
@Override public <T> List<T> findByN1QLProjection(N1qlQuery n1ql, Class<T> entityClass) { checkN1ql(); try { N1qlQueryResult queryResult = queryN1QL(n1ql); if (queryResult.finalSuccess()) { List<N1qlQueryRow> allRows = queryResult.allRows(); List<T> result = new ArrayList<T>(allRows.size()); for (N1qlQueryRow row : allRows) { JsonObject json = row.value(); T decoded = translationService.decodeFragment(json.toString(), entityClass); result.add(decoded); } return result; } else { StringBuilder message = new StringBuilder("Unable to execute query due to the following n1ql errors: "); for (JsonObject error : queryResult.errors()) { message.append('\n').append(error); } throw new CouchbaseQueryExecutionException(message.toString()); } } catch (TranscodingException e) { throw new CouchbaseQueryExecutionException("Unable to execute query", e); } }
public List<User> findAll() { if (useCouchbaseForFindAll && couchbaseBucket != null) { try { Statement statement = Select.select("avatarId", "bio", "displayName", "id", "nickname").from(x("default")) .where(x("type").eq(s("user"))).groupBy(x("displayName")); N1qlQueryResult queryResult = couchbaseBucket.query(statement); List<User> users = new ArrayList<User>(); for (N1qlQueryRow qr : queryResult) { users.add(User.fromJsonObject(qr.value())); } return users; } catch (Exception e) { throw new DogePoolException("Error while getting list of users from database", Error.DATABASE, HttpStatus.INTERNAL_SERVER_ERROR, e); } } else { return Arrays.asList(User.USER, User.OTHERUSER); } } }
List<T> result = new ArrayList<T>(allRows.size()); for (N1qlQueryRow row : allRows) { JsonObject json = row.value(); String id = json.getString(SELECT_ID); Long cas = json.getLong(SELECT_CAS);
List<T> result = new ArrayList<T>(allRows.size()); for (N1qlQueryRow row : allRows) { JsonObject json = row.value(); String id = json.getString(SELECT_ID); Long cas = json.getLong(SELECT_CAS);