def transform():
log.info("Normalizing countries for registered interests...")
for row in list(reg_representative.distinct('contact_country')):
name, code = country_by_name(row.get('contact_country'))
if code is not None:
row['country_common'] = name
row['country_code'] = code
reg_representative.update(row, ['contact_country'])
def transform():
log.info("Normalizing countries for registered interests...")
for row in list(reg_representative.distinct('contact_country')):
name, code = country_by_name(row.get('contact_country'))
if code is not None:
row['country_common'] = name
row['country_code'] = code
reg_representative.update(row, ['contact_country'])
def transform():
log.info("Normalizing countries for expert groups...")
for row in list(exp_group_member.distinct('country')):
name, code = country_by_name(row.get('country'))
if code is not None:
row['country_common'] = name
row['country_code'] = code
exp_group_member.update(row, ['country'])
def transform():
log.info("Normalizing countries for FTS recipients...")
for row in list(fts_entry.distinct('country')):
name, code = country_by_name(row.get('country'))
if code is not None:
row['country_common'] = name
row['country_code'] = code
fts_entry.update(row, ['country'])
def transform():
log.info("Normalizing countries for expert groups...")
for row in list(exp_group_member.distinct('country')):
name, code = country_by_name(row.get('country'))
if code is not None:
row['country_common'] = name
row['country_code'] = code
exp_group_member.update(row, ['country'])
def transform_prefix(prefix):
log.info("Normalizing countries for %s...", prefix)
field = prefix + '_country'
for row in list(contracts_table.distinct(field)):
name, code = country_by_name(row.get(field))
if code is not None:
row[prefix + '_country_common'] = name
row[prefix + '_country_code'] = code
contracts_table.update(row, [field])
def transform():
#transform_prefix('operator')
#transform_prefix('authority')
field = 'iso_country'
for row in list(documents_table.distinct(field)):
name, code = country_by_name(row.get(field))
if code is not None:
row['country_common'] = name
#row['country_code'] = code
documents_table.update(row, [field])
