elif not isinstance(prop['languages'], list):
prop['languages'] = [x.strip()
for x in prop['languages'].split(',')]
- if 'name' not in prop:
- prop['name'] = {}
+ if 'names' not in prop:
+ prop['names']['name'] = {}
def items(self):
""" Return tuples of (country_code, property dict) as iterable.
"""
db_utils.execute_file(dsn, sql_dir / 'country_osm_grid.sql.gz')
+ def add_prefix_to_keys(name, prefix):
+ return {prefix+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:
lang = props['languages'][0] if len(props['languages']) == 1 else None
params.append((ccode, partition, lang))
- name = json.dumps(props.get('name'), ensure_ascii=False, separators=(', ', '=>'))
+ name = add_prefix_to_keys(props.get('names').get('name'), '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 (
+ """ 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(
languages = languages.split(',')
def _include_key(key):
- return key == 'name' or \
- (key.startswith('name:') and (not languages or key[5:] in languages))
+ return key.startswith('name:') and \
+ key[5:] in languages or key[5:] == 'default'
with conn.cursor() as cur:
psycopg2.extras.register_hstore(cur)