+ def prepend_name_to_keys(name):
+ return {'name:'+k: v for k, v in name.items()}
+
+ params, country_names_data = [], ''
+ 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
+ params.append((ccode, partition, lang))
+
+ name = prepend_name_to_keys(props.get('names').get('name'))
+ name = json.dumps(name , ensure_ascii=False, separators=(', ', '=>'))
+ country_names_data += ccode + '\t' + name[1:-1] + '\n'
+
+ with connect(dsn) as conn:
+ with conn.cursor() as 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
+ ); """)
+ data = StringIO(country_names_data)
+ cur.copy_from(data, 'country_name', columns=('country_code', 'name'))
+ cur.execute_values(
+ """ UPDATE country_name
+ SET partition = part, country_default_language_code = lang
+ FROM (VALUES %s) AS v (cc, part, lang)
+ WHERE country_code = v.cc""", params)
+ conn.commit()
+
+
+def create_country_names(conn, tokenizer, languages=None):
+ """ Add default country names to search index. `languages` is a comma-
+ separated list of language codes as used in OSM. If `languages` is not
+ empty then only name translations for the given languages are added
+ to the index.
+ """
+ if languages:
+ languages = languages.split(',')
+
+ def _include_key(key):
+ return key.startswith('name:') and \
+ key[5:] in languages or key[5:] == 'default'
+
+ with conn.cursor() as cur:
+ psycopg2.extras.register_hstore(cur)
+ cur.execute("""SELECT country_code, name FROM country_name
+ WHERE country_code is not null""")
+
+ with tokenizer.name_analyzer() as analyzer:
+ for code, name in cur:
+ names = {'countrycode': code}
+ if code == 'gb':
+ names['short_name'] = 'UK'
+ if code == 'us':
+ names['short_name'] = 'United States'
+
+ # country names (only in languages as provided)
+ if name:
+ names.update(((k, v) for k, v in name.items() if _include_key(k)))
+
+ analyzer.add_country_names(code, names)
+
+ conn.commit()