-
Notifications
You must be signed in to change notification settings - Fork 35
/
pagination.lua.html
125 lines (105 loc) · 5.04 KB
/
pagination.lua.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
<head>
<title>lua-cassandra documentation</title>
<link rel="stylesheet" href="../ldoc.css" type="text/css" />
</head>
<body>
<div id="container">
<div id="product">
<div id="product_logo"></div>
<div id="product_name"><big><b></b></big></div>
<div id="product_description"></div>
</div> <!-- id="product" -->
<div id="main">
<!-- Menu -->
<div id="navigation">
<br/>
<h1>lua-cassandra</h1>
<ul>
<li><a href="../index.html">Index</a></li>
</ul>
<h2>Examples</h2>
<ul class="nowrap">
<li><a href="../examples/authentication.lua.html">authentication.lua</a></li>
<li><a href="../examples/batch.lua.html">batch.lua</a></li>
<li><a href="../examples/intro.lua.html">intro.lua</a></li>
<li><strong>pagination.lua</strong></li>
<li><a href="../examples/ssl.lua.html">ssl.lua</a></li>
</ul>
<h2>Modules</h2>
<ul class="nowrap">
<li><a href="../modules/cassandra.html">cassandra</a></li>
<li><a href="../modules/resty.cassandra.cluster.html">resty.cassandra.cluster</a></li>
<li><a href="../modules/resty.cassandra.policies.lb.dc_rr.html">resty.cassandra.policies.lb.dc_rr</a></li>
<li><a href="../modules/resty.cassandra.policies.lb.req_dc_rr.html">resty.cassandra.policies.lb.req_dc_rr</a></li>
<li><a href="../modules/resty.cassandra.policies.lb.req_rr.html">resty.cassandra.policies.lb.req_rr</a></li>
<li><a href="../modules/resty.cassandra.policies.lb.rr.html">resty.cassandra.policies.lb.rr</a></li>
<li><a href="../modules/resty.cassandra.policies.reconnection.const.html">resty.cassandra.policies.reconnection.const</a></li>
<li><a href="../modules/resty.cassandra.policies.reconnection.exp.html">resty.cassandra.policies.reconnection.exp</a></li>
<li><a href="../modules/resty.cassandra.policies.retry.simple.html">resty.cassandra.policies.retry.simple</a></li>
</ul>
<h2>Manual</h2>
<ul class="nowrap">
<li><a href="../manual/README.md.html">README</a></li>
</ul>
</div>
<div id="content">
<h2>pagination.lua</h2>
<pre>
<span class="comment">--------------------
</span><span class="comment">-- manual pagination
</span><span class="comment">--------------------
</span>
<span class="keyword">local</span> cassandra = <span class="global">require</span> <span class="string">"cassandra"</span>
<span class="keyword">local</span> client = <span class="global">assert</span>(cassandra.new {
host = <span class="string">"127.0.0.1"</span>,
keyspace = <span class="string">"my_keyspace"</span>
})
client:settimeout(<span class="number">1000</span>)
<span class="global">assert</span>(client:connect())
<span class="comment">-- assume 1190 rows in users table
</span>
<span class="comment">-- 1st page
</span><span class="keyword">local</span> rows_1 = <span class="global">assert</span>(client:execute(<span class="string">"SELECT * FROM users"</span>))
<span class="global">print</span>(#rows_1) <span class="comment">-- 1000 (default page_size)
</span><span class="global">print</span>(rows_1.meta.has_more_pages) <span class="comment">-- true
</span>
<span class="comment">-- 2nd page
</span><span class="keyword">local</span> rows_2 = <span class="global">assert</span>(client:execute(<span class="string">"SELECT * FROM users"</span>, <span class="keyword">nil</span>, {
page_size = <span class="number">100</span>,
paging_state = rows_1.meta.paging_state
}))
<span class="global">print</span>(#rows_2) <span class="comment">-- 100
</span><span class="global">print</span>(rows_2.meta.has_more_pages) <span class="comment">-- true
</span>
<span class="comment">-- 3rd, last page
</span><span class="keyword">local</span> rows_3 = <span class="global">assert</span>(client:execute(<span class="string">"SELECT * FROM users"</span>, <span class="keyword">nil</span>, {
page_size = <span class="number">100</span>,
paging_state = rows_2.meta.paging_state
}))
<span class="global">print</span>(#rows_3) <span class="comment">-- 90
</span><span class="global">print</span>(rows_3.meta.has_more_pages) <span class="comment">-- false
</span>
<span class="comment">-----------------------
</span><span class="comment">-- automated pagination
</span><span class="comment">-----------------------
</span>
<span class="keyword">for</span> rows, err, page <span class="keyword">in</span> client:iterate(<span class="string">"SELECT * FROM users"</span>) <span class="keyword">do</span>
<span class="keyword">if</span> err <span class="keyword">then</span>
<span class="global">error</span>(err)
<span class="keyword">end</span>
<span class="global">print</span>(page)
<span class="global">print</span>(#rows)
<span class="keyword">end</span></pre>
</div> <!-- id="content" -->
</div> <!-- id="main" -->
<div id="about">
<i>generated by <a href="http://github.com/stevedonovan/LDoc">LDoc 1.4.6</a></i>
<i style="float:right;">Last updated 2021-02-18 11:29:23 </i>
</div> <!-- id="about" -->
</div> <!-- id="container" -->
</body>
</html>