1
|
from src.utils.file_anchor import FileAnchor
|
2
|
|
3
|
DATABASE_FILE = "db/database_sqlite.db"
|
4
|
DATABASE_FILE_LOCATION = FileAnchor("aswi2021jmsd", DATABASE_FILE)
|
5
|
DATETIME_FORMAT = "%d.%m.%Y %H:%M:%S"
|
6
|
|
7
|
# Types of certificates
|
8
|
ROOT_CA_ID = 1
|
9
|
INTERMEDIATE_CA_ID = 2
|
10
|
CERTIFICATE_ID = 3
|
11
|
|
12
|
# Usage types of certificates
|
13
|
CA_ID = 1
|
14
|
SSL_ID = 2
|
15
|
SIGNATURE_ID = 3
|
16
|
AUTHENTICATION_ID = 4
|
17
|
DICT_USAGES = {CA_ID: False, SSL_ID: False, SIGNATURE_ID: False, AUTHENTICATION_ID: False}
|
18
|
|
19
|
# DB names of tables
|
20
|
TAB_CERTIFICATES = "Certificates"
|
21
|
TAB_PRIVATE_KEYS = "PrivateKeys"
|
22
|
TAB_CERTIFICATE_USAGES = "CertificateUsages"
|
23
|
TAB_CERTIFICATE_TYPES = "CertificateTypes"
|
24
|
TAB_USAGE_TYPES = "UsageTypes"
|
25
|
|
26
|
# DB column names
|
27
|
COL_ID = "id"
|
28
|
|
29
|
# DB column names of Certificates table
|
30
|
COL_COMMON_NAME = "common_name"
|
31
|
COL_VALID_FROM = "valid_from"
|
32
|
COL_VALID_TO = "valid_to"
|
33
|
COL_PEM_DATA = "pem_data"
|
34
|
COL_PRIVATE_KEY_ID = "private_key_id"
|
35
|
COL_TYPE_ID = "certificate_type_id"
|
36
|
COL_PARENT_ID = "parent_certificate_id"
|
37
|
|
38
|
# DB column names of PrivateKeys table
|
39
|
COL_PRIVATE_KEY = "private_key"
|
40
|
COL_PASSWORD = "password"
|
41
|
|
42
|
# DB column names of PrivateKey table
|
43
|
COL_CERTIFICATE_ID = "certificate_id"
|
44
|
COL_USAGE_TYPE_ID = "usage_type_id"
|
45
|
|
46
|
# configuration default
|
47
|
DEFAULT_CONNECTION_STRING = "db/database_sqlite.db"
|