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
126
127
|
#!/usr/bin/env python
#
# Public Domain 2014-2016 MongoDB, Inc.
# Public Domain 2008-2014 WiredTiger, Inc.
#
# This is free and unencumbered software released into the public domain.
#
# Anyone is free to copy, modify, publish, use, compile, sell, or
# distribute this software, either in source code form or as a compiled
# binary, for any purpose, commercial or non-commercial, and by any
# means.
#
# In jurisdictions that recognize copyright laws, the author or authors
# of this software dedicate any and all copyright interest in the
# software to the public domain. We make this dedication for the benefit
# of the public at large and to the detriment of our heirs and
# successors. We intend this dedication to be an overt act of
# relinquishment in perpetuity of all present and future rights to this
# software under copyright law.
#
# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
# EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
# MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
# IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR
# OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
# ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
# OTHER DEALINGS IN THE SOFTWARE.
import wiredtiger, wttest
from wtscenario import make_scenarios
# test_cursor10.py
# Cursors with projections.
class test_cursor10(wttest.WiredTigerTestCase):
"""
Test cursor search and search_near
"""
table_name1 = 'test_cursor10'
nentries = 20
scenarios = make_scenarios([
('row', dict(key_format='S', uri='table')),
('col', dict(key_format='r', uri='table'))
])
def genkey(self, i):
if self.key_format == 'S':
return 'key' + str(i).zfill(5) # return key00001, key00002, etc.
else:
return long(i+1)
def genvalue(self, i):
return [ 'v0:' + str(i), i+1, 'v2' + str(i+2), i+3 ]
def extractkey(self, k):
if self.key_format == 'S':
return int(k[3:])
else:
return long(k-1)
def test_projection(self):
"""
Create entries, and read back in a regular and projected cursor
"""
tablearg = self.uri + ":" + self.table_name1
create_args = 'columns=(k,v0,v1,v2,v3),value_format=SiSi,key_format=' \
+ self.key_format
self.session.create(tablearg, create_args)
cursor = self.session.open_cursor(tablearg, None, None)
for i in range(0, self.nentries):
cursor.set_key(self.genkey(i))
values = self.genvalue(i)
cursor.set_value(*values)
cursor.insert()
cursor.close()
cursor = self.session.open_cursor(tablearg, None, None)
count = 0
for k,v0,v1,v2,v3 in cursor:
i = self.extractkey(k)
self.assertEqual(self.genkey(i), k)
self.assertEqual(self.genvalue(i), [v0,v1,v2,v3])
count += 1
self.assertEqual(count, self.nentries)
cursor.close()
cursor = self.session.open_cursor(tablearg + '(v3,v2,v1,v0,k)',\
None, None)
count = 0
for k1,v3,v2,v1,v0,k2 in cursor:
self.assertEqual(k1, k2)
i = self.extractkey(k1)
self.assertEqual(self.genkey(i), k1)
self.assertEqual(self.genvalue(i), [v0,v1,v2,v3])
count += 1
self.assertEqual(count, self.nentries)
cursor.close()
def test_index_projection(self):
"""
Create entries, and read back in an index cursor with a projection
"""
tablearg = self.uri + ":" + self.table_name1
indexarg = 'index:' + self.table_name1 + ':index1'
create_args = 'columns=(k,v0,v1,v2,v3),value_format=SiSi,key_format=' \
+ self.key_format
self.session.create(tablearg, create_args)
self.session.create(indexarg, 'columns=(v0,v2,v1,v3)')
cursor = self.session.open_cursor(tablearg, None, None)
for i in range(0, self.nentries):
cursor.set_key(self.genkey(i))
values = self.genvalue(i)
cursor.set_value(*values)
cursor.insert()
cursor.close()
cursor = self.session.open_cursor(tablearg + '(v3,v2,v1,v0,k)',\
None, None)
count = 0
for k1,v3,v2,v1,v0,k2 in cursor:
self.assertEqual(k1, k2)
i = self.extractkey(k1)
self.assertEqual(self.genkey(i), k1)
self.assertEqual(self.genvalue(i), [v0,v1,v2,v3])
count += 1
self.assertEqual(count, self.nentries)
cursor.close()
if __name__ == '__main__':
wttest.run()
|