From: Sarah Hoffmann <lonvia@denofr.de>
Date: Thu, 7 Dec 2023 09:24:53 +0000 (+0100)
Subject: error out when a SQLite database does not exist
X-Git-Tag: v4.4.0~37^2~1
X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/89094cf92e82ebb1004498fad8822975f1af4347?hp=3f5484f48fb3ab132f877d1d5a3e42cdaf274f07

error out when a SQLite database does not exist

Requires to mark the databse r/w when it is newly created in the
convert function.
---

diff --git a/nominatim/api/core.py b/nominatim/api/core.py
index f975f44a..1c0c4423 100644
--- a/nominatim/api/core.py
+++ b/nominatim/api/core.py
@@ -101,6 +101,10 @@ class NominatimAPIAsync: #pylint: disable=too-many-instance-attributes
                 dburl = sa.engine.URL.create('sqlite+aiosqlite',
                                              database=params.get('dbname'))
 
+                if not ('NOMINATIM_DATABASE_RW' in self.config.environ
+                        and self.config.get_bool('DATABASE_RW')) \
+                   and not Path(params.get('dbname', '')).is_file():
+                    raise UsageError(f"SQlite database '{params.get('dbname')}' does not exist.")
             else:
                 dsn = self.config.get_database_params()
                 query = {k: v for k, v in dsn.items()
diff --git a/nominatim/tools/convert_sqlite.py b/nominatim/tools/convert_sqlite.py
index 16139c5f..3e584710 100644
--- a/nominatim/tools/convert_sqlite.py
+++ b/nominatim/tools/convert_sqlite.py
@@ -28,7 +28,8 @@ async def convert(project_dir: Path, outfile: Path, options: Set[str]) -> None:
 
     try:
         outapi = napi.NominatimAPIAsync(project_dir,
-                                        {'NOMINATIM_DATABASE_DSN': f"sqlite:dbname={outfile}"})
+                                        {'NOMINATIM_DATABASE_DSN': f"sqlite:dbname={outfile}",
+                                         'NOMINATIM_DATABASE_RW': '1'})
 
         try:
             async with api.begin() as src, outapi.begin() as dest: