class RoleTranslation(translation_base(Role)):
""" Translation table for Role """
__tablename__ = 'role_translation'
# Fields
label = Column(Unicode(100))
description = Column(Unicode(100))
def create_models(self):
class Article(self.Model, Translatable):
__tablename__ = 'article'
__translatable__ = {
'locales': ['fi', 'en'],
'auto_create_locales': True,
'translations_relationship_args': {
'collection_class': list,
}
}
id = sa.Column(sa.Integer, primary_key=True)
locale = 'en'
TranslationBase = translation_base(
Article,
foreign_key_args={'onupdate': 'SET NULL'}
)
class ArticleTranslation(TranslationBase):
__tablename__ = 'article_translation'
name = sa.Column(sa.Unicode(255))
self.Article = Article
self.ArticleTranslation = ArticleTranslation
class TextItemTranslation(translation_base(TextItem)):
__tablename__ = 'text_item_translation'
name = sa.Column(sa.Unicode(255))
content = sa.Column(sa.UnicodeText)
caption = sa.Column(sa.UnicodeText)
class PlatformTranslation(translation_base(Platform)):
""" Translation table for Platform """
__tablename__ = 'platform_translation'
# Fields
name = Column(Unicode(200))
description = Column(Unicode(200))
def create_models(self):
class Article(self.Model, Translatable):
__tablename__ = 'article'
__translatable__ = {
'locales': ['fi', 'en'],
'auto_create_locales': True,
'translations_relationship_args': {
'collection_class': list,
}
}
id = sa.Column(sa.Integer, primary_key=True)
locale = 'en'
TranslationBase = translation_base(
Article, foreign_key_args={'onupdate': 'SET NULL'})
class ArticleTranslation(TranslationBase):
__tablename__ = 'article_translation'
name = sa.Column(sa.Unicode(255))
self.Article = Article
self.ArticleTranslation = ArticleTranslation
class ConfigurationTranslation(translation_base(Configuration)):
""" Translation table for Configuration """
__tablename__ = 'configuration_translation'
# Fields
description = Column(Unicode(100))
category = Column(Unicode(100))
class OperationPortInterfaceTranslation(
translation_base(OperationPortInterface)):
""" Translation table for OperationPortInterface """
__tablename__ = 'operation_port_interface_translation'
# Fields
name = Column(Unicode(200))
class OperationPortTranslation(translation_base(OperationPort)):
""" Translation table for OperationPort """
__tablename__ = 'operation_port_translation'
# Fields
name = Column(Unicode(200))
description = Column(Unicode(200))
class OperationFormFieldTranslation(translation_base(OperationFormField)):
""" Translation table for OperationFormField """
__tablename__ = 'operation_form_field_translation'
# Fields
label = Column(Unicode(200))
help = Column(UnicodeText())
class ArticleTranslation(translation_base(Article)):
__tablename__ = 'article_translation'
name = sa.Column(sa.Unicode(255), nullable=False)
content = sa.Column(sa.UnicodeText)
content2 = sa.Column(sa.UnicodeText)
class ActivityTranslation(translation_base(Activity)):
__tablename__ = 'activities_translation'
title = Column(UnicodeCoercingText)
label = Column(UnicodeCoercingText)
summary = Column(UnicodeCoercingText)
description = Column(UnicodeCoercingText)
class ProjectTranslation(translation_base(Project)):
__tablename__ = 'project_translation'
name = Column(Unicode(255), default=u'')
description = Column(Unicode, default=u'')
short_description = Column(Unicode, default=u'')
instructions = Column(Unicode, default=u'')
per_task_instructions = Column(Unicode, default=u'')
class KBArticleLocale(translation_base(KBArticle)):
__tablename__ = 'kb_article_i18n'
translator_id = db.Column(db.Integer, db.ForeignKey('account.uuid'))
title = db.Column(db.Unicode(120), nullable=False)
href = db.Column(db.String(120), nullable=False)
description = db.Column(db.Unicode(512), nullable=False)
teaser = db.Column(db.UnicodeText, nullable=False)
content = db.Column(db.UnicodeText, nullable=False)
class TreeNodeTranslation(translation_base(TreeNode)):
__tablename__ = 'tree_translation'
text = sqla.Column(sqla.UnicodeText())
tooltip = sqla.Column(sqla.UnicodeText())
@property
def serialize(self):
"""Return object data in easily serializeable format"""
# return json.dumps(self, default=lambda o: o.__dict__,
# sort_keys=True, indent=4)
return {
'id': self.id,
'text': self.text,
'tooltip': self.tooltip,
}
class PageTranslation(translation_base(Pages)):
__tablename__ = 'pages_translation'
title = sqla.Column(sqla.Unicode(256))
text = sqla.Column(sqla.UnicodeText())
class OperationFormTranslation(translation_base(OperationForm)):
""" Translation table for OperationForm """
__tablename__ = 'operation_form_translation'
# Fields
name = Column(Unicode(200))
class ArticleTranslation(translation_base(Article)):
__tablename__ = 'article_translation'
__versioned__ = {'base_classes': (self.Model, )}
name = sa.Column('name', sa.Unicode(255))
content = sa.Column('content', sa.UnicodeText)
class PermissionTranslation(translation_base(Permission)):
""" Translation table for Permission """
__tablename__ = 'permission_translation'
# Fields
description = Column(Unicode(100))
class ModelTranslation(translation_base(ModelTest)):
__tablename__ = 'model_translation'
name = sa.Column(sa.Unicode(255))
content = sa.Column(sa.Unicode(255))
class OperationCategoryTranslation(translation_base(OperationCategory)):
""" Translation table for OperationCategory """
__tablename__ = 'operation_category_translation'
# Fields
name = Column(Unicode(200))
class MenuItemsNodeTranslation(translation_base(MenuItemsNode)):
__tablename__ = 'menu_items_translation'
text = sqla.Column(sqla.UnicodeText())
class ArticleTranslation(
translation_base(Article,
base_class_factory=lambda cls: Base)):
__tablename__ = 'article_translation'
name = sa.Column(sa.Unicode(255))
class LabelTranslation(translation_base(Label)):
__tablename__ = 'label_translation'
description = Column(Unicode, default=u'')
class CategoryTranslation(translation_base(Category)):
__tablename__ = 'article_translation'
name = sa.Column(sa.Unicode(255))
class ArticleTranslation(translation_base(Article)):
__tablename__ = 'article_translation'
name = sa.Column(sa.Unicode(255))
class AlgorithmTranslation(translation_base(Algorithm)):
__tablename__ = 'algorithm_translation'
name = Column(Unicode(255))
description = Column(UnicodeText)
