translator_directory.models.translator

Attributes

TranslatorState

Classes

Translator

Mixin providing created/modified timestamps for all records.

Module Contents

type translator_directory.models.translator.TranslatorState = Literal['proposed', 'published'][source]

class translator_directory.models.translator.Translator[source]

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]

comments: sqlalchemy.Column[str | None][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]

operation_comments: 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.