Examples with Bucket com.couchbase.client.java.Bucket used on opensource projects

Example 21 with Bucket

use of com.couchbase.client.java.Bucket in project tutorials by eugenp.

the class N1QLIntegrationTest method givenDeleteStatement2_whenQuery_thenDelete.

@Test
public void givenDeleteStatement2_whenQuery_thenDelete() {
    Bucket bucket = bucketFactory.getTravelSampleBucket();
    String query5 = "DELETE FROM `travel-sample` WHERE id = 0 RETURNING *";
    N1qlQueryResult result5 = bucket.query(N1qlQuery.simple(query5));
}

Example 22 with Bucket

use of com.couchbase.client.java.Bucket in project tutorials by eugenp.

the class N1QLIntegrationTest method givenSelectStatementWithDSL2_whenQuery_thenResult.

@Test
public void givenSelectStatementWithDSL2_whenQuery_thenResult() {
    Bucket bucket = bucketFactory.getTravelSampleBucket();
    Statement st2 = select(x("t.city, t.airportname").concat(s(" (")).concat(x("t.faa")).concat(s(")")).as("portname_faa")).from(i("travel-sample").as("t")).where(x("t.type").eq(s("airport")).and(x("t.country").like(s("%States"))).and(x("t.geo.lat").gte(70))).limit(2);
    N1qlQueryResult r5 = bucket.query(N1qlQuery.simple(st2));
    List<JsonNode> list5 = extractJsonResult(r5);
    System.out.println("First Doc : " + list5.get(0));
    System.out.println("Query from Statement2: " + st2.toString());
}

Example 23 with Bucket

use of com.couchbase.client.java.Bucket in project tutorials by eugenp.

the class N1QLIntegrationTest method givenDocument_whenInsert_thenResults.

@Test
public void givenDocument_whenInsert_thenResults() {
    Bucket bucket = bucketFactory.getTravelSampleBucket();
    JsonObject ob = JsonObject.create().put("id", "1293").put("name", "Sample Airline").put("type", "airline");
    bucket.insert(JsonDocument.create("cust1295", ob));
}

Example 24 with Bucket

use of com.couchbase.client.java.Bucket in project tutorials by eugenp.

the class N1QLIntegrationTest method givenUpdateStatement_whenQuery_thenUpdate.

@Test
public void givenUpdateStatement_whenQuery_thenUpdate() {
    Bucket bucket = bucketFactory.getTravelSampleBucket();
    String query2 = "UPDATE `travel-sample` USE KEYS \"cust_1\" " + "SET name=\"Sample Airline Updated\" RETURNING name";
    N1qlQueryResult result = bucket.query(N1qlQuery.simple(query2));
    result.forEach(System.out::println);
}

Example 25 with Bucket

use of com.couchbase.client.java.Bucket in project tutorials by eugenp.

the class N1QLIntegrationTest method givenInsertStatement_whenQuery_thenUpdate.

@Test
public void givenInsertStatement_whenQuery_thenUpdate() {
    Bucket bucket = bucketFactory.getTravelSampleBucket();
    String query = "INSERT INTO `travel-sample` (KEY, VALUE) " + " VALUES(" + "\"cust1293\", " + "{\"id\":\"1293\",\"name\":\"Sample Airline\", \"type\":\"airline\"})" + " RETURNING META().id as docid, *";
    N1qlQueryResult r1 = bucket.query(N1qlQuery.simple(query));
    r1.forEach(System.out::println);
}