parliament.models.parliamentarian

Attributes

Gender
GENDERS
SHIPPING_METHODS

Classes

Parliamentarian

Mixin providing a meta/content JSON pair. Meta is a JSON column loaded

Module Contents

type parliament.models.parliamentarian.Gender = Literal['male', 'female']

parliament.models.parliamentarian.GENDERS: dict[Gender, str]

parliament.models.parliamentarian.SHIPPING_METHODS: dict[ShippingMethod, str]

class parliament.models.parliamentarian.Parliamentarian

Bases: onegov.core.orm.Base, onegov.core.orm.mixins.ContentMixin, onegov.core.orm.mixins.TimestampMixin, onegov.file.AssociatedFiles

Mixin providing a meta/content JSON pair. Meta is a JSON column loaded with each request, content is a JSON column loaded deferred (to be shown only in the detail view).

__tablename__ = 'par_parliamentarians'

type: sqlalchemy.Column[str]

__mapper_args__

property title: str

id: sqlalchemy.Column[uuid.UUID]

external_kub_id: sqlalchemy.Column[uuid.UUID | None]

first_name: sqlalchemy.Column[str]

last_name: sqlalchemy.Column[str]

personnel_number: sqlalchemy.Column[str | None]

contract_number: sqlalchemy.Column[str | None]

district: sqlalchemy.Column[str | None]

gender: sqlalchemy.Column[Gender]

property gender_label: str

property formal_greeting: str

Returns the formal German greeting based on gender.

shipping_method: sqlalchemy.Column[ShippingMethod]

property shipping_method_label: str

shipping_address: sqlalchemy.Column[str | None]

shipping_address_addition: sqlalchemy.Column[str | None]

shipping_address_zip_code: sqlalchemy.Column[str | None]

shipping_address_city: sqlalchemy.Column[str | None]

private_address: sqlalchemy.Column[str | None]

private_address_addition: sqlalchemy.Column[str | None]

private_address_zip_code: sqlalchemy.Column[str | None]

private_address_city: sqlalchemy.Column[str | None]

date_of_birth: sqlalchemy.Column[datetime.date | None]

date_of_death: sqlalchemy.Column[datetime.date | None]

place_of_origin: sqlalchemy.Column[str | None]

party: sqlalchemy.Column[str | None]

occupation: sqlalchemy.Column[str | None]

academic_title: sqlalchemy.Column[str | None]

salutation: sqlalchemy.Column[str | None]

salutation_for_address: sqlalchemy.Column[str | None]

salutation_for_letter: sqlalchemy.Column[str | None]

forwarding_of_bills: sqlalchemy.Column[str | None]

phone_private: sqlalchemy.Column[str | None]

phone_mobile: sqlalchemy.Column[str | None]

phone_business: sqlalchemy.Column[str | None]

email_primary: sqlalchemy.Column[str | None]

email_secondary: sqlalchemy.Column[str | None]

website: sqlalchemy.Column[str | None]

remarks: sqlalchemy.Column[str | None]

picture

roles: sqlalchemy.orm.relationship[list[onegov.parliament.models.ParliamentarianRole]]

interests: onegov.core.orm.mixins.dict_property[dict[str, Any]]

active() → bool

active_during(start: datetime.date, end: datetime.date) → bool

commission_memberships: sqlalchemy.orm.relationship[list[onegov.parliament.models.CommissionMembership]]

__repr__() → str