n1ql and sdk support for java – couchbase live new york 2015

25
N1QL on the Java SDK

Upload: couchbase

Post on 27-Jan-2017

528 views

Category:

Software


0 download

TRANSCRIPT

Page 1: N1QL and SDK Support for Java – Couchbase Live New York 2015

N1QL on the Java SDK

Page 2: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 2

Java

2

N1qlQueryor Statement

Page 3: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 3

Java

3

[+ N1qlParams ]

Page 4: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 4

Java

4

[+ JsonArray ]for placeholder values

Page 5: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 5

Java

5

N1qlQuery=

Page 6: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 6

Java

6

N1qlQuery.simple(...)

Page 7: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 7

Java

7

N1qlQuery.parametrized(...)

Page 8: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 8

Java

8

the N1qlQueryRes

ult

Page 9: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 9

Java

9

the N1qlQueryResultparseSuccess()

finalSuccess()

Page 10: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 10

Java

10

the N1qlQueryResultallRows()errors()info()

Page 11: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 11

Java

11

the N1qlQueryResultrequestId()

clientContextId()signature()

Page 12: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 12

Java

12

the N1qlQueryResult can be an

AsyncN1qlQueryResult

Page 13: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 13

Java

13

the Builder APIbuilding SELECT statements with code

Page 14: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 14

Java

14

import static Select.select;

import static Expression.*;

Page 15: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 15

Java

15

SELECT *FROM `bucket`

WHERE token > 100

Page 16: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 16

Java

16

select("*").from(i("bucket"))

.where(x("token").gt(100))

Page 17: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 17

Java

17

select("*").from(i("bucket"))

.where(x("token").gt(100))

Page 18: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 18

Java

18

select("*").from(i("bucket"))

.where(x("token").gt(100))

Page 19: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 19

Java

19

select("*").from(i("bucket"))

.where(x("token").gt(100))

Page 20: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 20

Java

20

select("*").from(i("bucket"))

.where(x("token").gt(100))

Page 21: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 21

Java

21

select("*").from(i("bucket"))

.where(x("token").gt(100))

Page 22: N1QL and SDK Support for Java – Couchbase Live New York 2015

©2015 Couchbase Inc. 22

Java

22

select("*").from(i("bucket"))

.where(x("token").gt(100))

Page 23: N1QL and SDK Support for Java – Couchbase Live New York 2015

Demo

Page 24: N1QL and SDK Support for Java – Couchbase Live New York 2015

Q&A

Page 25: N1QL and SDK Support for Java – Couchbase Live New York 2015

Thank you.