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
|
##
# .test.cursor_integrity
##
import os
import unittest
import random
import itertools
iot = '_dst'
getq = "SELECT i FROM generate_series(0, %d) AS g(i)"
copy = "COPY (%s) TO STDOUT"
def random_read(curs, remaining_rows):
"""
Read from one of the three methods using a random amount if sized.
- 50% chance of curs.read(random())
- 40% chance of next()
- 10% chance of read() # no count
"""
if random.random() > 0.5:
rrows = random.randrange(0, remaining_rows)
return curs.read(rrows), rrows
elif random.random() < 0.1:
return curs.read(), -1
else:
try:
return [next(curs)], 1
except StopIteration:
return [], 1
def random_select_get(limit):
return prepare(getq %(limit - 1,))
def random_copy_get(limit):
return prepare(copy %(getq %(limit - 1,),))
class test_integrity(unittest.TestCase):
"""
test the integrity of the get and put interfaces on queries
and result handles.
"""
def test_select(self):
total = 0
while total < 10000:
limit = random.randrange(500000)
read = 0
total += limit
p = random_select_get(limit)()
last = ([(-1,)], 1)
completed = [last[0]]
while True:
next = random_read(p, (limit - read) or 10)
thisread = len(next[0])
read += thisread
completed.append(next[0])
if thisread:
self.failUnlessEqual(
last[0][-1][0], next[0][0][0] - 1,
"first row(-1) of next failed to match the last row of the previous"
)
last = next
elif next[1] != 0:
# done
break
self.failUnlessEqual(read, limit)
self.failUnlessEqual(list(range(-1, limit)), [
x[0] for x in itertools.chain(*completed)
])
def test_insert(self):
pass
if 'db' in dir(__builtins__) and pg.version_info >= (8,2,0):
def test_copy_out(self):
total = 0
while total < 10000000:
limit = random.randrange(500000)
read = 0
total += limit
p = random_copy_get(limit)()
last = ([-1], 1)
completed = [last[0]]
while True:
next = random_read(p, (limit - read) or 10)
next = ([int(x) for x in next[0]], next[1])
thisread = len(next[0])
read += thisread
completed.append(next[0])
if thisread:
self.failUnlessEqual(
last[0][-1], next[0][0] - 1,
"first row(-1) of next failed to match the last row of the previous"
)
last = next
elif next[1] != 0:
# done
break
self.failUnlessEqual(read, limit)
self.failUnlessEqual(
list(range(-1, limit)),
list(itertools.chain(*completed))
)
def test_copy_in(self):
pass
def main():
global copyin, loadin
execute("CREATE TEMP TABLE _dst (i bigint)")
copyin = prepare("COPY _dst FROM STDIN")
loadin = prepare("INSERT INTO _dst VALUES ($1)")
unittest.main()
if __name__ == '__main__':
main()
|
