-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtestDatabase.py
84 lines (72 loc) · 3.29 KB
/
testDatabase.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
import sqlite3
from Database import Database
testDataBase = Database.getInstance()
# testDataBase.registerNewPerson()
# testDataBase.registerNewGame()
# testDataBase.getPersonByUserName()
# testDataBase.getTopPlayersForGameAndDifficulty()
# testDataBase.getGameHistoryForChosenPlayer()
# testDataBase.getGamesSummaryForGameAndDifficultyAndPlayerID()
# print(testDataBase.registerNewPerson("Tester4", 123))
# (pid, gameName, difficulty, outcome, destroyedPawns):
# Bauernschach difficulty 1
testDataBase.registerNewGame(12, "Bauernschach", 1, "won", 3)
testDataBase.registerNewGame(12, "Bauernschach", 1, "cancelled", 5)
testDataBase.registerNewGame(12, "Bauernschach", 1, "lost", 1)
# difficulty 2
testDataBase.registerNewGame(12, "Bauernschach", 2, "cancelled", 3)
testDataBase.registerNewGame(12, "Bauernschach", 2, "won", 5)
testDataBase.registerNewGame(12, "Bauernschach", 2, "lost", 1)
# difficulty 3
testDataBase.registerNewGame(12, "Bauernschach", 3, "lost", 3)
testDataBase.registerNewGame(12, "Bauernschach", 3, "won", 5)
testDataBase.registerNewGame(12, "Bauernschach", 3, "cancelled", 1)
# difficulty 4
testDataBase.registerNewGame(12, "Bauernschach", 4, "cancelled", 3)
testDataBase.registerNewGame(12, "Bauernschach", 4, "lost", 5)
testDataBase.registerNewGame(12, "Bauernschach", 4, "won", 1)
# difficulty 5
testDataBase.registerNewGame(12, "Bauernschach", 5, "cancelled", 3)
testDataBase.registerNewGame(12, "Bauernschach", 5, "won", 5)
testDataBase.registerNewGame(12, "Bauernschach", 5, "lost", 1)
# Dame difficulty 1
testDataBase.registerNewGame(12, "Dame", 1, "won", 1)
testDataBase.registerNewGame(12, "Dame", 1, "cancelled", 2)
testDataBase.registerNewGame(12, "Dame", 1, "lost", 3)
# difficulty 2
testDataBase.registerNewGame(12, "Dame", 2, "cancelled", 3)
testDataBase.registerNewGame(12, "Dame", 2, "won", 5)
testDataBase.registerNewGame(12, "Dame", 2, "lost", 1)
# difficulty 3
testDataBase.registerNewGame(12, "Dame", 3, "lost", 4)
testDataBase.registerNewGame(12, "Dame", 3, "won", 6)
testDataBase.registerNewGame(12, "Dame", 3, "cancelled", 5)
# difficulty 4
testDataBase.registerNewGame(12, "Dame", 4, "cancelled", 0)
testDataBase.registerNewGame(12, "Dame", 4, "lost", 1)
testDataBase.registerNewGame(12, "Dame", 4, "won", 2)
# difficulty 5
testDataBase.registerNewGame(12, "Dame", 5, "cancelled", 3)
testDataBase.registerNewGame(12, "Dame", 5, "won", 2)
testDataBase.registerNewGame(12, "Dame", 5, "lost", 1)
testDataBase.registerNewGame(12, "Bauernschach", 4, "cancelled", 3)
testDataBase.registerNewGame(12, "Bauernschach", 3, "cancelled", 3)
testDataBase.registerNewGame(12, "Bauernschach", 2, "won", 3)
testDataBase.registerNewGame(12, "Bauernschach", 1, "lost", 3)
# print(testDataBase.testSelectRankingData())
# print(testDataBase.getTopPlayersForGameAndDifficulty("Bauernschach", 5, 2))
# print(testDataBase.getTopPlayersForGameAndDifficulty("Bauernschach", 3, 5))
# print(testDataBase.getTopPlayersForGameAndDifficulty("Dame", 5, 2))
# print(testDataBase.getTopPlayersForGameAndDifficulty("Dame", 3, 2))
#
# print(testDataBase.getGamesSummaryForGameAndDifficultyAndPlayerID("Bauernschach", 3, 1))
#
# print(testDataBase.getGameHistoryForChosenPlayer(1))
#
# print(hash(1))
# print(hash(str(1)))
# print(hash(int(str(1))))
# print(hash("Hallo"))
# print(hash(20))
# print(hash(str(20)))
# print(hash(int(str(20))))