/usr/lib/python3/dist-packages/postgresql/test/cursor_integrity.py is in python3-postgresql 1.1.0-1build1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
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()
|