def update_translation_changelist_for_undelete():
"""Create all the required translations if not defined"""
from application import db
from models.translation import Translation
itemDict = {
'changes_v2.1.0.2': {
'en': """<ul>
<li>Added the un-delete feature</li>
</ul>""",
'ru': """<ul>
<li>Добавлена возможность отмены удаления</li>
</ul>""",
'uk': """<ul>
<li>Додано можливість скасувати видалення</li>
</ul>""",
}
}
for name, itemDictValue in itemDict.items():
for language, value in itemDictValue.items():
translation = Translation.query.filter_by(name=name, language=language).first()
if not translation:
translation = Translation()
translation.language = language
translation.name = name
translation.value = value
translation.save()
else:
translation.value = value
translation.save()
def update_translation_data_add_about_page_translations():
"""Create all the required translations if not defined"""
from application import db
from models.translation import Translation
itemDict = {
'about service': {
'en': 'About T<sup>3</sup>',
'ru': 'О сервисе T<sup>3</sup>',
'uk': 'Про сервіс T<sup>3</sup>'
},
'and others': {
'en': 'and many others',
'ru': 'и многим другим',
'uk': 'та багатьом іншим'
},
'changes_v2.1.0.1': {
'en': """<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li>Added the "About" page</li>
</ul>""",
'ru': '',
'uk': ''
},
'common:changes': {
'en': 'Changes',
'ru': 'Изменения',
'uk': 'Що нового'
},
'common:version_short': {
'en': 'ver',
'ru': 'ver',
'uk': 'ver'
},
'thanks to': {
'en': 'Thanks to',
'ru': 'Отдельная благодарность',
'uk': 'Дуже дякую'
}
}
for name, itemDictValue in itemDict.items():
for language, value in itemDictValue.items():
translation = Translation.query.filter_by(name=name, language=language).first()
if not translation:
translation = Translation()
translation.language = language
translation.name = name
translation.value = value
translation.save()
else:
translation.value = value
translation.save()
def update_floats_separator():
"""Create all the required translations if not defined"""
from application import db
from models.translation import Translation
itemDict = {
'changes_v2.1.0.3': {
'en': """<ul>
<li>Added a preference: decimal separator for the floating-point numbers</li>
</ul>""",
'ru': """<ul>
<li>Добавлена настройка: разделитель для дробной части в числах с плавающей точкой</li>
</ul>""",
'uk': """<ul>
<li>Додано налаштування: роздільник для дробової частини в числах з плаваючою точкою</li>
</ul>""",
},
'floats format': {
'en': 'Decimal Separator',
'ru': 'Разделитель в дробях',
'uk': 'Роздільник в дробових числах'
},
'comma': {
'en': 'Comma',
'ru': 'Запятая',
'uk': 'Кома'
},
'dot': {
'en': 'Dot',
'ru': 'Точка',
'uk': 'Крапка'
}
}
for name, itemDictValue in itemDict.items():
for language, value in itemDictValue.items():
translation = Translation.query.filter_by(name=name, language=language).first()
if not translation:
translation = Translation()
translation.language = language
translation.name = name
translation.value = value
translation.save()
else:
translation.value = value
translation.save()
def install_translation_data():
"""Create all the required translations if not defined"""
from application import db
from models.translation import Translation
import csv
csvFile = open('data/t3.csv', 'rb')
csvData = csv.reader(csvFile, delimiter=',', quotechar='"')
csvHeaderSkipped = False
for item in csvData:
if not csvHeaderSkipped:
csvHeaderSkipped = True
continue
if not len(item):
continue
name = item[0]
valueDict = {
'en': (len(item)>1 and str(item[1]) or ''),
'ru': (len(item)>2 and str(item[2]) or ''),
'uk': (len(item)>3 and str(item[3]) or '')
}
for language, value in valueDict.items():
translation = Translation.query.filter_by(language=language, name=name).first()
if not translation:
translation = Translation()
translation.language = language
translation.name = name
translation.value = value
translation.save()
else:
translation.value = value
translation.save()
print '[MIGRATION:TRANSLATION]', name, language, translation
