-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathdatabase_test.py
69 lines (48 loc) · 2.88 KB
/
database_test.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
from database import *
from passlib.hash import sha512_crypt
SECURITY_PASSWORD_SALT = 'securitykey'
db_manager = DatabaseManager()
# Create users
db_manager.create_user('cor', '[email protected]', True, sha512_crypt.encrypt('Hunter2', salt=SECURITY_PASSWORD_SALT, rounds=5000))
db_manager.create_user('leon', '[email protected]', True, sha512_crypt.encrypt('all_i_see_is_*****', salt=SECURITY_PASSWORD_SALT, rounds=5000))
db_manager.create_user('philip', '[email protected]', True, sha512_crypt.encrypt('***hunter***', salt=SECURITY_PASSWORD_SALT, rounds=5000))
# Create lists
db_manager.create_list('cor', 'duitse_woorden', 'dut', 'ger', '2')
db_manager.create_list('cor', 'engelse_woorden', 'dut', 'eng', '1')
db_manager.create_list('leon', 'latijn_woorden', 'dut', 'lat', '0')
# Create translations
db_manager.create_translation('cor', 'engelse_woorden', 'auto', 'car')
db_manager.create_translation('cor', 'engelse_woorden', 'boom', 'tree')
db_manager.create_translation('cor', 'engelse_woorden', 'moeder', 'mother')
db_manager.create_translation('cor', 'engelse_woorden', 'vader', 'father')
db_manager.create_translation('cor', 'engelse_woorden', 'broer', 'bro')
db_manager.create_translation('cor', 'engelse_woorden', 'muis', 'mouse')
db_manager.create_translation('cor', 'engelse_woorden', 'toetsenbord', 'keyboard')
db_manager.create_translation('cor', 'engelse_woorden', 'fiets', 'bike')
db_manager.create_translation('cor', 'engelse_woorden', 'appel', 'apple')
db_manager.create_translation('cor', 'engelse_woorden', 'ding', 'thing')
db_manager.create_translation('cor', 'engelse_woorden', 'wolk', 'cloud')
db_manager.create_translation('cor', 'engelse_woorden', 'scherm', 'screen')
db_manager.create_translation('cor', 'engelse_woorden', 'potlood', 'pencil')
db_manager.create_translation('cor', 'engelse_woorden', 'muziek', 'music')
db_manager.create_translation('cor', 'duitse_woorden', 'de auto', 'das Auto')
db_manager.create_translation('cor', 'duitse_woorden', 'kamp', 'kampf')
db_manager.create_translation('cor', 'duitse_woorden', 'geodriehoek', 'geometrie dreieck')
db_manager.create_translation('leon', 'latijn_woorden', 'rust', 'requiescat')
db_manager.create_translation('leon', 'latijn_woorden', 'in', 'im')
db_manager.create_translation('leon', 'latijn_woorden', 'vrede', 'pace')
# Get a list of all usernames
print(db_manager.get_username_list())
# Check if a username exists
print(db_manager.username_exists('cor')) # True
print(db_manager.username_exists('henk')) # False
# Get user info by name
print(db_manager.get_user('cor'))
print(db_manager.get_user('leon'))
print(db_manager.get_user('philip'))
# Trying to get user info of a user that doesn't exist returns an error
db_manager.get_user('henk')
# Get allt he lists for a user
print(db_manager.get_lists_for_user('cor'))
print(db_manager.get_list('cor', 'engelse_woorden'))
print(db_manager.get_translations_for_list('cor', 'engelse_woorden'))