Revize 07a6c869

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

src/db/setup_database.py

@@ +1 @@
+import os
 import sqlite3
+from pathlib import Path
 
-from src.constants import DATABASE_FILE_LOCATION
+from src.constants import DATABASE_FILE_LOCATION, DB_DIR
 from src.db.init_queries import SCHEMA_SQL, DEFAULT_VALUES_SQL
 from src.utils.logger import Logger
 
@@ -9 +11 @@
     Logger.debug(f"Database is setting.")
 
     try:
+        # TODO improve creating DB dir
+        if not os.path.exists(DB_DIR):
+            os.makedirs("../../" + DB_DIR)
+
+        # TODO improve creating DB file (now via FileAnchor)
         co = sqlite3.connect(DATABASE_FILE_LOCATION.shortest_relative_path())
         cu = co.cursor()
         cu.executescript(SCHEMA_SQL)
@@ -21 +28 @@
 
 
 if __name__ == '__main__':
-    setup_database()
+    setup_database()