Revize 7d439051

Re #8471 - Added initialize test

tests/dao/certificate_repository/conftest.py

@@ +1 @@
+import pytest
+import sqlite3
+from sqlite3 import Connection, Cursor
+
+from src.dao.certificate_repository import CertificateRepository
+from src.constants import DATABASE_FILE
+
+
[e-mail]
+def repository():
+    connection: Connection = sqlite3.connect("../../../" + DATABASE_FILE)
+    cursor: Cursor = connection.cursor()
+    return CertificateRepository(connection, cursor)

tests/dao/certificate_repository/create_certificate.py

@@ +1 @@
+import pytest
+from src.constants import *
+
+
+def test_connection(repository):
+    sql = f"SELECT * FROM {TAB_CERTIFICATE_TYPES}"
+    repository.cursor.execute(sql)
+    selected_rows = repository.cursor.fetchall()
+
+    assert len(selected_rows) > 1
+    assert selected_rows[ROOT_CA_ID - 1][1] == "ROOT_CA"
+    assert selected_rows[INTERMEDIATE_CA_ID - 1][1] == "INTERMEDIATE_CA"
+    assert selected_rows[CERTIFICATE_ID - 1][1] == "CERTIFICATE"