[arch-dev-public] Mirror country names (was: Mirror status page)

[Roman Kyrylych]

On Fri, Oct 1, 2010 at 18:56, Dan McGee <dpmcgee at gmail.com> wrote:
> On Fri, Oct 1, 2010 at 10:53 AM, Roman Kyrylych
> <roman.kyrylych at gmail.com> wrote:
>> On Fri, Oct 1, 2010 at 18:02, Dan McGee <dpmcgee at gmail.com> wrote:
>>> If there is something in here that is wrong, let's just write some SQL
>>> to fix it up:
>>>
>>> UPDATE mirrors_mirror SET country = 'Best Country Ever!' WHERE country
>>> = 'Germany';
>>>
>>> If you can put together mappings like this to get the names adjusted
>>> to whatever that ISO standard # was, we'll be in business.
>>
>> I guess the most popular will be
>> UPDATE mirrors_mirror SET country = 'United Kindgom' WHERE country =
>> 'Great Britain';
>> but my question is:
>> since I don't see a dropdown list for selecting a country
>> but have to enter it manually each time I add a new mirror
>> will I have to rewrite the Country fileld for existing mirrors
>> after each country name change?
>
> Are you missing what this does? The SQL is to rewrite all existing
> mirrors using those country names, it has nothing to do with new ones.

That's exactly what my intention was.
I am missing your point.
Existing ones would just have to be entered correctly.
Or do you want to change the field in the admin GUI
from text input to selectbox?

-- 
Roman Kyrylych (Роман Кирилич)