add migration for upcoming change to tiger tables

diff --git a/nominatim/tools/migration.py b/nominatim/tools/migration.py
index c24b09cbf1303949c935eceb40f70be147da77c1..dc6dfecabd811f1bad1faa4eb923323565611e8b 100644 (file)
--- a/nominatim/tools/migration.py
+++ b/nominatim/tools/migration.py
@@ -231,7 +231,7 @@ def create_interpolation_index_on_place(conn, **_):
 
 @_migration(4, 0, 99, 2)
 def add_step_column_for_interpolation(conn, **_):
-    """ Add a new column 'step' to the interpolations table which will.
+    """ Add a new column 'step' to the interpolations table.
 
         Also convers the data into the stricter format which requires that
         startnumbers comply with the odd/even requirements.
@@ -259,3 +259,15 @@ def add_step_column_for_interpolation(conn, **_):
                          SET step = CASE WHEN interpolationtype = 'all'
                                          THEN 1 ELSE 2 END
                     """)
+
+
+@_migration(4, 0, 99, 3)
+def add_step_column_for_tiger(conn, **_):
+    """ Add a new column 'step' to the tiger data table.
+    """
+    with conn.cursor() as cur:
+        cur.execute("ALTER TABLE location_property_tiger ADD COLUMN step SMALLINT")
+        cur.execute("""UPDATE location_property_tiger
+                         SET step = CASE WHEN interpolationtype = 'all'
+                                         THEN 1 ELSE 2 END
+                    """)

diff --git a/nominatim/version.py b/nominatim/version.py
index 88bb881f491a491f8e34030666b9cd6c5059481c..289af9346ef3c7957ca6c7873c54172759c090bb 100644 (file)
--- a/nominatim/version.py
+++ b/nominatim/version.py
@@ -24,7 +24,7 @@ Version information for Nominatim.
 # patch level when cherry-picking the commit with the migration.
 #
 # Released versions always have a database patch level of 0.
-NOMINATIM_VERSION = (4, 0, 99, 3)
+NOMINATIM_VERSION = (4, 0, 99, 4)
 
 POSTGRESQL_REQUIRED_VERSION = (9, 5)
 POSTGIS_REQUIRED_VERSION = (2, 2)