From 98432395c31f0ae46962907e2c19c4eebc12c8bb Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Thu, 27 Jan 2022 11:41:16 +0100 Subject: [PATCH] add migration for upcoming change to tiger tables --- nominatim/tools/migration.py | 14 +++++++++++++- nominatim/version.py | 2 +- 2 files changed, 14 insertions(+), 2 deletions(-) diff --git a/nominatim/tools/migration.py b/nominatim/tools/migration.py index c24b09cb..dc6dfeca 100644 --- 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 88bb881f..289af934 100644 --- 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) -- 2.39.5