| 1 |
2c96b4a5
|
David Friesecký
|
DATABASE_FILE = r"C:\sqlite\db\pythonsqlite.db"
|
| 2 |
|
|
|
| 3 |
|
|
ROOT_CA_ID = 1
|
| 4 |
|
|
INTERMEDIATE_CA_ID = 2
|
| 5 |
|
|
CERTIFICATE_ID = 3
|
| 6 |
|
|
|
| 7 |
|
|
CA_ID = 1
|
| 8 |
|
|
SSL_ID = 2
|
| 9 |
|
|
SIGNATURE_ID = 3
|
| 10 |
|
|
AUTHENTICATION_ID = 4
|
| 11 |
993ee5a1
|
David Friesecký
|
DICT_USAGES = {CA_ID: False, SSL_ID: False, SIGNATURE_ID: False, AUTHENTICATION_ID: False}
|
| 12 |
|
|
|
| 13 |
b5114e4e
|
David Friesecký
|
|
| 14 |
|
|
# DB names of tables
|
| 15 |
993ee5a1
|
David Friesecký
|
TAB_CERTIFICATES = "Certificates"
|
| 16 |
|
|
TAB_PRIVATE_KEYS = "PrivateKeys"
|
| 17 |
|
|
TAB_CERTIFICATE_USAGES = "CertificateUsages"
|
| 18 |
b5114e4e
|
David Friesecký
|
|
| 19 |
|
|
# DB column names
|
| 20 |
|
|
COL_ID = "id"
|
| 21 |
|
|
|
| 22 |
993ee5a1
|
David Friesecký
|
# DB column names of Certificates table
|
| 23 |
b5114e4e
|
David Friesecký
|
COL_COMMON_NAME = "common_name"
|
| 24 |
|
|
COL_VALID_FROM = "valid_from"
|
| 25 |
|
|
COL_VALID_TO = "valid_to"
|
| 26 |
|
|
COL_PEM_DATA = "pem_data"
|
| 27 |
|
|
COL_PRIVATE_KEY_ID = "private_key_id"
|
| 28 |
993ee5a1
|
David Friesecký
|
COL_TYPE_ID = "certificate_type_id"
|
| 29 |
b5114e4e
|
David Friesecký
|
|
| 30 |
993ee5a1
|
David Friesecký
|
# DB column names of PrivateKeys table
|
| 31 |
b5114e4e
|
David Friesecký
|
COL_PRIVATE_KEY = "private_key"
|
| 32 |
|
|
COL_PASSWORD = "password"
|
| 33 |
993ee5a1
|
David Friesecký
|
|
| 34 |
|
|
# DB column names of PrivateKey table
|
| 35 |
|
|
COL_CERTIFICATE_ID = "certificate_id"
|
| 36 |
|
|
COL_USAGE_TYPE_ID = "usage_type_id"
|