-
Notifications
You must be signed in to change notification settings - Fork 193
/
testfunctions.py
164 lines (145 loc) · 7.07 KB
/
testfunctions.py
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
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
import os
import sys
import unittest
import re
import glob
import inspect
import platform
import ibm_db
import config
if sys.version_info >= (3, ):
from io import StringIO
else:
from cStringIO import StringIO
class IbmDbTestFunctions(unittest.TestCase):
prepconn = ibm_db.connect(config.database, config.user, config.password)
server = ibm_db.server_info(prepconn)
ibm_db.close(prepconn)
# See the tests.py comments for this function.
def setUp(self):
pass
# This function captures the output of the current test file.
def capture(self, func):
buffer = StringIO()
sys.stdout = buffer
func()
sys.stdout = sys.__stdout__
# str() ensures not Unicode object on Python 2
var = str(buffer.getvalue())
var = var.replace('\n', '').replace('\r', '')
return var
def testCasesIn(self, fileName):
if (fileName.startswith('ibm_db_tests/test_017') or \
fileName.startswith('ibm_db_tests/test_005') or \
fileName.startswith('ibm_db_tests/test_018') or \
fileName.startswith('ibm_db_tests/test_019') or \
fileName.startswith('ibm_db_tests/test_024') or \
fileName.startswith('ibm_db_tests/test_053') or \
fileName.startswith('ibm_db_tests/test_054') or \
fileName.startswith('ibm_db_tests/test_080') or \
fileName.startswith('ibm_db_tests/test_081') or \
fileName.startswith('ibm_db_tests/test_082') or \
fileName.startswith('ibm_db_tests/test_090') or \
fileName.startswith('ibm_db_tests/test_091') or \
fileName.startswith('ibm_db_tests/test_092') or \
fileName.startswith('ibm_db_tests/test_103') or \
fileName.startswith('ibm_db_tests/test_116') or \
fileName.startswith('ibm_db_tests/test_133') or \
fileName.startswith('ibm_db_tests/test_147') or \
fileName.startswith('ibm_db_tests/test_157a') or \
fileName.startswith('ibm_db_tests/test_240') or \
fileName.startswith('ibm_db_tests/test_241') or \
fileName.startswith('ibm_db_tests/test_cursortype') or \
fileName.startswith('ibm_db_tests/test_decfloat') or \
fileName.startswith('ibm_db_tests/test_setgetOption') or \
fileName.startswith('ibm_db_tests/test_warn') \
):
return True
else:
return False
# This function grabs the expected output of the current test function for LUW,
# located at the bottom of the current test file.
def expected_LUW(self, fileName):
fileHandle = open(fileName, 'r')
fileInput = fileHandle.read().split('#__LUW_EXPECTED__')[-1].split('#__ZOS_EXPECTED__')[0].replace('\n', '').replace('#', '')
fileHandle.close()
return fileInput
# This function grabs the expected output of the current test function for IDS,
# located at the bottom of the current test file.
def expected_IDS(self, fileName):
fileHandle = open(fileName, 'r')
fileInput = fileHandle.read().split('#__IDS_EXPECTED__')[-1].split('#__ZOS_ODBC_EXPECTED__')[0].replace('\n', '').replace('#', '')
fileHandle.close()
return fileInput
# This function grabs the expected output of the current test function for zOS,
# located at the bottom of the current test file.
def expected_ZOS(self, fileName):
fileHandle = open(fileName, 'r')
fileInput = fileHandle.read().split('#__ZOS_EXPECTED__')[-1].split('#__SYSTEMI_EXPECTED__')[0].replace('\n', '').replace('#', '')
fileHandle.close()
return fileInput
# This function grabs the expected output of the current test function for zOS,
# located at the bottom of the current test file.
def expected_AS(self, fileName):
fileHandle = open(fileName, 'r')
fileInput = fileHandle.read().split('#__SYSTEMI_EXPECTED__')[-1].split('#__IDS_EXPECTED__')[0].replace('\n', '').replace('#', '')
fileHandle.close()
return fileInput
# This function grabs the expected output of the current test function for z/OS ODBC driver,
# located at the bottom of the current test file.
def expected_ZOS_ODBC(self, fileName):
fileHandle = open(fileName,'r')
fileInput = fileHandle.read().split('#__ZOS_ODBC_EXPECTED__')[-1].replace('\n', "").replace('#', '')
fileHandle.close()
return fileInput
# This function compares the captured outout with the expected out of
# the current test file.
def assert_expect(self, testFuncName):
callstack = inspect.stack(0)
try:
if (self.server.DBMS_NAME[0:2] == "AS"):
self.assertEqual(self.capture(testFuncName), self.expected_AS(callstack[1][1]))
elif (platform.system() == 'z/OS' or platform.system() == 'OS/390' and self.testCasesIn(callstack[1][1])):
self.assertEqual(self.capture(testFuncName), self.expected_ZOS_ODBC(callstack[1][1]))
elif (self.server.DBMS_NAME == "DB2" or "DSN" in self.server.DBMS_NAME):
self.assertEqual(self.capture(testFuncName), self.expected_ZOS(callstack[1][1]))
elif (self.server.DBMS_NAME[0:3] == "IDS"):
self.assertEqual(self.capture(testFuncName), self.expected_IDS(callstack[1][1]))
else:
self.assertEqual(self.capture(testFuncName), self.expected_LUW(callstack[1][1]))
finally:
del callstack
# This function will compare using Regular Expressions
# based on the server
def assert_expectf(self, testFuncName):
callstack = inspect.stack(0)
try:
if (self.server.DBMS_NAME[0:2] == "AS"):
pattern = self.expected_AS(callstack[1][1])
elif (platform.system() == 'z/OS' or platform.system() == 'OS/390' and self.testCasesIn(callstack[1][1])):
pattern = self.expected_ZOS_ODBC(callstack[1][1])
elif (self.server.DBMS_NAME == "DB2" or "DSN" in self.server.DBMS_NAME):
pattern = self.expected_ZOS(callstack[1][1])
elif (self.server.DBMS_NAME[0:3] == "IDS"):
pattern = self.expected_IDS(callstack[1][1])
else:
pattern = self.expected_LUW(callstack[1][1])
sym = ['\[','\]','\(','\)']
for chr in sym:
pattern = re.sub(chr, '\\' + chr, pattern)
pattern = re.sub('%s', '.*?', pattern)
if sys.version_info >=(3,7 ):
pattern = re.sub('%d', r'\\d+', pattern)
else:
pattern = re.sub('%d', '\\d+', pattern)
result = re.match(pattern, self.capture(testFuncName))
self.assertNotEqual(result, None)
finally:
del callstack
#def assert_throw_blocks(self, testFuncName):
# callstack = inspect.stack(0)
# try:
# This function needs to be declared here, regardless of if there
# is any body to this function
def runTest(self):
pass