1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
|
# Copyright 2009 Canonical Ltd. This software is licensed under the
# GNU Affero General Public License version 3 (see the file LICENSE).
# pylint: disable-msg=E0611,W0212
__metaclass__ = type
__all__ = ['Translator', 'TranslatorSet']
from sqlobject import (
ForeignKey,
StringCol,
)
from storm.expr import Join
from storm.store import Store
from zope.interface import implements
from canonical.database.constants import DEFAULT
from canonical.database.datetimecol import UtcDateTimeCol
from canonical.database.sqlbase import SQLBase
from lp.registry.interfaces.person import validate_public_person
from lp.registry.model.teammembership import TeamParticipation
from lp.translations.interfaces.translator import (
ITranslator,
ITranslatorSet,
)
class Translator(SQLBase):
"""A Translator in a TranslationGroup."""
implements(ITranslator)
# default to listing newest first
_defaultOrder = '-id'
# db field names
translationgroup = ForeignKey(dbName='translationgroup',
foreignKey='TranslationGroup', notNull=True)
language = ForeignKey(dbName='language',
foreignKey='Language', notNull=True)
translator = ForeignKey(
dbName='translator', foreignKey='Person',
storm_validator=validate_public_person, notNull=True)
datecreated = UtcDateTimeCol(notNull=True, default=DEFAULT)
style_guide_url = StringCol(notNull=False, default=None)
class TranslatorSet:
implements(ITranslatorSet)
def new(self, translationgroup, language,
translator, style_guide_url=None):
return Translator(
translationgroup=translationgroup,
language=language,
translator=translator,
style_guide_url=style_guide_url)
def getByTranslator(self, translator):
"""See ITranslatorSet."""
store = Store.of(translator)
# TranslationGroup is referenced directly in SQL to avoid
# a cyclic import.
origin = [
Translator,
Join(TeamParticipation,
TeamParticipation.teamID == Translator.translatorID),
Join("TranslationGroup",
on="TranslationGroup.id = Translator.translationgroup")
]
result = store.using(*origin).find(
Translator, TeamParticipation.person == translator)
return result.order_by("TranslationGroup.title")
|