How do I use localised country names?

coderholic / django-cities

Countries and cities of the world for Django projects

MIT License

913 stars 377 forks source link

How do I use localised country names? #201

Closed TurnrDev closed 3 years ago

TurnrDev commented 5 years ago

Checklist

[x] I have verified that I am using a GIS-enabled database, such as PostGIS or Spatialite.
[x] I have verified that that issue exists against the master branch of django-cities.
[x] I have searched for similar issues in both open and closed tickets and cannot find a duplicate.
[x] I have reduced the issue to the simplest possible case.
[ ] I have included a failing test as a pull request. (If you are unable to do so we can still accept the issue.)

fffffrolov commented 5 years ago

My version:

Using custom model (myapp.City)
Add field name_local

create migration/command:

cities = City.objects.filter(name_local__isnull=True)
for instance in cities:
lang = instance.country.language_codes.split(',')[0]
if lang:
    alt_name = instance.alt_names.filter(language_code=lang).order_by('-is_preferred').first()
    name_local = alt_name.name if alt_name else instance.name
    City.objects.filter(pk=instance.pk).update(name_local=name_local)

Same for Country