Revize 07a6c869

Re #8696 - Improved DB creation
- secured start application without lost data

src/config/connection_provider.py

@@ +1 @@
+import os
 import sqlite3
 from sqlite3 import Connection
 
 from injector import Module, provider, singleton
 
 from src.config.configuration import Configuration
-from src.db.init_queries import DEFAULT_VALUES_SQL
-from src.db.setup_database import SCHEMA_SQL
+from src.constants import DB_DIR
+from src.db.init_queries import DEFAULT_VALUES_SQL, CHECK_SCHEMA_SQL
+from src.db.setup_database import setup_database
 from src.utils.logger import Logger
 
 
@@ -26 +28 @@
         Logger.debug(f"Creating a database connection [{configuration.connection_string}].")
 
         try:
+            if not os.path.exists(DB_DIR):
+                os.makedirs(DB_DIR)
+
             co = sqlite3.connect(database=configuration.connection_string, check_same_thread=False)
             cu = co.cursor()
-            cu.executescript(SCHEMA_SQL)  # TODO change setup_database not to drop tables if they exist
+            cu.executescript(CHECK_SCHEMA_SQL)
             cu.executescript(DEFAULT_VALUES_SQL)
         except sqlite3.Error as e:
             Logger.error(f"Unknown error during database setting.")