replace CASE construct with plpgsql function

[nominatim.git] / test / python / api / test_results.py

diff --git a/test/python/api/test_results.py b/test/python/api/test_results.py
index 7ea1fb1fe1d52a64bebe214f23b2c75dfbf29ffd..232740b417fa759fa6624c83fc22f564f9cb4c6f 100644 (file)
--- a/test/python/api/test_results.py
+++ b/test/python/api/test_results.py
@@ -8,6 +8,7 @@
 Tests for result datatype helper functions.
 """
 import struct
 Tests for result datatype helper functions.
 """
 import struct

+from binascii import hexlify

 
 import pytest
 import pytest_asyncio
 
 import pytest
 import pytest_asyncio


@@ -17,10 +18,8 @@ import sqlalchemy as sa
 from nominatim.api import SourceTable, DetailedResult, Point
 import nominatim.api.results as nresults
 
 from nominatim.api import SourceTable, DetailedResult, Point
 import nominatim.api.results as nresults
 

-class FakeCentroid:
-    def __init__(self, x, y):
-        self.data = struct.pack("=biidd", 1, 0x20000001, 4326,
-                                        x, y)
+def mkpoint(x, y):
+    return hexlify(struct.pack("=biidd", 1, 0x20000001, 4326, x, y)).decode('utf-8')

 
 class FakeRow:
     def __init__(self, **kwargs):
 
 class FakeRow:
     def __init__(self, **kwargs):


@@ -58,9 +57,9 @@ def test_create_row_none(func):
 @pytest.mark.parametrize('func', (nresults.create_from_osmline_row,
                                   nresults.create_from_tiger_row))
 def test_create_row_with_housenumber(func):
 @pytest.mark.parametrize('func', (nresults.create_from_osmline_row,
                                   nresults.create_from_tiger_row))
 def test_create_row_with_housenumber(func):

-    row = FakeRow(place_id = 2345, osm_id = 111, housenumber = 4,
-                  address = None, postcode = '99900', country_code = 'xd',
-                  centroid = FakeCentroid(0, 0))
+    row = FakeRow(place_id=2345, osm_type='W', osm_id=111, housenumber=4,
+                  address=None, postcode='99900', country_code='xd',
+                  centroid=mkpoint(0, 0))

 
     res = func(row, DetailedResult)
 
 
     res = func(row, DetailedResult)
 


@@ -72,10 +71,10 @@ def test_create_row_with_housenumber(func):
 @pytest.mark.parametrize('func', (nresults.create_from_osmline_row,
                                   nresults.create_from_tiger_row))
 def test_create_row_without_housenumber(func):
 @pytest.mark.parametrize('func', (nresults.create_from_osmline_row,
                                   nresults.create_from_tiger_row))
 def test_create_row_without_housenumber(func):

-    row = FakeRow(place_id=2345, osm_id=111,
+    row = FakeRow(place_id=2345, osm_type='W', osm_id=111,

                   startnumber=1, endnumber=11, step=2,
                   address=None, postcode='99900', country_code='xd',
                   startnumber=1, endnumber=11, step=2,
                   address=None, postcode='99900', country_code='xd',

-                  centroid=FakeCentroid(0, 0))
+                  centroid=mkpoint(0, 0))

 
     res = func(row, DetailedResult)
 
 
     res = func(row, DetailedResult)