forked from benevolentprof/inf1340_2015_asst2
-
Notifications
You must be signed in to change notification settings - Fork 0
/
test_exercise3.py
128 lines (95 loc) · 3.47 KB
/
test_exercise3.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
#!/usr/bin/env python
from exercise3 import union, intersection, difference, MismatchedAttributesException
""" Assignment 2, Exercise 3, INF1340, Fall, 2015. DBMS
Test module for exercise3.py
"""
__author__ = 'Erin_Mib'
###########
# TABLES ##
###########
GRADUATES = [["Number", "Surname", "Age"],
[7274, "Robinson", 37],
[7432, "O'Malley", 39],
[9824, "Darkes", 38]]
MANAGERS = [["Number", "Surname", "Age"],
[9297, "O'Malley", 56],
[7432, "O'Malley", 39],
[9824, "Darkes", 38]]
NON_IDENTICAL = [["Number", "First Name", "Surname", "Date of Birth"],
[9297, "Andy", "O'Malley", "12/12/58"],
[7432, "Barbara", "O'Malley", "03/05/76"],
[9824, "Carl", "Darkes", "07/04/77"]]
ADDITIONAL_ROWS = [["Number", "Surname", "Age"],
[7432, "O'Malley", 39],
[9824, "Darkes", 38],
[1346, "Shannan", 24],
[2954, "Ericson", 36],
[1425, "Tester", 82]]
#####################
# HELPER FUNCTIONS ##
#####################
def is_equal(t1, t2):
return set(map(tuple, t1)) == set(map(tuple, t2))
###################
# TEST FUNCTIONS ##
###################
def test_union():
"""
Test union operation.
"""
result = [["Number", "Surname", "Age"],
[7274, "Robinson", 37],
[9297, "O'Malley", 56],
[7432, "O'Malley", 39],
[9824, "Darkes", 38]]
result_extended = [["Number", "Surname", "Age"],
[7274, "Robinson", 37],
[7432, "O'Malley", 39],
[9824, "Darkes", 38],
[1346, "Shannan", 24],
[2954, "Ericson", 36],
[1425, "Tester", 82]]
assert is_equal(result, union(GRADUATES, MANAGERS))
# test for MismatchedAttributesException
try:
union(GRADUATES, NON_IDENTICAL)
except MismatchedAttributesException:
assert True
# test for different row lengths
assert is_equal(result_extended, union(GRADUATES, ADDITIONAL_ROWS))
def test_intersection():
"""
Test intersection operation.
"""
result = [["Number", "Surname", "Age"],
[7432, "O'Malley", 39],
[9824, "Darkes", 38]]
result_extended = [["Number", "Surname", "Age"],
[7432, "O'Malley", 39],
[9824, "Darkes", 38]]
assert is_equal(result, intersection(GRADUATES, MANAGERS))
# test for MismatchedAttributesException
try:
intersection(GRADUATES, NON_IDENTICAL)
except MismatchedAttributesException:
assert True
# test for different row lengths
assert is_equal(result_extended, intersection(GRADUATES, ADDITIONAL_ROWS))
def test_difference():
"""
Test difference operation.
"""
result = [["Number", "Surname", "Age"],
[7274, "Robinson", 37]]
result_extended = [["Number", "Surname", "Age"],
[1346, "Shannan", 24],
[2954, "Ericson", 36],
[1425, "Tester", 82]]
assert is_equal(result, difference(GRADUATES, MANAGERS))
# test for MismatchedAttributesException
try:
difference(GRADUATES, NON_IDENTICAL)
except MismatchedAttributesException:
assert True
# test for different row lengths
assert is_equal(result_extended, difference(ADDITIONAL_ROWS, GRADUATES))