[arch-dev-public] Mirror country names (was: Mirror status page)
On Fri, Oct 1, 2010 at 1:36 AM, Pierre Schmitz <pierre@archlinux.de> wrote:
On Thu, 30 Sep 2010 13:24:28 -0500, Dan McGee <dpmcgee@gmail.com> wrote:
Getting this tied to an actual country object could make GeoIP integration of some sort be useful later down the road.
That was my intention.
Haven't seen any progress on this. :)
Hmm, did you expect me to do something? I am quite busy atm; maybe I got some time at the week end.
I just expect other people to chip in when they have motivation to fix it, I can't do everything either. We can make this real easy: mysql> select distinct country from mirrors_mirror order by country; +----------------+ | country | +----------------+ | Any | | Australia | | Austria | | Belarus | | Belgium | | Brazil | | Bulgaria | | Canada | | Chile | | China | | Colombia | | Czech Republic | | Denmark | | Estonia | | Finland | | France | | Germany | | Great Britain | | Greece | | Hungary | | India | | Indonesia | | Ireland | | Israel | | Italy | | Japan | | Kazakhstan | | Latvia | | Lithuania | | Netherlands | | New Caledonia | | New Zealand | | Norway | | Poland | | Portugal | | Romania | | Russia | | Slovakia | | Spain | | Sweden | | Switzerland | | Taiwan | | Turkey | | Ukraine | | United States | | Vietnam | +----------------+ 46 rows in set (0.01 sec) 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. -Dan
On Fri, Oct 1, 2010 at 18:02, Dan McGee <dpmcgee@gmail.com> wrote:
On Fri, Oct 1, 2010 at 1:36 AM, Pierre Schmitz <pierre@archlinux.de> wrote:
On Thu, 30 Sep 2010 13:24:28 -0500, Dan McGee <dpmcgee@gmail.com> wrote:
Getting this tied to an actual country object could make GeoIP integration of some sort be useful later down the road.
That was my intention.
Haven't seen any progress on this. :)
Hmm, did you expect me to do something? I am quite busy atm; maybe I got some time at the week end.
I just expect other people to chip in when they have motivation to fix it, I can't do everything either.
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? -- Roman Kyrylych (Роман Кирилич)
On Fri, Oct 1, 2010 at 10:53 AM, Roman Kyrylych <roman.kyrylych@gmail.com> wrote:
On Fri, Oct 1, 2010 at 18:02, Dan McGee <dpmcgee@gmail.com> wrote:
On Fri, Oct 1, 2010 at 1:36 AM, Pierre Schmitz <pierre@archlinux.de> wrote:
On Thu, 30 Sep 2010 13:24:28 -0500, Dan McGee <dpmcgee@gmail.com> wrote:
Getting this tied to an actual country object could make GeoIP integration of some sort be useful later down the road.
That was my intention.
Haven't seen any progress on this. :)
Hmm, did you expect me to do something? I am quite busy atm; maybe I got some time at the week end.
I just expect other people to chip in when they have motivation to fix it, I can't do everything either.
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. -Dan
On Fri, Oct 1, 2010 at 18:56, Dan McGee <dpmcgee@gmail.com> wrote:
On Fri, Oct 1, 2010 at 10:53 AM, Roman Kyrylych <roman.kyrylych@gmail.com> wrote:
On Fri, Oct 1, 2010 at 18:02, Dan McGee <dpmcgee@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 (Роман Кирилич)
On Wed, Oct 6, 2010 at 4:05 AM, Roman Kyrylych <roman.kyrylych@gmail.com> wrote:
On Fri, Oct 1, 2010 at 18:56, Dan McGee <dpmcgee@gmail.com> wrote:
On Fri, Oct 1, 2010 at 10:53 AM, Roman Kyrylych <roman.kyrylych@gmail.com> wrote:
On Fri, Oct 1, 2010 at 18:02, Dan McGee <dpmcgee@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?
No, *new* ones would have to be entered correctly after we fix the *existing* ones. Not sure why this is suddenly causing so much friction, as I think only two of us ever enter this info and both have written emails in this thread. It should be fairly easy to stick to the right country names... We can make it a select box if you want, but that means having that list hardcoded somewhere in the code which seems a bit overkill given how few people touch this stuff anyway. -Dan
On Thu, Oct 7, 2010 at 23:35, Dan McGee <dpmcgee@gmail.com> wrote:
On Wed, Oct 6, 2010 at 4:05 AM, Roman Kyrylych <roman.kyrylych@gmail.com> wrote:
On Fri, Oct 1, 2010 at 18:56, Dan McGee <dpmcgee@gmail.com> wrote:
On Fri, Oct 1, 2010 at 10:53 AM, Roman Kyrylych <roman.kyrylych@gmail.com> wrote:
On Fri, Oct 1, 2010 at 18:02, Dan McGee <dpmcgee@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 (Роман Кирилич)
participants (2)
-
Dan McGee
-
Roman Kyrylych