Bases: onegov.core.orm.Base, onegov.core.orm.mixins.TimestampMixin, onegov.file.AssociatedFiles, onegov.core.orm.mixins.ContentMixin, onegov.gis.CoordinatesMixin, onegov.search.ORMSearchable
Mixin providing created/modified timestamps for all records.
The columns are deferred loaded as this is primarily for logging and future
forensics.
- 
__tablename__ = 'translators'[source]
- 
fts_public = False[source]
- Returns True if the model is available to be found by the public.
If false, only editors/admins will see this object in the search
results. 
- 
fts_properties[source]
- 
id: sqlalchemy.Column[uuid.UUID][source]
- 
state: sqlalchemy.Column[TranslatorState][source]
- 
first_name: sqlalchemy.Column[str][source]
- 
last_name: sqlalchemy.Column[str][source]
- 
pers_id: sqlalchemy.Column[int | None][source]
- 
admission: sqlalchemy.Column[AdmissionState][source]
- 
withholding_tax: sqlalchemy.Column[bool][source]
- 
self_employed: sqlalchemy.Column[bool][source]
- 
gender: sqlalchemy.Column[Gender | None][source]
- 
date_of_birth: sqlalchemy.Column[datetime.date | None][source]
- 
nationalities: onegov.core.orm.mixins.dict_property[list[str] | None][source]
- 
address: sqlalchemy.Column[str | None][source]
- 
zip_code: sqlalchemy.Column[str | None][source]
- 
city: sqlalchemy.Column[str | None][source]
- 
hometown: sqlalchemy.Column[str | None][source]
- 
drive_distance: sqlalchemy.Column[float | None][source]
- 
social_sec_number[source]
- 
bank_name: sqlalchemy.Column[str | None][source]
- 
bank_address: sqlalchemy.Column[str | None][source]
- 
account_owner: sqlalchemy.Column[str | None][source]
- 
iban: sqlalchemy.Column[str | None][source]
- 
email: sqlalchemy.Column[str | None][source]
- 
user: sqlalchemy.orm.relationship[onegov.user.User][source]
- 
tel_mobile: sqlalchemy.Column[str | None][source]
- 
tel_private: sqlalchemy.Column[str | None][source]
- 
tel_office: sqlalchemy.Column[str | None][source]
- 
availability: sqlalchemy.Column[str | None][source]
- 
confirm_name_reveal: sqlalchemy.Column[bool | None][source]
- 
date_of_application: sqlalchemy.Column[datetime.date | None][source]
- 
date_of_decision: sqlalchemy.Column[datetime.date | None][source]
- 
mother_tongues: sqlalchemy.orm.relationship[list[translator_directory.models.language.Language]][source]
- 
spoken_languages: sqlalchemy.orm.relationship[list[translator_directory.models.language.Language]][source]
- 
written_languages: sqlalchemy.orm.relationship[list[translator_directory.models.language.Language]][source]
- 
monitoring_languages: sqlalchemy.orm.relationship[list[translator_directory.models.language.Language]][source]
- 
proof_of_preconditions: sqlalchemy.Column[str | None][source]
- 
agency_references: sqlalchemy.Column[str | None][source]
- 
education_as_interpreter: sqlalchemy.Column[bool][source]
- 
certificates: sqlalchemy.orm.relationship[list[translator_directory.models.certificate.LanguageCertificate]][source]
- 
for_admins_only: sqlalchemy.Column[bool][source]
- 
profession: sqlalchemy.Column[str | None][source]
- 
occupation: sqlalchemy.Column[str | None][source]
- 
other_certificates: sqlalchemy.Column[str | None][source]
- 
expertise_interpreting_types: onegov.core.orm.mixins.dict_property[collections.abc.Sequence[InterpretingType]][source]
- 
expertise_professional_guilds: onegov.core.orm.mixins.dict_property[collections.abc.Sequence[str]][source]
- 
expertise_professional_guilds_other: onegov.core.orm.mixins.dict_property[collections.abc.Sequence[str]][source]
- 
property expertise_professional_guilds_all: collections.abc.Sequence[str][source]
- 
imported: sqlalchemy.Column[bool][source]
- 
property title: str[source]
- Returns title with lastname in uppercase. 
- 
property lead: str[source]
- 
property full_name: str[source]
- Returns the full name with lastname in uppercase. 
- 
property unique_categories: list[str][source]
- 
nationalities_as_text(locale: str, country_codes: list[str] | None = None) → str[source]
- Returns the translators nationalities as text, translated to the given
locale.
If country_codes e.g. [‘CH’] is given, the given codes are
translated to country names instead.