forked from azinman/cascal
-
Notifications
You must be signed in to change notification settings - Fork 10
/
TestSecondaryIndex.scala
102 lines (69 loc) · 2.85 KB
/
TestSecondaryIndex.scala
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
package com.shorrockin.cascal
import org.junit.{Assert, Test}
import com.shorrockin.cascal.utils.Conversions._
import Assert._
class TestSeconderyIndex extends EmbeddedCassandra {
val family = "Test" \ "StandardIndexed"
val key1 = family \ "key1"
val key2 = family \ "key2"
@Test def eqExpression = borrow { (session) =>
session.insert(key1 \ "column1" \ "b")
session.insert(key1 \ "column2" \ "c")
session.insert(key2 \ "column1" \ "b")
val query = family where "column1" Eq "b" startAt "a"
val rows = session.list(query)
assertEquals(2, rows.size)
}
@Test def eqExpressionForLongType = borrow { (session) =>
session.insert(key1 \ "longColumn" \ 1L)
session.insert(key2 \ "longColumn" \ 2L)
val query = family where "longColumn" Eq 1L startAt 0
val rows = session.list(query)
assertEquals(1, rows.size)
}
@Test def eqAndGtExpression = borrow { (session) =>
session.insert(key1 \ "column1" \ "b")
session.insert(key1 \ "column2" \ "c")
session.insert(key2 \ "column1" \ "b")
session.insert(key2 \ "column2" \ "b")
val query = family where "column1" Eq "b" and "column2" Gt "b" startAt "a"
val rows = session.list(query)
assertEquals(1, rows.size)
}
@Test def eqAndGteExpression = borrow { (session) =>
session.insert(key1 \ "column1" \ "b")
session.insert(key1 \ "column2" \ "c")
session.insert(key2 \ "column1" \ "b")
session.insert(key2 \ "column2" \ "b")
val query = family where "column1" Eq "b" and "column2" Gte "b" startAt "a"
val rows = session.list(query)
assertEquals(2, rows.size)
}
@Test def eqAndLtExpression = borrow { (session) =>
session.insert(key1 \ "column1" \ "b")
session.insert(key1 \ "column2" \ "a")
session.insert(key2 \ "column1" \ "b")
session.insert(key2 \ "column2" \ "b")
val query = family where "column1" Eq "b" and "column2" Lt "b" startAt "a"
val rows = session.list(query)
assertEquals(1, rows.size)
}
@Test def eqAndLteExpression = borrow { (session) =>
session.insert(key1 \ "column1" \ "b")
session.insert(key1 \ "column2" \ "a")
session.insert(key2 \ "column1" \ "b")
session.insert(key2 \ "column2" \ "b")
val query = family where "column1" Eq "b" and "column2" Lte "b" startAt "a"
val rows = session.list(query)
assertEquals(2, rows.size)
}
@Test def limitNumberOfResult = borrow { (session) =>
session.insert(key1 \ "column1" \ "b")
session.insert(key1 \ "column2" \ "a")
session.insert(key2 \ "column1" \ "b")
session.insert(key2 \ "column2" \ "b")
val query = family where "column1" Eq "b" and "column2" Lte "b" startAt "a" limit 1
val rows = session.list(query)
assertEquals(1, rows.size)
}
}