forked from deadbok/py-puml-tools
-
Notifications
You must be signed in to change notification settings - Fork 3
/
test_SQLParseTables.py
245 lines (209 loc) · 8.17 KB
/
test_SQLParseTables.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
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
# -*- coding: utf-8 -*-
# --------------------------------------------------------------------------------
# "THE BEER-WARE LICENSE" (Revision 42):
# <[email protected]> wrote this file. As long as you retain this notice
# you can do whatever you want with this stuff. If we meet some day, and you think
# this stuff is worth it, you can buy me a beer in return. Martin B. K. Grønholdt
# --------------------------------------------------------------------------------
"""
Name: sqltest..py
Author: Martin Bo Kristensen Grønholdt.
Test SQLParseTable class.
"""
from sqlparsetables import SQLParseTables
import unittest
import sqlite3
class SQLTestBase(SQLParseTables, unittest.TestCase):
subtest = 0
results = False
current_table = None
tables_struct = dict()
def add_table(self, name):
"""
Test adding of tables. This is implemented in the base, as all test
create new tables.
:param name: Name of the new table.
"""
self.results = True
table_names = self.tables_struct.keys()
if self.subtest != 0:
with self.subTest('Test {}'.format(str(self.subtest))):
self.assertIn(name, table_names)
self.current_table = name
else:
self.assertIn(name, self.table_names)
def add_column(self, name, type):
self.results = True
if self.subtest != 0:
with self.subTest('Test {}'.format(str(self.subtest))):
self.fail('Called add_column')
else:
self.fail('Called add_column')
def add_column_primary(self, name, type):
self.results = True
if self.subtest != 0:
with self.subTest('Test {}'.format(str(self.subtest))):
self.fail('Called add_column_primary')
else:
self.fail('Called add_column_primary')
def add_column_foreign(self, name, type, reference):
self.results = True
if self.subtest != 0:
with self.subTest('Test {}'.format(str(self.subtest))):
self.fail('Called add_column_foreign')
else:
self.fail('Called add_column_foreign')
def tearDown(self):
self.assertTrue(self.results, 'No results from parser.')
class SQLParseTableTest(SQLTestBase):
"""CREATE TABLE"""
tables_struct = {
'Test': {
'col': ('INTVAR', False, False)
}
}
def test_table(self):
"""Test simple CREATE TABLE statements"""
self.subtest += 1
sql = 'CREATE TABLE {} ( {} {} {});'.format(
'Test',
'col',
self.tables_struct['Test']['col'][0],
'PRIMARY KEY' if self.tables_struct['Test']['col'][1] else '')
self.parse(sql)
self.subtest += 1
sql = 'CREATE TABLE [{}] ( [{}] [{}] [{}]);'.format(
'Test',
'col',
self.tables_struct['Test']['col'][0],
'PRIMARY KEY' if self.tables_struct['Test']['col'][1] else '')
self.parse(sql)
def add_column(self, name, type):
self.results = True
with self.subTest('Test {}'.format(str(self.subtest))):
self.assertNotEqual(self.current_table, None,
'Trying to instert column with no active table.')
column_names = [col_name for col_name in
self.tables_struct[self.current_table].keys()]
self.assertIn(name, column_names)
self.assertEqual(type,
self.tables_struct[self.current_table][name][0])
def tearDown(self):
self.assertTrue(self.results, 'No results from parser.')
class SQLParsePrimaryKeyTest(SQLTestBase):
"""PRIMARY KEY"""
tables_struct = {
'Test': {
'col': ('INTVAR', True, False)
}
}
def test_table1(self):
"""Test PRIMARY KEY at column definition"""
self.subtest += 1
sql = 'CREATE TABLE {} ( {} {} {});'.format(
'Test',
'col',
self.tables_struct['Test']['col'][0],
'PRIMARY KEY' if self.tables_struct['Test']['col'][1] else '')
self.parse(sql)
self.subtest += 1
sql = 'CREATE TABLE [{}] ( [{}] [{}] {});'.format(
'Test',
'col',
self.tables_struct['Test']['col'][0],
'PRIMARY KEY' if self.tables_struct['Test']['col'][1] else '')
self.parse(sql)
def test_table2(self):
"""Test PRIMARY KEY as CONSTRAINT statement"""
self.subtest += 1
sql = 'CREATE TABLE {} ( {} {}, CONSTRAINT pk_test PRIMARY KEY({}));'.format(
'Test',
'col',
self.tables_struct['Test']['col'][0],
'col')
self.parse(sql)
self.subtest += 1
sql = 'CREATE TABLE [{}] ( [{}] [{}], CONSTRAINT pk_test PRIMARY KEY({}));'.format(
'Test',
'col',
self.tables_struct['Test']['col'][0],
'col')
self.parse(sql)
def add_column_primary(self, name, type):
self.results = True
with self.subTest('Test {}'.format(str(self.subtest))):
self.assertNotEqual(self.current_table, None,
'Trying to instert column with no active table.')
column_names = [col_name for col_name in
self.tables_struct[self.current_table].keys()]
self.assertIn(name, column_names)
self.assertEqual(type,
self.tables_struct[self.current_table][name][0])
def tearDown(self):
self.assertTrue(self.results, 'No results from parser.')
class SQLParseForeignKeyTest(SQLTestBase):
"""FOREIGN KEY"""
foreign = False
tables_struct = {
'Test': {
'col': ('INTVAR', True, 'other(col)')
},
'other': {
'col': ('INTVAR', True, False)
}
}
def test_table(self):
"""Test CONSTRAINT FOREIGN KEY"""
self.subtest += 1
sql = """
CREATE TABLE {} ( {} {} {});
CREATE TABLE {} ( {} {} {}, CONSTRAINT {} FOREIGN KEY ({}) REFERENCES {} );
""".format('other',
'col',
self.tables_struct['other']['col'][0],
'PRIMARY KEY' if self.tables_struct['Test']['col'][1] else '',
'Test',
'col',
self.tables_struct['Test']['col'][0],
'PRIMARY KEY' if self.tables_struct['Test']['col'][1] else '',
'fk_test',
'col',
self.tables_struct['Test']['col'][2])
self.parse(sql)
def add_column_primary(self, name, type):
self.results = True
with self.subTest('Test {}'.format(str(self.subtest))):
self.assertNotEqual(self.current_table, None,
'Trying to insert column with no active table.')
column_names = [col_name for col_name in
self.tables_struct[self.current_table].keys()]
self.assertIn(name, column_names)
self.assertEqual(type,
self.tables_struct[self.current_table][name][0])
def add_column_foreign(self, name, type, reference):
self.results = True
self.foreign = True
with self.subTest('Test {}'.format(str(self.subtest))):
self.assertNotEqual(self.current_table, None,
'Trying to insert column with no active table.')
column_names = [col_name for col_name in
self.tables_struct[self.current_table].keys()]
self.assertIn(name, column_names)
self.assertEqual(type,
self.tables_struct[self.current_table][name][0])
self.assertEqual(reference,
'other.col')
def tearDown(self):
self.assertTrue(self.foreign, 'No foreign keys added.')
SQLTestBase.tearDown(self)
class SQLParseWrongInputTest(SQLTestBase):
def test_table(self):
"""Test malformed SQL input"""
self.subtest += 1
sql = 'dlkjeoi lkdlnj'
with self.assertRaises(sqlite3.OperationalError):
self.parse(sql)
def tearDown(self):
pass
if __name__ == '__main__':
unittest.main()