-
Notifications
You must be signed in to change notification settings - Fork 2
/
test_database.py
61 lines (49 loc) · 2.42 KB
/
test_database.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
from database_ctrl import *
from datetime import datetime
tf = '%Y-%m-%d %H:%M:%S'
class Tester():
def __init__(self):
self.tests = 0
self.errors = 0
def testIfAsExpected(self, test, value, expected):
if self.tests == 0:
print()
print("==================================================================================================================================================")
print("== Starting testing.")
print("==================================================================================================================================================")
self.tests += 1
if value == expected:
msg = str(value)+", "
result = "OK"
else:
self.errors += 1
msg = "Actual value " + str(value) + ", expected value: " + str(expected)
result = "FAIL"
print("== Testing {t:<15} {m:<110} {r:s}".format(t=test+":",m=msg,r=result))
def print_stats(self):
print()
print("==================================================================================================================================================")
print("== Test Results.")
print("==================================================================================================================================================")
print("== Ran " + str(self.tests) + " test(s).")
print("== Failed " + str(self.errors) + " test(s).")
print("== " + str(100-self.errors/self.tests*100) + "% of the tests executed correctly.")
dbc = db_commands()
t = Tester()
def test_shifter_functions(self):
# test shifter functions
shifter = {'name':'Eino', 'email':'[email protected]','phone':4741760950,'current':0,'alert':1}
dbc.insert_shifter(shifter)
print(dbc.get_shifter_info('Eino').values())
t.testIfAsExpected('Insert Shifter', dbc.get_shifter_info('Eino'), shifter)
shifter = {'name':'Maris', 'email':'[email protected]','phone':9999999999,'current':1,'alert':0}
dbc.insert_shifter(shifter)
t.testIfAsExpected('Insert Shifter', dbc.get_shifter_info('Maris'), shifter)
t.testIfAsExpected('Set Shifter', dbc.get_current_shifter(), 'Maris')
dbc.set_current_shifter('Eino')
t.testIfAsExpected('Change Shifter', dbc.get_current_shifter(), 'Eino')
t.testIfAsExpected('Get Alertees', dbc.get_alerts(), ['Eino'])
dbc.set_alert(('Maris',1))
t.testIfAsExpected('Get Alertees', dbc.get_alerts(), ['Eino','Maris'])
print(dbc.get_all_shifters())
t.print_stats()