X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/78fcabade88c885f2506911201e52de912204b56..6eb1113dcb569f07367a801e6ac2dcb9565ec7b8:/nominatim/tools/country_info.py diff --git a/nominatim/tools/country_info.py b/nominatim/tools/country_info.py index 1b61ae68..f6a6293f 100644 --- a/nominatim/tools/country_info.py +++ b/nominatim/tools/country_info.py @@ -1,3 +1,9 @@ +# SPDX-License-Identifier: GPL-2.0-only +# +# This file is part of Nominatim. (https://nominatim.org) +# +# Copyright (C) 2022 by the Nominatim developer community. +# For a full list of authors see the git log. """ Functions for importing and managing static country information. """ @@ -6,18 +12,97 @@ import psycopg2.extras from nominatim.db import utils as db_utils from nominatim.db.connection import connect + +class _CountryInfo: + """ Caches country-specific properties from the configuration file. + """ + + def __init__(self): + self._info = {} + self._key_prefix = 'name' + + def load(self, config): + """ Load the country properties from the configuration files, + if they are not loaded yet. + """ + if not self._info: + self._info = config.load_sub_configuration('country_settings.yaml') + # Convert languages into a list for simpler handling. + for prop in self._info.values(): + if 'languages' not in prop: + prop['languages'] = [] + elif not isinstance(prop['languages'], list): + prop['languages'] = [x.strip() + for x in prop['languages'].split(',')] + if 'names' not in prop or prop['names'] is None: + prop['names'] = {self._key_prefix: {}} + + def items(self): + """ Return tuples of (country_code, property dict) as iterable. + """ + return self._info.items() + + def key_prefix(self): + """ Return the prefix that will be attached to the keys of the country + names values when storing them in the database + """ + return self._key_prefix + + +_COUNTRY_INFO = _CountryInfo() + + +def setup_country_config(config): + """ Load country properties from the configuration file. + Needs to be called before using any other functions in this + file. + """ + _COUNTRY_INFO.load(config) + + +def iterate(): + """ Iterate over country code and properties. + """ + return _COUNTRY_INFO.items() + + def setup_country_tables(dsn, sql_dir, ignore_partitions=False): """ Create and populate the tables with basic static data that provides the background for geocoding. Data is assumed to not yet exist. """ - db_utils.execute_file(dsn, sql_dir / 'country_name.sql') db_utils.execute_file(dsn, sql_dir / 'country_osm_grid.sql.gz') - if ignore_partitions: - with connect(dsn) as conn: - with conn.cursor() as cur: - cur.execute('UPDATE country_name SET partition = 0') - conn.commit() + def add_prefix_to_keys(names, prefix): + return {prefix+':'+k: v for k, v in names.items()} + + params = [] + for ccode, props in _COUNTRY_INFO.items(): + if ccode is not None and props is not None: + if ignore_partitions: + partition = 0 + else: + partition = props.get('partition') + lang = props['languages'][0] if len( + props['languages']) == 1 else None + name = add_prefix_to_keys(props.get('names').get( + _COUNTRY_INFO.key_prefix()), _COUNTRY_INFO.key_prefix()) + params.append((ccode, name, lang, partition)) + with connect(dsn) as conn: + with conn.cursor() as cur: + psycopg2.extras.register_hstore(cur) + cur.execute( + """ CREATE TABLE public.country_name ( + country_code character varying(2), + name public.hstore, + derived_name public.hstore, + country_default_language_code text, + partition integer + ); """) + cur.execute_values( + """ INSERT INTO public.country_name + (country_code, name, country_default_language_code, partition) VALUES %s + """, params) + conn.commit() def create_country_names(conn, tokenizer, languages=None): @@ -30,8 +115,9 @@ def create_country_names(conn, tokenizer, languages=None): languages = languages.split(',') def _include_key(key): - return key == 'name' or \ - (key.startswith('name:') and (not languages or key[5:] in languages)) + return key == _COUNTRY_INFO.key_prefix() or \ + (key.startswith(_COUNTRY_INFO.key_prefix()+':') and + (not languages or key[len(_COUNTRY_INFO.key_prefix())+1:] in languages)) with conn.cursor() as cur: psycopg2.extras.register_hstore(cur) @@ -48,7 +134,8 @@ def create_country_names(conn, tokenizer, languages=None): # country names (only in languages as provided) if name: - names.update(((k, v) for k, v in name.items() if _include_key(k))) + names.update(((k, v) + for k, v in name.items() if _include_key(k))) analyzer.add_country_names(code, names)