From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sun, 22 Jan 2023 20:30:43 +0000 (+0100)
Subject: fix importance recalculation
X-Git-Tag: v4.3.0~111^2
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/ce9ed993c8c83dff7a86e8bd87cf562364f26a94?hp=-c

fix importance recalculation

The signature of the compute_importance() function has changed.
---

ce9ed993c8c83dff7a86e8bd87cf562364f26a94
diff --git a/nominatim/tools/refresh.py b/nominatim/tools/refresh.py
index 45796014..5dd98c0e 100644
--- a/nominatim/tools/refresh.py
+++ b/nominatim/tools/refresh.py
@@ -176,7 +176,7 @@ def recompute_importance(conn: Connection) -> None:
         cur.execute("""
             UPDATE placex SET (wikipedia, importance) =
                (SELECT wikipedia, importance
-                FROM compute_importance(extratags, country_code, osm_type, osm_id, centroid))
+                FROM compute_importance(extratags, country_code, rank_search, centroid))
             """)
         cur.execute("""
             UPDATE placex s SET wikipedia = d.wikipedia, importance = d.importance
diff --git a/test/python/tools/test_refresh.py b/test/python/tools/test_refresh.py
index c6be4fe7..3e0a2801 100644
--- a/test/python/tools/test_refresh.py
+++ b/test/python/tools/test_refresh.py
@@ -48,7 +48,7 @@ def test_refresh_import_wikipedia(dsn, src_dir, table_factory, temp_db_cursor, r
 def test_recompute_importance(placex_table, table_factory, temp_db_conn, temp_db_cursor):
     temp_db_cursor.execute("""CREATE OR REPLACE FUNCTION compute_importance(extratags HSTORE,
                                               country_code varchar(2),
-                                              osm_type varchar(1), osm_id BIGINT,
+                                              rank_search SMALLINT,
                                               centroid GEOMETRY,
                                               OUT importance FLOAT,
                                               OUT wikipedia TEXT)