Upandnql - srujanabala/springboot-couchbase GitHub Wiki
@GetMapping(path = "sdk/get/ds/map/{id}") public String getAllDataStructuresUsingSDK(@PathVariable("id")final String id) { Bucket bucket = CouchBaseHelper.getBucket(); bucket.mapAdd(id, "name", "Mark Nunberg", MutationOptionBuilder.builder().createDocument(true)); return bucket.get(id).content().toString(); }
@GetMapping(path = "/sdk/get/n1ql1")
public String getAllUsingSDKN1QL() throws Exception {
Bucket bucket = CouchBaseHelper.getBucket();
String query = "SELECT name FROM New " + "WHERE name = 'Abhishek' LIMIT 100";
N1qlQueryResult result = bucket.query(N1qlQuery.simple(query));
System.out.println(result.allRows().get(0).value());
System.out.println(result.allRows().get(0).value().get("name"));
JsonObject pVal = JsonObject.create().put("name", "Shankle");
String query1 = "SELECT * FROM New " + "WHERE name = $name LIMIT 50";
N1qlQueryResult r2 = bucket.query(N1qlQuery.parameterized(query1, pVal));
System.out.println(r2.toString());
System.out.println(r2.allRows().get(0).value().get("New"));
return result.toString();
}