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]
-
es_properties[source]
-
es_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.
-
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.