Revize 7ad820d0

Re #8927 - Improved loading scripts into DB

src/config/connection_provider.py

@@ -5 +5 @@
 from injector import Module, provider, singleton
 
 from src.config.configuration import Configuration
-from src.constants import DB_DIR, TEST_DATABASE_FILE
-from src.db.init_queries import DEFAULT_VALUES_SQL, CHECK_SCHEMA_SQL
+from src.constants import DB_DIR, TEST_DATABASE_FILE, SCHEMA_SQL_FILE, VALUES_SQL_FILE
 from src.utils.file_anchor import FileAnchor
 from src.utils.logger import Logger
 
@@ -34 +33 @@
 
             co = sqlite3.connect(database=configuration.connection_string, check_same_thread=False)
             cu = co.cursor()
-            cu.executescript(CHECK_SCHEMA_SQL)
-            cu.executescript(DEFAULT_VALUES_SQL)
+
+            schema_sql_file = open(FileAnchor(configuration.root_dir, SCHEMA_SQL_FILE).shortest_relative_path())
+            schema_sql = schema_sql_file.read()
+
+            values_sql_file = open(FileAnchor(configuration.root_dir, VALUES_SQL_FILE).shortest_relative_path())
+            values_sql = values_sql_file.read()
+
+            cu.executescript(schema_sql)
+            cu.executescript(values_sql)
         except sqlite3.Error as e:
             Logger.error(f"Unknown error during database setting.")
             raise e