aswi2021jmsd-gitlab4/src/constants.py @ 19e5260d

from src.utils.file_anchor import FileAnchor

INMEMORY_DATABASE_FILE = ":memory:"
TEST_DATABASE_FILE = INMEMORY_DATABASE_FILE
DATABASE_FILE = "db/database_sqlite.db"
DATABASE_FILE_LOCATION = FileAnchor("aswi2021jmsd", DATABASE_FILE)
DATETIME_FORMAT = "%d.%m.%Y %H:%M:%S"

# Types of certificates
ROOT_CA_ID = 1
INTERMEDIATE_CA_ID = 2
CERTIFICATE_ID = 3

# Usage types of certificates
CA_ID = 1
SSL_ID = 2
SIGNATURE_ID = 3
AUTHENTICATION_ID = 4
DICT_USAGES = {CA_ID: False, SSL_ID: False, SIGNATURE_ID: False, AUTHENTICATION_ID: False}

# DB names of tables
TAB_CERTIFICATES = "Certificates"
TAB_PRIVATE_KEYS = "PrivateKeys"
TAB_CERTIFICATE_USAGES = "CertificateUsages"
TAB_CERTIFICATE_TYPES = "CertificateTypes"
TAB_USAGE_TYPES = "UsageTypes"

# DB column names
COL_ID = "id"

# DB column names of Certificates table
COL_COMMON_NAME = "common_name"
COL_VALID_FROM = "valid_from"
COL_VALID_TO = "valid_to"
COL_PEM_DATA = "pem_data"
COL_PRIVATE_KEY_ID = "private_key_id"
COL_TYPE_ID = "certificate_type_id"
COL_PARENT_ID = "parent_certificate_id"

# DB column names of PrivateKeys table
COL_PRIVATE_KEY = "private_key"
COL_PASSWORD = "password"

# DB column names of PrivateKey table
COL_CERTIFICATE_ID = "certificate_id"
COL_USAGE_TYPE_ID = "usage_type_id"

# configuration default
DEFAULT_CONNECTION_STRING = "db/database_sqlite.db"