Revize fe297740

Connection string configuration hotfix

src/config/connection_provider.py

@@ -1 +1 @@
 import os
 import sqlite3
 from sqlite3 import Connection
-
+from pathlib import Path
 from injector import Module, provider, singleton
 
 from src.config.configuration import Configuration
-from src.constants import DB_DIR, TEST_DATABASE_FILE, SCHEMA_SQL_FILE, VALUES_SQL_FILE
+from src.constants import TEST_DATABASE_FILE, SCHEMA_SQL_FILE, VALUES_SQL_FILE
 from src.utils.file_anchor import FileAnchor
 from src.utils.logger import Logger
 
@@ -27 +27 @@
         Logger.debug(f"Creating a database connection [{configuration.connection_string}].")
 
         try:
-            if not os.path.exists(FileAnchor(configuration.root_dir, DB_DIR).shortest_relative_path()) and \
+            db_file = FileAnchor(configuration.root_dir, configuration.connection_string)
+            db_path = Path(db_file.shortest_relative_path())
+            if not os.path.exists(db_path.parent.absolute()) and \
                     configuration.connection_string != TEST_DATABASE_FILE:
-                os.makedirs(FileAnchor(configuration.root_dir, DB_DIR).shortest_relative_path())
+                os.makedirs(db_path.parent.absolute())
 
             co = sqlite3.connect(database=configuration.connection_string, check_same_thread=False)
             cu = co.cursor()

src/constants.py

@@ -1 +1 @@
 # Database
 INMEMORY_DATABASE_FILE = ":memory:"
 TEST_DATABASE_FILE = INMEMORY_DATABASE_FILE
-DB_DIR = "db"
 DATETIME_FORMAT = "%a, %d %b %Y"
 SCHEMA_SQL_FILE = "SQLite_database.sql"
 VALUES_SQL_FILE = "SQLite_default_values.sql"