@Override public long removeByPattern(String regex) throws IOException { Statement statement = Delete.deleteFromCurrentBucket().where(regexpContains("meta().id", regex)); final N1qlQueryResult result = bucket.query(N1qlQuery.simple(statement)); if (logger.isDebugEnabled()) { logger.debug("Deleted documents using regex {}, result={}", regex, result); } return result.info().mutationCount(); } }
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; } }
public static boolean fillDB(CouchbaseCluster cluster) { Bucket couchbaseBucket = cluster.openBucket(BUCKET_NAME); couchbaseBucket.insert(JsonDocument.create("artist:vincent_van_gogh", VINCENT_VAN_GOGH)); N1qlQueryResult queryResult = couchbaseBucket.query(N1qlQuery.simple(String.format(QUERY, BUCKET_NAME), N1qlParams.build().consistency(ScanConsistency.REQUEST_PLUS))); couchbaseBucket.close(); return queryResult.info().resultCount() == 1; }