[arch-dev-public] Mirror country names (was: Mirror status page)
roman.kyrylych at gmail.com
Fri Oct 8 09:20:11 EDT 2010
On Thu, Oct 7, 2010 at 23:35, Dan McGee <dpmcgee at gmail.com> wrote:
> On Wed, Oct 6, 2010 at 4:05 AM, Roman Kyrylych <roman.kyrylych at gmail.com> wrote:
>> 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.
> No, *new* ones would have to be entered correctly after we fix the
> *existing* ones.
Looks like we were talking about the same thing. :)
> We can make it a select box if you want
Nah, no need for that, I can just enter them properly.
Roman Kyrylych (Роман Кирилич)
More information about the arch-dev-public