From: Sarah Hoffmann <lonvia@denofr.de>
Date: Fri, 4 Nov 2022 14:20:43 +0000 (+0100)
Subject: add migration for place_to_be_deleted table
X-Git-Tag: v4.2.0~13^2~11
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/74405e96849da87173106989f786e056818cbb92

add migration for place_to_be_deleted table
---

diff --git a/nominatim/tools/migration.py b/nominatim/tools/migration.py
index 7854154c..d5806097 100644
--- a/nominatim/tools/migration.py
+++ b/nominatim/tools/migration.py
@@ -315,3 +315,20 @@ def mark_internal_country_names(conn: Connection, config: Configuration, **_: An
                     names = {}
                 names['countrycode'] = country_code
                 analyzer.add_country_names(country_code, names)
+
+
+@_migration(4, 1, 99, 0)
+def add_place_deletion_todo_table(conn: Connection, **_: Any) -> None:
+    """ Add helper table for deleting data on updates.
+
+        The table is only necessary when updates are possible, i.e.
+        the database is not in freeze mode.
+    """
+    if conn.table_exists('place'):
+        with conn.cursor() as cur:
+            cur.execute("""CREATE TABLE IF NOT EXISTS place_to_be_deleted (
+                             osm_type CHAR(1),
+                             osm_id BIGINT,
+                             class TEXT,
+                             type TEXT,
+                             deferred BOOLEAN)""")
diff --git a/nominatim/version.py b/nominatim/version.py
index e7e750b0..36573040 100644
--- a/nominatim/version.py
+++ b/nominatim/version.py
@@ -25,7 +25,7 @@ from typing import Optional, Tuple
 # patch level when cherry-picking the commit with the migration.
 #
 # Released versions always have a database patch level of 0.
-NOMINATIM_VERSION = (4, 1, 0, 0)
+NOMINATIM_VERSION = (4, 1, 99, 0)
 
 POSTGRESQL_REQUIRED_VERSION = (9, 6)
 POSTGIS_REQUIRED_VERSION = (2, 2)