Make languages.yml translatable

[avarab@…]

Currently the languages table (read from config/languages.yml) only has entries for language code, english name and native name.

--------------+------------------------+-----------
 code         | character varying(255) | not null
 english_name | character varying(255) | not null
 native_name  | character varying(255) | 

It should be possible to translate this table into arbitrary native languages, so that when reading the diaries one sees "{{language_name}} ({{native_name}})" instead of "{{english_name}} ({{native_name}})". Where language_name is the name of the language in the locale the current user is using.

This would require changing languges.yml like so:

 de:                                                                                                                                                         
-  english: German                                                                                                                                           
-  native: Deutsch                                                                                                                                           
+  en: German                                                                                                                                                
+  de: Deutsch                                                                                                                                               
+  is: Þýska

And changing the languages table to something like:

--------------+------------------------+-----------
 code         | character varying(255) | not null
 code_to      | character varying(255) | not null
 name         | character varying(255) |

[StefanB]

How about using ready-made data in a RoR plugn, such as:
​http://github.com/grosser/i18n_data/tree/master ?

There are several other, similar plugins.

[stefanb]

(In [15900]) Added localized language names with plugin from ​http://github.com/grosser/i18n_data/tree/master (fixes #1946)
Diary entries in same language linked (lists and rss)

[tom@…]

Thank you for making the trunk undeployable - please do not make major changes like adding new plugins without consulting first.

For the record the situation with languages.yml was a result of a deliberate decision made at the hack day. In hindsight that decision needs reviewing I agree but it needs more thought than has gone on here to decide on the best solution so please leave this open until I am back from holiday.

[tom@…]

I have backed out r15900 for now.

[StefanB]

I thought announcing it here and seeing no objections meant that the plugin was acceptable.

Just of curiosity, why was it undeployable? Was it technically broken in some way, or just socially not agreed enough upon? Don't want to make the same mistake again.

Can I redo other changes that are not requiring the plugin?

No rush though, enjoy your holidays!

[smsm1]

As the admin of the server is on holiday he hasn't had time to check the plugin to see if it is suitable, and doesn't have any bad side effects or if there are better alternatives.

Less than 24 hours is rarely enough time during a normal working week to review a big change in the code, never mind when the main sys admin is on holiday.

At the moment we are only accepting small bug fixes into trunk. Generally major changes are done in a branch so that trunk is always deployable. Even if the branch only lasts a few days or weeks, it still means that trunk can always be deployed if there are any urgent bugs that need to be fixed, or there are other code changes that can be deployed straight away.

[stefanb]

(In [15916]) minor change: diary entries per language linked (lists and rss feeds)
(again, since r15900 was rolled back in r15905, see #1946 - this time without adding a plugin)

[StefanB]

adding i18n_data plugin with example use for consideration

[StefanB]

smsm1, thanks for clarification!

I've split the reverted r15900 into a trivial part (checked in as r15916) and the non trivial part (attached patch i18n_data-plugin.patch.gz) to be considered as one of the options when resolving this issue later on.