def test_normalize_housenumber_streets(session, tables):
session.add(tables.osm_housenumber(id=1, street="Bietinger Weg"))
session.commit()
normalize_street_names()
assert str(session.query(tables.osm_housenumber).get(1).normalized_street) == "bietingerweg"
def test_remove_quotes(session, tables):
session.add(tables.osm_linestring(id=1, name="Grand'Rue"))
session.commit()
normalize_street_names()
assert str(session.query(tables.osm_linestring).get(1).normalized_name) == "grandrue"
def test_remove_accents(session, tables):
session.add(tables.osm_linestring(id=1, name="Cité Préville"))
session.commit()
normalize_street_names()
assert str(session.query(tables.osm_linestring).get(1).normalized_name) == "citepreville"
def test_remove_dashes(session, tables):
session.add(tables.osm_linestring(id=1, name="Chemin du Pra-de-Villars"))
session.commit()
normalize_street_names()
assert str(session.query(tables.osm_linestring).get(1).normalized_name) == "chemindupradevillars"
def test_normalize_linestring_names(session, tables):
session.add(tables.osm_linestring(id=1, name="Bietinger Weg"))
session.commit()
normalize_street_names()
assert str(session.query(tables.osm_linestring).get(1).normalized_name) == "bietingerweg"
def test_remove_quotes(session, schema, tables):
session.add(tables.osm_linestring(id=1, name="Grand'Rue"))
session.commit()
normalize_street_names()
assert str(session.query(
tables.osm_linestring).get(1).normalized_name) == "grandrue"
def test_remove_accents(session, schema, tables):
session.add(tables.osm_linestring(id=1, name="Cité Préville"))
session.commit()
normalize_street_names()
assert str(session.query(
tables.osm_linestring).get(1).normalized_name) == "citepreville"
def test_remove_dashes(session, schema, tables):
session.add(tables.osm_linestring(id=1, name="Chemin du Pra-de-Villars"))
session.commit()
normalize_street_names()
assert str(session.query(tables.osm_linestring).get(
1).normalized_name) == "chemindupradevillars"
def test_normalize_linestring_names(session, schema, tables):
session.add(tables.osm_linestring(id=1, name="Bietinger Weg"))
session.commit()
normalize_street_names()
assert str(session.query(
tables.osm_linestring).get(1).normalized_name) == "bietingerweg"
def test_normalize_housenumber_streets(session, schema, tables):
session.add(tables.osm_housenumber(id=1, street="Bietinger Weg"))
session.commit()
normalize_street_names()
assert str(session.query(
tables.osm_housenumber).get(1).normalized_street) == "bietingerweg"
def test_remove_dots_and_brackets(session, tables):
session.add(tables.osm_linestring(id=1, name="Grand.Rue(FR)"))
session.commit()
normalize_street_names()
assert str(session.query(
tables.osm_linestring).get(1).normalized_name) == "grandruefr"